Bath Iron Works is looking to transform its data architecture and drive data-driven decision making across the company by building out a data warehouse and associated data marts.
Requirements
- 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.
- Working knowledge of Azure data services, especially Azure Data Factory, Azure Storage, and Azure SQL.
Responsibilities
- 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.
Other
- 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.
- Collaborate with data analysts, architects, software engineers, and business stakeholders to understand data requirements.
- Participate in code reviews, project planning, and technical discussions.
- Basic understanding of Azure networking, security, and resource management.
