Advanced Data Engineer (Azure)

Location: Monroeville, Pennsylvania Job Title: Experienced Data Engineer (Azure) Status: Full-time Professional Annual Salary Range: $84,636 - $152,566 *Salary commensurate with education and experience. Job Summary:As an Advanced Data Engineer at BPMI, you will drive the adoption of usable data to support data analytics and data science into BPMI's standard project execution methods and procedures to support initiatives and solve problems. You will review, analyze, and evaluate the scope of business problems presented and identify and execute viable technical solutions. You will be responsible for the development of data structures for existing and future data for use with both technical and business data sets. Essential Duties: Collaborate with a team of other data engineers, data scientists, and business subject matter experts to process data 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 for use with both technical and business data sets. Active contributor 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, including networking, security, and availability considerations. 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. The essential duties identified are representative but are not intended to be an exhaustive or inclusive list of all the responsibilities of the position. What You Can Expect: A culture that values people through recognition of accomplishments, work-life balance, and a sense of community. A diverse group of talented individuals working toward the common goal of supporting the United States Navy in their pursuit of national security. Competitive and attractive pay and benefits with a stable organization. Opportunities to participate in BPMI sponsored committees and clubs, each with their own mission and purpose. Career advancement and professional development programs. Minimum Job 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 year(s) of experience. Requires a security clearance; however, all qualified candidates will be considered regardless of their current clearance status. The ability to obtain and maintain a Department of Energy security clearance is required. Preferred Job Requirements: Proven understanding of Data Warehousing, Data Architecture, and ELT/ETL concepts. Strong proficiency in Azure Synapse Analytics or 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. Why BPMI?Bechtel Plant Machinery, Inc. (BPMI) is a project engineering organization supporting the Naval Nuclear Propulsion Program. BPMI provides design, manufacturing, and supply chain management of the fabrication, testing, delivery, installation, and field support of nuclear power plant components installed in submarines and aircraft carriers. In addition, BPMI provides upgraded replacement components in support of refueling and overhaul activities, and aids in the ultimate storage and disposition of spent naval fuel. BPMI also delivers information technology and operational solutions to the Nuclear Navy, enabling them to fulfill their critical mission. BPMI is a drug-free workplace. Candidates accepting a job offer will be required to pass a pre-placement drug screening and background investigation. As an employee, you may be required to receive and maintain a security clearance from the United States Department of Energy in order to meet eligibility requirements for access to sensitive information or matter. U.S. citizenship is a requirement for security clearance applicants. All employees are subject to being randomly selected for drug testing without advance notification.BPMI is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, gender, sexual orientation, gender identity, age, religion, national origin, ancestry, genetic information, disability, or veteran status.