Data Engineer

Job DescriptionJob Description PURPOSEThe Data Engineer is responsible for designing, building, and maintaining the data pipelines and infrastructure that power Baker Group's Microsoft Fabric data warehouse, serving as the organization's single source of truth. This role owns the ingestion, transformation, and orchestration of data from disparate internal systems (ERP, HRIS, MRP and other structured data sources) into governed, reliable data products used by Data Analysts and developers to deliver insights to executive and operational teams and ensures that data is structured to support both traditional reporting and emerging AI and machine learning use cases. The Data Engineer curates and maintains core datasets spanning employees, finance, construction and manufacturing projects, and service, and partners with the Data Scientist, Data Analyst, and Software Development roles to ensure data is trustworthy, well-structured, and fit for downstream use.ESSENTIAL FUNCTIONS AND RESPONSIBILITIESThe following duties are typical for this job. These are not to be constructed as exclusive or all inclusive. Other duties may be required and assigned.Designs, builds, and maintains ETL/ELT pipelines that ingest data from enterprise systems into Microsoft Fabric.Architects and maintains the Fabric medallion Lakehouse structure (bronze, silver, gold layers) as Baker Group's single source of truth.Develop and implement best practices for the data infrastructure and environment (e.g. Development/Test/Production environments, Git for version control).Owns pipeline orchestration, scheduling, and monitoring to ensure reliable, timely, and accurate data availability.Curates and maintains core datasets across employee, finance, project, service, and manufacturing domains.Establishes and enforces data quality, validation, and reconciliation processes across all pipelines.Designs and manages data models, schemas, and semantic layers that support Data Analyst reporting and Data Scientist modeling work.Defines and maintains data ontologies and canonical business definitions (for example, what constitutes a "project," "employee," or "cost code") to ensure consistent meaning across systems and consumers.Prepares and structures data to support AI and machine learning use cases, including feature-ready datasets, retrieval-augmented generation (RAG) pipelines, and vector embedding storage.Manages Fabric capacity planning, workspace organization, and performance optimization.Implements data governance practices, including access controls, lineage tracking, and metadata management, consistent with Baker Group's data classification standards.Partners with business system owners (ERP, HRIS, MRP, etc.) to understand upstream data structures and manage change impacts.Collaborates with the Data Scientist to ensure pipeline outputs support analytical and machine learning use cases.Collaborates with Data Analysts to ensure data products support paginated reporting, dashboards, and self-service BI needs.Collaborates with Software Development and DevOps Teams to ensure data products support application development needs.Coordinates with 3rd party consultants when necessary to deliver data engineering projects and augment capacity for demanding business needs.Develops and maintains documentation for pipelines, schemas, and integration logic.Troubleshoots and resolves pipeline failures, latency issues, and data quality incidents.Monitors and maintains data-specific infrastructure, including Fabric capacity, pipeline orchestration tools, and monitoring/alerting systems.Evaluates and recommends new data engineering tools, patterns, and best practices.Stays current on emerging trends in data engineering, cloud data platforms, and integration techniques. MINIMUM EDUCATION and EXPERIENCE REQUIRED TO PERFORM ESSENTIAL FUNCTIONSBachelor's degree in Computer Science, Data Engineering, Information Systems, or other relevant quantitative fieldThree to five years of experience in data engineering, ETL/ELT development, or a related fieldProficiency with SQL and database technologies for data extraction, transformation, and loadingExperience with Microsoft Fabric, Azure Data Factory, or similar cloud ETL/orchestration toolsExperience with medallion architecture and modern data warehousing patternsExperience with a programming language such as Python, PySpark, or T-SQL for data transformationFamiliarity with data modeling techniques (dimensional modeling, star schema)Understanding of data governance, data quality, and metadata management practicesExperience preparing data for AI/ML consumption (e.g., vector embeddings, RAG architectures) is a plusBusiness acumen and understanding of construction or related industries is a plus CERTIFICATES, LICENSES, REGISTRATIONSNo specific requirements; however, relevant certifications such as Microsoft Certified: Fabric Data Engineer Associate, Azure Data Engineer Associate, or similar cloud platform certifications are a plusMENTAL AND PHYSICAL COMPETENCIES REQUIRED TO PERFORM ESSENTIAL FUNCTIONSStrong analytical and troubleshooting skills with the ability to diagnose and resolve complex pipeline and data quality issuesExcellent time and project management skills with the ability to prioritize across multiple pipeline and infrastructure projectsCurrent with industry trends in data engineering, cloud platforms, and integration best practicesStrong communication skills with the ability to translate technical data structures for non-technical stakeholdersTeam player with strong collaboration skills, particularly with the Data Scientist, Data Analysts, and business system ownersMust be able to focus on complex technical problems and work independently with minimal supervisionAbility to work in a fast-paced environment and adapt to changing business prioritiesMeticulous attention to detail and commitment to producing reliable, well-documented data infrastructure ENVIRONMENTAL ADAPTABILITYProlonged periods of sitting at a desk and working on a computerMust be able to lift 10 pounds occasionallyMay have occasional visits to a job site which would require periods of standing, walking and/or climbing stairs EQUIPMENT/TOOLSUse a computer for 8 hours a day Baker Groupis an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, Baker Group will consider reasonable accommodations for qualified individuals with disabilities and encourage prospective employees and incumbents to discuss potential accommodations with the Employer.