Advanced Data Engineer (Azure)

$84,636 - $152,566/Yr

Bechtel Plant Machinery - Monroeville, PA

Full-time - Mid Level

Monroeville, PA

Professional, Scientific, and Technical Services

About the position

As an Advanced Data Engineer at Bechtel Plant Machinery, Inc. (BPMI), you will play a crucial role in driving the adoption of usable data to support data analytics and data science initiatives. This position involves reviewing, analyzing, and evaluating business problems to identify and implement viable technical solutions. You will be responsible for developing data structures for both existing and future data, ensuring they are optimized for technical and business data sets.

Responsibilities

• Collaborate with a team of data engineers, data scientists, and business subject matter experts to process and integrate data sources.
• Work closely with data owners to define, manage, and deliver innovative solutions.
• Develop and secure data structures (data lakes, pipelines, dataflows, tables) for existing and future data.
• Contribute actively to code/tool development in projects and services.
• Lead the implementation of data pipelines, dataflows, ETL and ELT processes, and data integration using Azure tools.
• Evaluate and recommend appropriate Azure services and their configuration to optimize data architecture, performance, scalability, and cost-effectiveness.
• Collaborate with infrastructure owners to design and implement robust and scalable Azure data architectures.
• Troubleshoot difficult data issues and perform root cause analysis to proactively resolve issues.
• Help grow a culture focused on data digitization.
• Stay current on data engineering trends and techniques.
• Create documentation for learning and knowledge transfer.

Requirements

• Bachelor's degree in Data Science, Computer Science, Business Intelligence, Engineering or equivalent degree from an accredited college or university.
• A minimum of four (4) years of relevant experience; an advanced degree may be considered in lieu of some years of experience.
• Requires a security clearance; ability to obtain and maintain a Department of Energy security clearance.

Nice-to-haves

• Proven understanding of Data Warehousing, Data Architecture, and ELT/ETL concepts.
• Strong proficiency in Azure Synapse Analytics, Azure Data Factory, Azure Data Lake Storage, Azure SQL DB, Azure Purview, Dataverse, and Power Platform.
• Microsoft DP-203 and/or AZ-305 certifications are a plus.
• Experience with Toad, SQL Management Studio, or other Data Modeling Software.

Benefits

• Competitive and attractive pay and benefits with a stable organization.
• Opportunities to participate in BPMI sponsored committees and clubs.
• Career advancement and professional development programs.