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

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 logic
• Develop data products and shared semantic layers for analytics and downstream apps
• Optimize performance and cost (storage formats, Z-order, indexing, caching, workload management)
• Implement CI/CD (Azure DevOps/GitHub) for notebooks, pipelines, and BI artifacts
• Enforce security (RBAC/ABAC), data quality checks, and privacy/compliance
• Manage Purview: collections, scans, lineage, classifications, and ownership workflows
• Collaborate with other analysts and engineers to automate operations and enable self-service
• Provide architectural guidance and mentor junior engineers to build team capability
• Communicate technical decisions and trade-offs clearly to stakeholders
• Lead 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 collaboration

• Bachelor's degree in Data Science, Computer Science, or a related field. Additional experience may be substituted for education
• 5+ 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 Server
• Strong 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 required
• Production experience with data modeling and serving layers for BI/AI
• Experience with Kafka, Event Hubs, or other real-time streaming platforms
• Strong interpersonal, written, and oral communication skills
• Self-motivated and directed

We 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 RECRUITERS

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