Principal Data Engineer
Principal Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 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
- Bachelors degree in Computer Science Information Systems Engineering or a related field.
- 36 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.
Required Experience:
Staff IC
Employment Type
Full-Time
