> Markdown version of [/jobs/ext/1273342-curated-data-integration-engineer](https://www.wearedevelopers.com/jobs/ext/1273342-curated-data-integration-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Curated Data Integration Engineer - **Company:** Hollstadt Consulting - **Location:** Minneapolis, MN, United States - **Experience:** Experienced - **Salary:** $135,907.0 - **Contract:** Permanent contract - **Skills:** Geographic Information Systems, ArcGIS (Software), Business Intelligence Development, Data Cleansing, Data Deduplication, Information Engineering, Data Integration, Data Warehousing, Database Queries, Apache Hive, PostGIS, Power BI, SQL Databases, Data Streaming, Azure Data Factory, Apache Spark, Build Management, Data Lakes, Pyspark, Data Management, Azure Synapse Analytics, Serverless Computing - **Published:** July 15, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=bf4736e75e8e74bc ## About the Role * 4+ years of experience in data engineering or BI development. * Strong understanding of data warehouse/lakehouse concepts. * Proficient in Azure Synapse Analytics and Delta Lake format. * Strong SQL skills and experience with PySpark or Spark SQL. * Familiarity with Master Data Management principles. * Ability to write clear documentation and understand business context. Desired Skills: * Experience in medallion architecture (Raw/Enriched/Curated). * Experience with Profisee MDM or similar tools; GIS data exposure (ArcGIS, PostGIS). * Knowledge of Power BI and its integration with Azure Synapse. * Azure Data Engineer Associate certification or similar. * Experience in regulated industries. Benefits + Perks ## Description This client is seeking a Curated Data Integration Engineer to transform cleansed data into business-ready, Curated (Gold) layer datasets for analytics and reporting. This role involves: * Combining and refining data from the Enriched (Silver) zone. * Applying master data management rules and integrating geospatial context. * Building Delta Lake tables and SQL views as a single source of truth. * Ensuring data quality, consistency, and readiness for consumption. * Collaborating with the Profisee MDM system and Enterprise GIS team. * Supporting situational awareness use cases such as airport dashboards and KPI reports. Work Description / Deliverables: * Design and build denormalized tables, star-schema models, and consolidated views. * Optimize Curated Delta tables for Synapse serverless SQL pools and Power BI. * Apply MDM and data quality rules using Profisee MDM. * Implement data cleansing, deduplication, and consistency checks. * Integrate geospatial attributes for situational awareness. * Translate stakeholder needs into aligned data models. * Develop and maintain data pipelines using Synapse Spark notebooks, SQL scripts, or Synapse data flows. * Implement validation checks and document solutions. ## Related Videos - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Tracking vehicles at scale](https://www.wearedevelopers.com/videos/1999-tracking-vehicles-at-scale) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)