In Nashua, New Hampshire, on-site at BAE Systems, this Senior Principal Data Analytics Engineer role sits at the intersection of software engineering, data analytics, and business intelligence. The position focuses on converting raw data into actionable insights, building production-grade analytics layers, and guiding the transition to a secure, self-hosted analytics infrastructure that supports high-stakes decision making.
Responsibilities
- Design and maintain sophisticated data models within a Medallion Architecture, centering on the Silver and Gold layers to deliver streamlined datasets for end users.
- Oversee the deployment of dbt core on self-hosted platforms such as Postgres, prioritizing modular design, version control, and CI/CD best practices.
- Establish and enforce rigorous data lineage and cataloging standards to ensure auditability and traceability of mission-critical KPIs.
- Collaborate with leadership to craft a data strategy that balances technical debt with rapid analytic value, and design and deploy data tooling in secure, air-gapped, or hybrid-cloud environments to ensure stable updates with limited external connectivity.
- Tune complex SQL queries and data structures to handle large-scale datasets while maintaining cost-efficiency and performance; optimize the ingestion and transformation of high-velocity telemetry or sensor data to bridge raw engineering data with executive BI.
- Partner with Data Scientists and Business Analysts to understand requirements and provide clean-room data environments they need to succeed.
- Serve as the analytics engineering team's technical authority, establishing standards for Python automation and SQL documentation.
Requirements
- Bachelor’s degree in Computer Science, Engineering, Mathematics, or equivalent technical experience.
- 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, CTEs, and complex joins.
- Modern data stack experience with dbt or a comparable transformation tool, including macros, packages, and custom tests.
- Experience implementing GitOps workflows (GitLab CI/Jenkins) or equivalent for data pipeline deployment.
- Familiarity with orchestration tools such as Airflow, Prefect, or Dagster.
- Proven background implementing Data Quality frameworks and automated testing (dbt-tests, Great Expectations, or similar).
- Experience managing data in Postgres, Snowflake, MySQL, or similar relational databases.
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 coverage
- Health savings accounts
- 401(k) retirement plan
- Disability insurance
- Life and accident insurance
- Employee assistance program
- Legal plan
- Discounts on home, auto, and pet insurance
- Paid time off and paid holidays
- Paid parental leave
- Military leave and bereavement leave
- Federal and state sick leave
- Company recognition program with monetary or non-monetary awards
Salary
Full-time salary range: $132,962 to $226,035 per year. The published range reflects market pay structures; actual compensation is determined by factors including skills, education, experience, internal equity, and local market conditions.
Posting details
This position will be posted for at least five calendar days and will remain active until filled or a qualified candidate pool is identified.
About BAE Systems Electronic Systems
BAE Systems, Inc. represents the U.S. subsidiary of BAE Systems plc, a global defense, aerospace, and security company delivering products and services for air, land, and naval forces, along with advanced electronics, security, information technology solutions, and customer support. The organization is dedicated to improving the future and protecting lives through breakthrough technology and intelligent solutions on a global scale. Working here means contributing to national security with innovative technology and trusted teams, with opportunities to grow and make a meaningful impact. Electronic Systems is the global innovator behind BAE Systems’ game-changing defense and commercial electronics, driving capabilities from the depths of the ocean to the far reaches of space, supported by a workforce of thousands of highly skilled professionals dedicated to making a difference.
