Data Engineer

As a Data Engineer, you will design, build, and optimize data architectures and pipelines across Microsoft Fabric and Azure in our Pittsburgh, PA office. You will develop scalable data transformation processes using Data Factory, jupyter notebooks, and SQL, while enabling reliable, automated, and well‑governed data operations. This role plays a key part in advancing DataOps practices—including DevOps, CI/CD, and governance through Microsoft Purview—while supporting a modern analytics ecosystem. Experience with Power Automate and Copilot agents is a plus.At CEC, our employees enjoy a flexible/hybrid work schedule. Our comprehensive benefits package includes bonus recognition, based on performance, as well as participation in our employee stock ownership program. Additionally, we conduct mid-year and end-of-year performance reviews and provide goal-setting opportunities.Responsibilities:Architect and implement Lakehouse/Warehouse solutions in Fabric (medallion patterns, Delta tables, partitioning, CDC)Build and orchestrate pipelines (Fabric Data Factory/Pipelines, notebooks, event-driven patterns) with robust observability and retry logicDevelop data products and shared semantic layers for analytics and downstream appsOptimize performance and cost (storage formats, Z-order, indexing, caching, workload management)Implement CI/CD (Azure DevOps/GitHub) for notebooks, pipelines, and BI artifactsEnforce security (RBAC/ABAC), data quality checks, and privacy/complianceManage Purview: collections, scans, lineage, classifications, and ownership workflowsCollaborate with other analysts and engineers to automate operations and enable self-serviceProvide architectural guidance and mentor junior engineers to build team capabilityCommunicate technical decisions and trade-offs clearly to stakeholdersLead development, configuration, and maintenance of solutions within the Microsoft Power Platform ecosystem, which may include Power Apps, Power Automate, and SharePoint. Use these tools to streamline workflows, enhance data accessibility, and improve collaborationBachelor’s degree in Data Science, Computer Science, or a related field. Additional experience may be substituted for education5+ years of experience as a data engineer/architect on Microsoft Fabric and Azure. Hands-on experience with Microsoft Purview (catalog, policies, lineage)Python, PySpark, Spark notebooks (structured/streaming), and SQL/SQL ServerStrong experience with ETL/ELT design, performance tuning, and workload orchestration. DevOps/CI/CD practices (branching, environments, automated testing/deploy). Experience with GIT or other code repositories is requiredProduction experience with data modeling and serving layers for BI/AIExperience with Kafka, Event Hubs, or other real-time streaming platformsStrong interpersonal, written, and oral communication skillsSelf-motivated and directedWe have experts! CEC is consistently ranked as a Top 500 Design Firm and Top 200 Environmental Firm by Engineering News-Record. We are looking for people who enjoy using their education and experience to solve difficult technical problems and work on interesting projects. You can accomplish this while working with a team of professionals who are equally motivated to provide high levels of service to our clients and to teach you along the way.We have support! We have a variety of Employee Resource Groups, including CEC Community - focused on giving back to the communities in which we work; CEC Ignite - focused on helping professionals early in their careers to develop their pathway; CEC iDEA - focused on inclusion, diversity, equality, and acceptance; and CEC Women - focused on creating internal and external opportunities for women to network and leverage professional experience! We care about our people! People and Culture are two of the five elements of our strategic plan. When you care about your people, they will want to grow a career with you - that is our goal. CEC offers you a small-firm work environment with large-firm opportunities. Not only will we help you develop professionally, but we will also provide an opportunity to become an owner of the firm and share in its success. CEC offers a matching 401(k); profit sharing; a performance bonus; company stock; medical, dental, and vision insurance; short and long-term disability; tuition assistance; professional development; and work-life balance. CEC is an equal opportunity employer. We do not discriminate in recruiting, hiring or promotion based on race, color, religion, sex, national origin, age, disability, protected veteran status or any other basis or characteristic prohibited by applicable federal, state, or local law.THIRD PARTY RECRUITERSIf CEC has not expressly requested recruiting services or contractually engaged with you for recruiting services on a specific position, any resumes or candidate profiles sent to CEC shall be considered unsolicited. Therefore, any such submissions will be considered property of CEC, with no associated fees due to your firm.

Created: 2026-02-13