OverviewAs 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.
Endless perks are available to employees at CEC! Our office boasts a full-scale gym, caf serving breakfast and lunch, and recreation rooms-creating the perfect balance of wellness and productivity. Throughout the year, employees enjoy ping pong, pool, cornhole, and pickleball tournaments as well as the annual summer picnic, themed happy hours, and fun team building activities including go-kart racing and curling! We also understand the importance of reaching beyond the office and giving back to the community-CEC employees volunteer for trail workdays to enhance local parks, maintain a CEC-designed pollinator garden for our office campus, and organize an annual charity golf tournament. At CEC Pittsburgh, we pride ourselves on fostering a culture of connection, collaboration, and growth within the office and in our community.
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
Qualifications- 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
About UsWe 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.
Never miss an opportunity! Create an alert based on the job you applied for.
