Remote Data Analytics Engineer (SQL & Redshift)

HR Talent Partner SA; United States; Remote; USD 90,000 - 150,000; Full time

Job summary

HR Talent Partner SA seeks a Data Analytics Engineer to design and implement data warehouse solutions for reporting across finance, operations and regulatory domains. The role emphasizes building Redshift models, iterative design, and collaboration with analysts and client stakeholders in a remote setting.

You will work on data ingestion, transformation, and BI layer development using AWS Glue, Redshift, and QuickSight, with a strong emphasis on code quality, testing, and clear documentation.

Qualifications

• - 4+ years in data engineering, analytics engineering or another strongly SQL-based data role.
• - Advanced SQL: modular and layered model design, window functions, complex joins and aggregations, and query performance tuning.
• - Hands-on cloud data warehouse experience, ideally Redshift. Strong Snowflake, BigQuery or Synapse experience will be considered, provided you understand distribution and sort key style optimisation or its equivalent
• - Python for ETL and data transformation work, whether in Glue, PySpark, pandas or a comparable setting
• - Practical experience with AWS data services such as Redshift, Glue, S3 and DMS
• - Experience building or supporting a BI layer in QuickSight, Power BI, Tableau or Looker
• - Comfortable working in Git, raising pull requests and reviewing other people’s SQL
• - A track record of turning ambiguous or evolving reporting requirements into defined, documented logic
• - An accuracy mindset. You reconcile, you check your numbers, and you can explain exactly how a figure was derived
• - Clear written and spoken English, and confidence working directly with client teams across time zones

Responsibilities

• Design and build layered Redshift SQL views and models for reporting across financial activity, accounts receivable ageing and operational health
• Build analytics and calculation views that compute regulated healthcare reporting values, and map source clinical and operational data to prescribed national dataset specifications
• Develop and maintain Python ETL jobs in AWS Glue for ingestion and transformation
• Support replication and migration of source data into the warehouse using AWS DMS and Zero-ETL integrations
• Share and query data across accounts and the data lake using Redshift datashares and Redshift Spectrum
• Build and maintain QuickSight datasets and dashboards on top of the reporting layer
• Translate reporting requirements into agreed metric definitions and documented calculation logic with analysts and client stakeholders
• Reconcile outputs against source systems and prior reporting, and investigate variances through to a clear explanation
• Build data quality checks, testing and documentation into delivery as standard, not as an afterthought
• Manage data infrastructure as code using Terraform where relevant

Skills

SQL

Python

AWS Redshift

Snowflake

BigQuery

QuickSight

Power BI

Tableau

Looker

Git

Tools

AWS Glue

DMS

Zero-ETL integrations

Terraform

Job description

HR Talent Partner SA seeks a Data Analytics Engineer to design and implement data warehouse solutions for reporting across finance, operations and regulatory domains. The role emphasizes building Redshift models, iterative design, and collaboration with analysts and client stakeholders in a remote setting.

You will work on data ingestion, transformation, and BI layer development using AWS Glue, Redshift, and QuickSight, with a strong emphasis on code quality, testing, and clear documentation.