Enterprise Data Engineer (Azure & Dynamics 365)

Gulf Coast Automation Group • Deerfield, IL

6h • $120,000 - $140,000 • Hybrid

About The Position

The Enterprise Data Engineer will be responsible for building and optimizing the organization's data infrastructure in support of a large-scale enterprise systems transformation initiative. This initiative focuses on implementing Microsoft Dynamics 365 to unify systems, standardize processes, and improve real-time data visibility across the organization. In this role, the Data Engineer will design, develop, and maintain robust data pipelines and centralized data platforms (data lake and data warehouse), consolidating data from Dynamics 365 and legacy systems into a scalable, unified source of truth.

Requirements

• Undergraduate degree or equivalent in Computer Science, Information Systems, or a related field required.
• 3–5 years of hands-on experience in the design, development, and support of data pipelines (ETL/ELT processes).
• 3–5 years of experience writing and optimizing SQL (T-SQL) queries and working with Microsoft SQL Server or similar relational databases.
• 1–3 years of experience in data modeling and database design.
• Strong SQL programming skills, particularly with Microsoft SQL Server, including the ability to write efficient T-SQL queries, create stored procedures, and perform performance tuning on database operations.
• Hands-on experience with Azure Synapse Analytics or similar cloud data warehousing technologies, including using Synapse or Azure Data Factory to create and orchestrate data pipelines, transform data at scale, and manage data lakes/warehouses.
• Familiarity with Microsoft D365 (Dynamics 365 Finance & Operations, and/or Customer Engagement) or similar ERP/CRM systems.
• Proficient in Microsoft Power BI or comparable BI visualization tools, including an understanding how Power BI datasets and dataflows work.
• Strong understanding of data modeling concepts and tools.
• Experience with master data management or data cataloging in a unified data environment.
• Familiarity with data quality and profiling tools (i.e. using SQL or Python to implement data validation).
• Comfort with a programming or scripting language (e.g., Python, PySpark, or SQL scripts) to transform and manipulate data within pipelines.

Nice To Haves

• Prior experience in private equity backed industrial or multi-business-unit companies is a plus.
• Knowledge of DAX and Power BI performance tuning is a plus, as is experience with SSRS or other Microsoft BI stack components (e.g. SSIS/SSAS).

Responsibilities

• Design, build, and maintain ETL/ELT processes that ingest and transform data from multiple sources (including Microsoft Dynamics 365 ERP and legacy systems) into the organization's Azure Synapse data lake and data warehouse.
• Implement data cleansing, validation rules, and quality checks to ensure data from various business units and systems is accurate, consistent, and ready for enterprise reporting and analytics.
• Contribute to the design and expansion of enterprise data models and schemas (e.g., star schema in the data warehouse) to support evolving reporting needs and standardized business processes.
• Partner with analytics and BI teams to enable self-service reporting and advanced analytics capabilities.
• Prepare curated datasets for Power BI dashboards by writing efficient SQL queries and developing new data pipeline components as needed.
• Collaborate with cross-functional teams—including business analysts, data scientists, and ERP specialists—to understand data requirements tied to enterprise system implementations and business initiatives.
• Follow and promote best practices in data engineering and analytics development (version control, code reviews, documentation) while continuously optimizing existing data processes.

Benefits

• This role qualifies for full comprehensive employee benefits such as medical, dental, vision and life insurance, 401(k), paid time off (PTO) and more!

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level