The Senior Principal Data Analytics Engineer role at BAE Systems combines software engineering, data analytics, and business intelligence to transform raw data into actionable insights and production-grade analytics layers. This onsite position is based in Nashua, NH, and leads the transition toward a modern, self-hosted analytics infrastructure with secure, governed data for high-stakes decision-making.
RESPONSIBILITIES
- Design and maintain complex data models within a Medallion Architecture, focusing on Silver and Gold layers to deliver optimized datasets for end users.
- Lead the implementation of the core dbt on self-hosted environments such as Postgres, emphasizing modularity, version control, and CI/CD best practices.
- Establish and enforce strict data lineage and cataloging standards to ensure auditability and traceability of key performance indicators.
- Partner with leadership to define a comprehensive data strategy that balances technical debt with rapid analytic value; architect and deploy data tooling in secure, air-gapped or hybrid-cloud environments to ensure stability without constant external connectivity.
- Tune complex SQL queries and optimize data structures to manage large-scale datasets while sustaining cost-efficiency and performance; optimize ingestion and transformation of high-velocity telemetry or sensor data to bridge engineering data with executive BI needs.
- Collaborate with Data Scientists and Business Analysts to understand requirements and provide clean room data environments that support their work.
- Act as the technical authority for the analytics engineering team, setting standards for Python-based automation and SQL documentation.
REQUIREMENTS
- Bachelor’s degree in Computer Science, Engineering, Mathematics, or equivalent experience, or a related technical field.
- 6+ years of professional experience in data or analytics engineering, with a proven record of delivering end-to-end analytics solutions.
- Core Technical Stack:
- Expert SQL with proficiency in window functions, common table expressions, and complex joins.
- Modern Data Stack experience with dbt or a comparable transformation tool, including macros, packages, and custom testing.
- Experience implementing GitOps workflows (GitLab CI or Jenkins) or similar for data pipeline deployment.
- Experience with orchestration tools such as Airflow, Prefect, or Dagster.
- Proven experience implementing Data Quality frameworks and automated testing (dbt tests, Great Expectations, or similar).
- Experience managing data in relational databases such as Postgres, Snowflake, MySQL, or equivalent.
TECHNOLOGIES
Medallion Architecture, dbt, Postgres, GitLab CI, Jenkins, Airflow, Prefect, Dagster, Great Expectations, dbt tests, Snowflake, MySQL, Docker, Kubernetes, Terraform, Pulumi, Python, SQL
BENEFITS
- Health, dental, and vision insurance
- Health savings accounts
- 401(k) savings plan
- Disability insurance
- Life and accident insurance
- Employee assistance program
- Legal plan
- Discounts on home, auto, and pet insurance
- Paid time off
- Paid holidays
- Paid parental leave
- Military leave
- Bereavement leave
- Federal and state sick leave
- Company recognition program with monetary or non-monetary awards
- Additional incentives may be available based on role and specifics
PAY INFORMATION
Full-Time Salary Range: $132,962 – $226,035 per year. Salaries are determined by market structures, internal equity, and factors such as skills, education, and experience, as well as location and business considerations.
EMPLOYEE BENEFITS
- Comprehensive health, dental, and vision coverage for regular employees scheduled to work 20 hours or more per week, plus health savings accounts and a 401(k) plan.
- Disability coverage and life and accident insurance.
- Employee assistance program, legal plan, and additional perks including discounts on home, auto, and pet insurance.
- Leave programs including paid time off, paid holidays, paid parental leave, military leave, bereavement leave, and applicable federal and state sick leave.
- Participation in the company recognition program with monetary or non-monetary awards.
ABOUT BAE SYSTEMS ELECTRONIC SYSTEMS
BAE Systems, Inc. is the U.S. subsidiary of BAE Systems plc, a global defense, aerospace, and security company delivering products and services across air, land, and naval forces, along with advanced electronics and information technology solutions. The organization emphasizes protecting national security through breakthrough technology, superior products, and intelligence solutions, offering opportunities to develop skills on a team making a measurable impact on a global scale. Electronic Systems is the segment responsible for the group’s leading defense and commercial electronics innovations, spanning operations from ocean depths to space, supported by more than 14,000 Electronic Systems professionals.
POSTING
This position will be posted for at least five calendar days. The posting remains active until the role is filled or a qualified candidate pool is identified.
