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.

DURING YOUR WORK DAY, YOU WILL:

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:

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

WHAT WE OFFER: 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 work from: Stick close to home or travel for a change of scenery.
• Growth opportunities & training: Grow confidently in your career with our mentoring & training options.
• Professional development: Tuition reimbursement, early career professional program, online courses & more.
• Work that makes a difference: See the direct impact your work has on our communities.
• Collaborative, supportive team: People to help you solve problems, cheer successes & encourage you along the way.

McKim & Creed is an Equal Opportunity and Affirmative Action Employer, and VEVRAA Federal Contractor and will consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status or disability status and maintains a Drug Free Workplace.