Senior Data Engineer (Power BI)

DataArt; United States; Hybrid; USD 98,000 - 135,000; Full time

Benefits offered by this job

Vacation days

Illness days off

Health insurance

Language classes

Learning platforms

Flexible workplace

Certification reimbursement

Mentoring program

Job summary

DataArt is seeking a hands-on Analytics Engineer to bridge data engineering and analytics for a major investment funds client. You will own data tasks end-to-end — from sourcing data and building transformations to delivering well-designed datasets and Power BI dashboards.

The role requires strong SQL, dbt, data modeling, and experience with Snowflake, Python, and Airflow. You will work in a fast-paced environment and ramp up quickly on a complex data landscape.

Qualifications

• Strong SQL and data analysis skills.
• Hands-on experience with dbt and ELT/data transformation practices.
• Solid understanding of data modeling, including dimensional modeling, fact/dimension structures, and analytics datasets.
• Experience working with a modern cloud data warehouse, preferably Snowflake.
• Strong working experience with Power BI, including data modeling, DAX, dashboard development, and performance considerations.
• Ability to understand unfamiliar datasets and identify relationships, data quality issues, and transformation requirements.
• Experience debugging and supporting existing data pipelines and analytics solutions.
• Comfortable working independently in a fast-paced environment and delivering tasks with limited supervision.
• Strong experience with Python and Airflow.
• Strong experience with AWS cloud services.

Responsibilities

• Build, maintain, and enhance data pipelines with dbt.
• Develop clean data models for analytics and reporting.
• Work with SQL and data warehouses to investigate data and transform.
• Develop and maintain Power BI dashboards and DAX measures.
• Translate business requirements into data models and reporting.
• Perform data analysis, validation, and data quality checks.
• Troubleshoot data issues across the pipeline from source to reporting.
• Take ownership of tasks and drive them through development and testing.
• Collaborate with business, analytics, and engineering teams to deliver solutions.

Skills

SQL

dbt

Data modeling

Power BI

Python

Airflow

AWS

Data analysis

Tools

Snowflake

Job description

Client

Our client is one of the world's largest investment funds that manages hundreds of billions of dollars. The company's business is focused on several areas: private equity, venture capital, real assets, investment solutions, and global market strategies.

Project overview

DataArt specialists work on the project in several areas related to the core business of the client. We are helping to develop a decision support system for investment analysts. The project includes development, optimization, and speeding up applications and databases.

Position overview

We are looking for a hands-on Analytics Engineer who can work across both data engineering and analytics/reporting. This is not a Power BI-only role. The ideal candidate should be comfortable owning data tasks end-to-end — from understanding source data and building transformation pipelines to creating well-designed datasets and Power BI dashboards. We are looking for someone who is data-first and hands-on. The candidate should be equally comfortable writing SQL/dbt transformations, investigating a data issue, designing an analytics model, and building or modifying a Power BI report. This is a contract position, so we are particularly looking for someone who can ramp up quickly, understand an existing data environment, take ownership of assigned work, and consistently deliver completed solutions.

Responsibilities

• Build, maintain, and enhance data pipelines and transformation workflows using dbt.
• Develop clean, reliable, and reusable data models for analytics and reporting.
• Work with SQL and data warehouse platforms to investigate data, troubleshoot issues, and implement transformations.
• Develop and maintain Power BI dashboards, reports, semantic models, and DAX measures.
• Translate business requirements into appropriate data models and reporting solutions.
• Perform data analysis, validation, reconciliation, and data quality checks.
• Troubleshoot data issues across the pipeline, from source through transformation to reporting.
• Take ownership of assigned tasks and independently drive them through development, testing, and completion.
• Work closely with business, analytics, and engineering teams to deliver production-ready solutions.

Requirements

• Strong SQL and data analysis skills.
• Hands-on experience with dbt and modern ELT/data transformation practices.
• Solid understanding of data modeling, including dimensional modeling, fact/dimension structures, and analytics datasets.
• Experience working with a modern cloud data warehouse, preferably Snowflake.
• Strong working experience with Power BI, including data modeling, DAX, dashboard development, and performance considerations.
• Ability to understand unfamiliar datasets and identify relationships, data quality issues, and transformation requirements.
• Experience debugging and supporting existing data pipelines and analytics solutions.
• Comfortable working independently in a fast-paced environment and delivering tasks with limited supervision.
• Strong experience with Python and Airflow.
• Strong experience with AWS cloud services.

What We Offer:

• Vacation days: Up to 26 business days per year.
• 10 illness/special days off per year (fully paid, no medical papers needed) for all contract types.
• Health and life insurance (Luxmed).
• MyBenefit platform with Multisport option.
• Internal psychological support service.
• English language classes from the first working day.
• Access to external learning platforms: O’Reilly, LinkedIn Learning, Udemy, and a wide catalog of diverse internal training.
• Flexible workplace: work from the office, from home, or choose a hybrid option.
• Tech Skills Mentoring Program.
• Opportunities to develop as a public speaker, mentor, or technical interviewer.
• Fully paid idle (bench) when not involved in a project.
• Certification reimbursement (AWS, GCP, Microsoft, etc.).