Remote Data Warehouse & BI Engineer - AWS, dbt, Power BI

Learntastic Group; United States; Remote; USD 120,000 - 170,000; Full time

Job summary

LearnTastic is seeking a Data Warehouse & BI Engineer to build and maintain a centralized data warehouse and BI platform across brands, marketing channels, payment systems, and experimentation platforms.

The ideal candidate will be hands-on with data engineering, cloud data warehouses, transformation frameworks, and BI development, with strong SQL, data modeling, and experience in AWS, dbt, and Power BI. Location is remote for a 4-month project, requiring collaboration with multiple teams.

Qualifications

• Bachelor's degree in a related field preferred.
• 3+ years of experience in Data Engineering, BI, Analytics Engineering, or Data Warehousing.
• Strong SQL and data modeling skills.
• Hands-on experience with AWS, Redshift, and S3.

Responsibilities

• Design and maintain a centralized data warehouse using AWS Redshift Serverless and S3.
• Build secure data pipelines from Aurora databases and external APIs including Google Ads, Meta Ads, Microsoft Ads, Stripe, AWIN, LinkConnector, and VWO.
• Implement production-safe ingestion using Aurora Zero-ETL, AWS DMS/CDC, and API-based integrations.
• Develop and maintain dbt transformation models, testing, documentation, and data lineage.
• Build dimensional data models and data marts for Sales, Marketing, Finance.
• Develop and maintain Power BI dashboards, semantic models, and DAX measures.
• Build financial reconciliation models connecting orders, payments, refunds, disputes, fees, and payouts.
• Implement customer identity and marketing attribution across brands and channels.
• Establish automated data quality checks for duplicates, missing data, stale feeds, and reconciliation issues.
• Maintain version-controlled data projects using Git/GitHub.
• Partner with internal stakeholders to define KPIs, reporting requirements, and analytical solutions.

Skills

SQL

Data modeling

AWS Redshift

dbt

Power BI

DAX

Python

APIs

Git/GitHub

Education

Bachelor's degree in Computer Science, Data Engineering, Analytics, or related field

Tools

AWS

Redshift

S3

Aurora

GitHub

Job description

LearnTastic is seeking a Data Warehouse & BI Engineer to build and maintain a centralized data warehouse and BI platform across brands, marketing channels, payment systems, and experimentation platforms.

The ideal candidate will be hands-on with data engineering, cloud data warehouses, transformation frameworks, and BI development, with strong SQL, data modeling, and experience in AWS, dbt, and Power BI. Location is remote for a 4-month project, requiring collaboration with multiple teams.