McKim & Creed, Inc. · 4 hours ago
Corporate Data Engineering Specialist
Raleigh, NC
Full-time
Hybrid
Mid LevelMcKim & Creed, Inc. is an employee-owned firm known for its exceptional engineering and surveying services. As a Corporate Data Engineering Specialist, you will design, develop, and maintain data solutions that empower business units with actionable insights, focusing on enterprise data warehousing and analytics.
Consulting
Responsibilities
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
Qualification
Required
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
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
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
Benefits
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.
Company
McKim & Creed, Inc.
McKim & Creed is a civil engineering company that offers engineering, surveying, and planning services.
Founded in 1978
501-1000 employees
H1B Sponsorship
McKim & Creed, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (2)
2023 (5)
2022 (3)
2021 (2)
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Street Lee
President & CEO
David D. Quinn
Executive Vice President & Chief Financial Officer
Recent News
Company data provided by crunchbase