Corporate Data Engineering Specialist

About

McKim & Creed is an employee‑owned firm delivering state‑of‑the‑art engineering and surveying services. With over 1,000 staff across offices in North Carolina, South Carolina, Florida, Louisiana, Virginia, Georgia, Texas, Delaware and Pennsylvania, the company emphasizes a “People Helping People” culture where employees can make a difference from day one.

Responsibilities

• Architect and maintain enterprise data warehouse and data lake solutions within Microsoft Fabric.
• Design scalable, secure, high‑performance data models for analytics and reporting.
• Meet with business unit partners to gather requirements, translate needs into technical specifications, and propose data‑driven solutions.
• 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, IoT, 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.

Requirements

• US citizenship.
• 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.

Preferred Skills & Experience

Technical & Domain Expertise

• 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 DevOps processes.
• Ability to design reusable frameworks for data ingestion and transformation.

Communication & Collaboration

• Ability to translate complex data engineering concepts into user‑friendly explanations.
• Experience facilitating workshops or training sessions.
• Strong documentation, presentation, and storytelling capabilities.

Project Execution & Innovation

• 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.

Benefits

• Employee Stock Ownership Plan (ESOP) – all employees are owners and share in profits.
• Competitive pay and a comprehensive benefits package.
• Multiple office locations and hybrid‑work flexibility.
• Professional development opportunities, including training, mentoring, and tuition reimbursement.
• Work that makes a meaningful impact on the communities served.
• Collaborative, supportive culture aligned with the “People Helping People” mission.
• Recognized as a Great Place to Work.