ETL & AI Data Engineer

Company Description

IMPACCT is a pioneering digital platform designed to revolutionize the construction and infrastructure industry. Known as the Bloomberg of Construction, IMPACCT provides real-time access to comprehensive market data, analytics, and industry trends, empowering professionals to make informed decisions and improve operational efficiency. The platform leverages advanced technologies to offer actionable insights across all stages of the project lifecycle, from planning and execution to monitoring and compliance. IMPACCT is committed to helping the construction industry build smarter, safer, and more sustainable projects through data-driven intelligence and innovation.

Role Description

Build the backbone of intelligent infrastructure.

We're looking for an innovative ETL & AI Data Engineer to help us power a new era of construction and infrastructure intelligence. You'll be responsible for transforming fragmented data into structured knowledgefueling everything from business dashboards to AI-powered decision tools like RAG systems and query bots.

What You'll Be Doing

• Design and implement scalable ETL pipelines to extract, transform, and load data from multiple structured and unstructured sources (APIs, SQL, flat files, web scrapers, etc.)
• Build and manage a RAG (Retrieval-Augmented Generation) database framework to support AI-assisted querying, ensuring semantic search and document relevance scoring
• Develop AI-enabled data query tools using Python and LLM-based prompt engineering to allow natural language queries over structured data
• Write optimized SQL (MySQL/PostgreSQL) queries for data retrieval and preprocessing
• Automate data workflows via Python scripts and Excel VBA where applicable, improving reliability and reducing manual tasks
• Collaborate across teams (Product, Tech, Business) to deploy data-driven tools, APIs, and backend integrations
• Ensure data accuracy, governance, and security across all pipelines and outputs
• Continuously refine our data stack, introducing modern practices in versioning, validation, and observability

What You Should Know

• Proficiency in SQL, Python, and Excel VBA
• Experience with data warehousing, ETL automation, and API data ingestion
• Familiarity with LLMs, vector databases (e.g., FAISS, Chroma, Pinecone), or LangChain-like frameworks
• Bonus: Experience with unstructured data processing (PDFs, text scraping) and semantic search tools
• Comfortable operating in a startup-like environment, wearing multiple hats and moving fast

Why Join Us

You'll play a central role in shaping the data architecture of an AI-powered infrastructure platform that's transforming how projects are planned, tracked, and executed. This is not just ETLit's enabling the future of decision-making.

Apply now or tag someone who might be a great fit. Let's build something intelligent together.

Qualifications

• Experience with Data Engineering, Data Modeling, and Data Warehousing
• Proficiency in Extract Transform Load (ETL) processes
• Skills in Data Analytics and algorithm development
• Strong problem-solving and analytical skills
• Proficiency in SQL and knowledge of big data technologies
• Excellent communication and teamwork skills
• Bachelor's or Master's degree in Computer Science, Engineering, or related field
• Experience in the construction or infrastructure industry is a plus