Analytics Engineer [DWH] Junior+/Middle

remote work; United States; Remote; USD 110,000 - 140,000; Full time

Benefits offered by this job

Relocation support

Flexible work

Healthcare coverage

Education budget

Wellness budget

Vacation policy

Job summary

Remote Work in the United States is seeking an Analytics Engineer to join our DWH team. You will build and maintain data pipelines from internal and external sources, develop data models and data marts for reporting and analytics, and create tools that make working with data across the organization more reliable and scalable.

You will work at the intersection of analytics and data engineering, turning business requirements into production-grade data models and transformations.

Qualifications

• 2-3 years of experience in Analytics Engineer, DWH Analyst, Data Analyst, or Data Engineer roles.
• Strong SQL skills with complex queries, joins, aggregations, CTEs and window functions.
• Hands-on experience with data modeling, transformations, and data marts.
• Experience building and maintaining ETL/ELT processes and data models using dbt or similar frameworks.
• Good understanding of data quality principles and troubleshooting data issues.
• Ability to translate business requirements into structured data solutions.
• Strong communication and ability to work with analysts and data engineers.

Responsibilities

• Translate business requirements into scalable data models and ETL/ELT solutions.
• Analyze data sources to identify integration points for pipelines.
• Design and develop logical data models and data marts for domain teams.
• Build, maintain, and optimize data transformations using SQL and dbt.
• Improve data flows for scalability, maintainability, and performance.
• Investigate data quality issues across sources and transformations.
• Collaborate with analysts and data engineers to integrate domain processes with core DWH.
• Document data models, lineage, integration points, and business rules.

Skills

SQL proficiency

dbt

Data modeling

ETL/ELT

Data quality

Communication

Independent work

Tools

dbt

Airflow

Job description

We are looking for an Analytics Engineer to join our DWH team.
Our bank runs on data-driven processes, and the DWH team plays a central role in enabling them. We build and maintain data pipelines from internal and external sources, develop data models and marts for reporting and analytics, and create tools that make working with data across the organization more reliable and scalable.
In this role, you will work at the intersection of analytics and data engineering, helping domain teams such as Product and Risk turn business requirements into reliable, production-grade data models and transformations. You will work across the data lifecycle - from analysing sources and designing data models to building, improving, and optimising ETL/ELT processes and data marts.

Team Timezone: LATAM

Challenges that await you:

• Translating business and analytical requirements into scalable data models and ETL/ELT solutions
• Analyzing raw and processed data sources to identify the most suitable integration points
• Designing and developing logical data models and data marts for domain teams
• Building, maintaining, and optimizing data transformations using SQL and dbt
• Improving existing data flows and models for scalability, maintainability, and performance
• Investigating data quality issues and inconsistencies across sources, transformations, and data marts
• Collaborating with analysts and data engineers to integrate domain-specific data processes with core DWH components
• Documenting data models, lineage, integration points, and business rules to maintain a reliable DWH knowledge base

What makes you a great fit:

• 2-3 years of experience in a similar role, such as Analytics Engineer, DWH Analyst, Data Analyst, or Data Engineer, with hands-on experience working with data warehouses
• Strong SQL skills, including complex queries, joins, aggregations, CTEs, window functions and data transformations
• Hands-on experience with data modeling, data transformations, and building or maintaining data marts
• Hands-on experience building and maintaining ETL/ELT transformations and data models using dbt or similar data transformation frameworks
• Good understanding of data quality principles and ability to troubleshoot data issues
• Ability to translate business requirements into structured data solutions
• Strong problem-solving skills and ability to work independently
• Strong communication skills and experience working with analysts, data engineers, and other stakeholders
• B1+ English for communication within an international team

Your bonus skills:

• Experience in Banking or Fintech
• Experience with workflow orchestration tools such as Airflow
• Understanding of Data Vault or dimensional modeling approaches
• Experience working with large datasets

Our ways of working:

• Innovative Spirit:A commitment to creativity and groundbreaking solutions
• Honest Feedback:valuing open, transparent communication
• Supportive Team:a strong, collaborative community
• Celebrating Achievements:recognizing our wins together
• High-Tech Environment:a team full of smart and revolutionary people who date to challenge the status quo of incumbent finances

Our benefits:

• Relocation support to one of our hubs - Cyprus, Serbia, Georgia or Kazakhstan - with assistance for the employee and their family
• Flexible workfrom one of our offices or remote
• Healthcare Coverage
• Education Budget:Language lessons, professional training and certifications
• Wellness Budget:Mental health and fitness activity reimbursements
• Vacation policy:20 days of annual leave and paid sick leave