Corporate Data Engineering Specialist

What if you had the opportunity to do something you love and make a difference in people's lives at the same time? McKim & Creed is a company of People Helping People. And that's what gets us energized. That's why we're excited to get up and go to work every day.

McKim & Creed is a unique, employee-owned firm with a reputation for extraordinary state-of-the-art engineering and surveying services provided by exceptional employees. We have over 1000 staff members in offices in North Carolina, South Carolina, Florida, Louisiana, Virginia, Georgia, Texas, Delaware and Pennsylvania. If you want to work at a company where you can make a difference on day one, we're glad you found McKim & Creed.

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

Key Responsibilities

Data Architecture & Solution Design

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

ETL / ELT Development & Integration

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

Analytics Enablement & Dashboard Development

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

Platform Integration & Technical Enablement

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

Strategic Collaboration & Continuous Improvement

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

Education, Communication & Knowledge Sharing

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

WHAT YOU'LL NEED

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

WHAT WE OFFER

• Employee Stock Ownership Plan (ESOP): All employees are owners & benefit from profits earned.
• 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 we serve.
• A collaborative, supportive culture aligned with our "People Helping People" mission.
• Check this out: A Great Place to Work