At a Glance
- Tasks: Own the metrics layer on AWS, design star schemas, and build impactful dashboards.
- Company: Join a forward-thinking tech company focused on data-driven solutions.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Other info: Dynamic team environment with a focus on innovation and collaboration.
- Why this job: Make a real impact by shaping analytics and driving business decisions.
- Qualifications: 10+ years in analytics engineering with strong SQL and Python skills.
The predicted salary is between 60000 - 80000 £ per year.
You will own the semantic modelling and governed metrics layer on AWS, building robust modular transformations and facilitate analytics.
You will ensure trust in metrics, performance at scale, and effective stakeholder enablement.
Key responsibilities Modelling and ELT: design star schemas and domain marts; implement tests (schema, data, freshness), documentation, and incremental strategies.
Metrics governance: Define and version business metrics (owners, contracts, change control); implement semantic layer (dbt Semantic Layer/Metric Flow) and ensure consistency across BI.
BI delivery: Support building BI datasets and dashboards; implement RLS/column level security; optimise SPICE, query performance, and UX.
Quality and reliability: Add DQ checks in pipelines; monitor freshness and accuracy; partner with Core Data Engineer on upstream contracts and SLAs.
CI/CD and workflow: Git driven development, PR reviews, environment promotion; automate model validation and BI artefact deployment.
Performance tuning: Redshift sort/dist keys, WLM/concurrency scaling; Athena partitioning and file formats for efficient queries.
Enablement: Translate requirements, document definitions, run training, and maintain a catalogue of metrics/datasets in Glue Catalog.
Outcomes (first 60–90 days) Ship a governed KPI suite (metric catalogue + dbt models) and at least two business critical dashboards with RLS.
Establish CI/CD for analytics repo with automated tests and promotions; reduce dashboard query times via model and dataset tuning.
Publish clear documentation for metrics, dimensions, lineage, and ownership.
Skills and experience 10+ years in analytics engineering; expert SQL, solid Python; strong semantic data modelling and documentation.
Clear understanding of ABAC on Data products. 3+ years in dbt (models/macros/tests/exposures) or Glue Data Governance, Redshift/Serverless and/or Athena; Glue Catalog integration.
AWS SMUS/Datazone experience strongly preferred. 3+ years delivering governed data products on cloud. 5+ years working with designing data architecture on medallion architecture.
Version control and CI/CD (Git Hub); YAML/Jinja proficiency.
Metric governance and change management; stakeholder engagement and requirements translation.
Nice to have Experience with dbt Semantic Layer/Metric Flow, Quick Sight Q Familiarity with Lake Formation policies and policy as code approaches.
Experience with data mesh/domain ownership and feature store patterns (Sage Maker Feature Store) #J-18808-Ljbffr
Analytics Engineer (AWS) employer: BULLIT MANAGEMENT SERVICES LIMITED
As an Analytics Engineer (AWS) at our company, you will thrive in a dynamic work culture that prioritises innovation and collaboration. We offer competitive benefits, including professional development opportunities and a commitment to employee growth, ensuring you can advance your career while contributing to impactful projects. Located in a vibrant area, our workplace fosters creativity and teamwork, making it an excellent environment for those seeking meaningful and rewarding employment.
Contact Details:
BULLIT MANAGEMENT SERVICES LIMITED Recruitment Team
