Corporate Data Engineering Specialist

OVERVIEW

As a Corporate Data Engineering Specialist, you will design, develop, and maintain modern data solutions that empower business units with actionable insights. This role focuses on enterprise data warehousing, Microsoft Fabric, Power BI dashboard development, and end-to-end ETL/ELT processes. You will partner closely with business stakeholders to understand their needs, architect scalable solutions, and implement data-driven systems that support decision-making across the organization.

• Architect and maintain enterprise data warehouse and data lake solutions within Microsoft Fabric.
• Design scalable, secure, and high-performance data models to support analytics and reporting.
• Meet with business unit partners to gather requirements, translate needs into technical specifications, and propose data-driven solutions.
• Ensure alignment between business goals and technical implementation.

• Develop, automate, and optimize ETL/ELT pipelines using Fabric Data Factory, Synapse Data Engineering, or comparable tools.
• Integrate data from multiple systems (ERP, financial, project management, operational systems, IoT sources, etc.).
• Maintain data quality through validation, cleansing, and monitoring processes.
• Troubleshoot data ingestion and transformation issues across environments.
• Build interactive, accurate, and visually compelling Power BI dashboards and reports.
• Create and maintain semantic models and datasets in alignment with governance standards.
• Optimize dataflows and Power BI refresh strategies for performance and reliability.
• Partner with analysts and business units to ensure dashboards meet operational and strategic needs.

• Integrate Fabric-based solutions with enterprise applications, databases, and cloud platforms.
• Work with IT teams to enable secure, governed, and scalable deployment pipelines.
• Participate in establishing data governance standards, including lineage, security, and quality rules.
• Provide guidance on best practices for data engineering using Microsoft Azure and Power Platform.
• Collaborate with cross-functional teams (Finance, Operations, HR, Engineering, etc.) to identify high-value analytics opportunities.
• Analyze and recommend improvements in data architecture, processes, and tooling.
• Stay current with trends in data engineering, Microsoft Fabric, and BI technologies.
• Assist with prioritizing the data & analytics backlog based on business impact.

• Maintain documentation for data models, ETL pipelines, and reporting assets.
• Deliver training sessions, Lunch & Learns, and onboarding support for Power BI and Fabric data tools.
• Explain technical concepts in accessible terms to non-technical stakeholders.
• Create guidance on data visualization, modeling, and analytics best practices.

• Hands‑on experience with data warehousing concepts, dimensional modeling, and data architecture.
• Strong proficiency in Microsoft Fabric components (Data Factory, Lakehouse, Synapse Data Engineering, Power BI, Data Activator).
• Experience designing and developing Power BI dashboards, datasets, and dataflows.
• Demonstrated ability to build and maintain ETL/ELT pipelines.
• Strong SQL skills and familiarity with Python or other scripting languages.
• Ability to collaborate with business teams to gather requirements and design solutions.
• Comfortable working with large datasets and optimizing performance.
• Strong communication skills and ability to present technical concepts clearly.
• Familiarity with cloud platforms such as Azure.
• Understanding of data governance, security, and lifecycle management.
• Valid driver's license and ability to travel occasionally as needed.

• Experience with enterprise analytics platforms, data lakes, or modern cloud data stacks.
• Knowledge of Power Platform (Power Apps, Power Automate) integrations.
• Exposure to ERP, financial, or project management system data structures.
• Familiarity with version control, CI/CD pipelines, and Dev Ops processes.
• Ability to design reusable frameworks for data ingestion and transformation.
• Ability to translate complex data engineering concepts into user-friendly explanations.
• Experience facilitating workshops or training sessions.
• Strong documentation, presentation, and storytelling capabilities.
• Ability to manage multiple initiatives and balance priorities.
• Demonstrated experience in rapid prototyping or iterative project delivery.
• Passion for learning emerging technologies and recommending innovative solutions.

Join a company that puts its employees first. Ranked as one of the Best Firms to Work For, here are just some of the reasons to become part of the McKim & Creed team:

• Employee Stock Ownership Plan (ESOP): All employees are owners & benefit from profits earned.
• Competitive pay
  :
  Paid holidays, bereavement, and parental, medical, and military leave.
• Multiple office locations to…