Principal Data Engineer

Job Description

We are seeking a skilled Data Engineer to join the Data Services team at Bath Iron Works. This role will help transform our data architecture and drive data-driven decision making across the company. In this role you will play an important part in the build-out of our data warehouse and associated data marts. You will also work with business stakeholders throughout the development process to ensure that the created data products align with the business need. 

The ideal candidate will have hands-on experience in relational databases like SQL Server and Oracle, strong Python skills for data processing and automation, and a foundation in SDLC best practices. You will play a key role in designing, building, and maintaining scalable and reliable data pipelines that support business intelligence and analytics.

Responsibilities include, but are not limited to:

• Design, develop, and maintain robust ETL/ELT pipelines using SSIS, Python, and SQL.
  • Extract data from various structured sources including SQL Server and Oracle.
  • Cleanse, transform, and load data into target systems (e.g. data lakes or warehouses).
• Write optimized SQL queries, stored procedures, and functions in SQL Server and Oracle.
• Perform data modeling, indexing, partitioning, and performance tuning.
• Ensure high data quality, consistency, and integrity through validation routines and monitoring.
• Follow best practices for data security, compliance, and documentation.
• Collaborate with data analysts, architects, software engineers, and business stakeholders to understand data requirements.
• Participate in code reviews, project planning, and technical discussions.

Required/Preferred Education/Training

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.
• 3–6 years of professional experience as a Data Engineer, Database Developer, or similar role.

Required/Preferred Experience

Required Experience

• Strong hands-on experience with SQL Server and Oracle.
• Proficiency in T-SQL and PL/SQL.
• Solid programming experience with Python
• Experience writing scripts for data manipulation, automation, and orchestration.
• Familiarity with ETL tools or frameworks (e.g., Azure Data Factory, SSIS, or custom Python pipelines).
• Familiarity with version control tools like Git.

Preferred Experience

• Working knowledge of Azure data services, especially Azure Data Factory, Azure Storage, and Azure SQL.
• Basic understanding of Azure networking, security, and resource management.
• Understanding of CI/CD pipelines.