Civil & Environmental Consultants, Inc.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.
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 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 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.
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.
¿Te interesa este puesto?