More jobs:
Senior Analytics Engineer; AWS
Job in
Town of Poland, Jamestown, Chautauqua County, New York, 14701, USA
Listed on 2026-07-10
Listing for:
Xebia
Full Time
position Listed on 2026-07-10
Job specializations:
-
Software Development
Data Engineering
Job Description & How to Apply Below
Location: Town of Poland
You will be:
- building and maintaining the canonical business model on Iceberg: governed entities and the relationships needed for project performance reporting, stable across changes in the underlying source storage,
- developing curated data marts,
- modeling the assembly and sub-assembly hierarchy from the Neptune graph, required for BOM and project reporting,
- structuring dbt projects across staging, intermediate, and marts layers using (), macros, and packages to eliminate duplication,
- implementing the data quality framework: schema and freshness tests, dbt-expectations assertions, and dbt-elementary observability feeding a single quality gate,
- handling schema evolution to prevent reporting disruptions: versioning tables, applying data contracts, and managing structural changes on a case-by-case basis,
- contributing dbt models to the CI/CD pipeline (slim builds, linting, PR reviews) and supporting scheduled orchestration through Airflow and Cosmo,
- collaborating with Data Analysts on mart design and with Data Engineers on upstream data structures; supporting client knowledge transfer.
- advanced SQL and strong data modeling skills (dimensional, canonical, medallion-style layering),
- experience with dbt (dbt-core), including tests, macros, sources, and documentation,
- experience with Apache Iceberg and Athena in an AWS lakehouse environment,
- familiarity with analytics engineering practices: version control, code review, and modular design,
- previous exposure to dbt adapters for AWS (dbt-athena, dbt-glue), dbt-expectations, and dbt-elementary; experience with Airflow orchestration, ideally Astronomer Cosmos,
- understanding of partitioning and pre-aggregation techniques for SLA-driven performance,
- Python skills for supporting transformations and tooling.
Work from the European Union region and a work permit are required.
Nice to have:- previous exposure to graph data (Neptune) and CDC-driven data,
- Snowflake and Sigma experience, given Xebia's partnership and likely future work.
Position Requirements
10+ Years
work experience
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×