Curated Data Integration Engineer

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.

• 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

Pulled from the full job description

• Continuing education credits
• Health insurance
• 401(k) matching
• Vision insurance
• Dental insurance
• Paid sick time
• Life insurance, Hollstadt offers medical, dental, vision, life insurance, short-term disability, long-term disability, paid sick leave, and retirement benefits to eligible employees. With three different medical plans to choose from, you can enroll in the coverage you need from individual to family, or anywhere in between!

Remarketing Process

Hollstadt is based on retention and relationships. We get to know your strengths and career wishes throughout your assignment and then start remarket discussions 6-8 weeks prior to your end date. By being proactive, we are able to keep your down time between assignments as short as possible, unless you choose otherwise.

Professional Development

Hollstadt offers on-demand training through our consultant portal. Trainings give our consultants the continuing education they need to excel on their projects. Many of our courses apply towards continuing education credits and we have an entire training hub dedicated to upskilling in Artificial Intelligence (AI).

401k + Matching

One popular benefit is our 401(k) match on the first 4% of your contributions. Hollstadt wants to help you reach your long-term financial goals and understands that planning for your future is critical. Consultants also have access to support from a Financial Advisor.

Bonus Opportunities

We appreciate and reward loyalty. Join Hollstadt, stay for 5 years, and we'll give you a $5,000 Longevity Award bonus! Additionally, we know great talent knows other great talent. If you are on contract with Hollstadt and refer one of your connections who gets placed, we'll pay you $1,000!

Ongoing Support & Networking

We have made a significant investment in building a support program for our consultant team - so you never have to feel like you are going it alone. We also have a Consultant Coach program which acts like a 'work buddy' to provide a safe ear for questions or concerns at your client site.

Hollstadt Consulting is a management and technology consulting firm dedicated to placing professionals at engagements where they will excel. When you work with us, you'll work with a refreshingly real company led and staffed by seasoned experts who are also down-to-earth, good people. We're committed to treating you with respect and helping you achieve your career aspirations. Since 1990, Hollstadt has been a trusted partner to more than 150 domestic and global companies and has successfully completed over 3,000 projects. Our continued growth has created challenging and rewarding opportunities for accomplished IT and Business Consultants. Hollstadt Consulting is an equal opportunity employer including disability/veteran. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Hollstadt Consulting and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel at any time.