Data Warehouse & BI Engineer: AWS Redshift Expert

Learntastic; Dallas (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

LearnTastic is seeking a motivated Data Warehouse & BI Engineer to join our growing team in Dallas. You will build and maintain a centralized data warehouse and BI platform that consolidates data across brands, marketing, payments, and experimentation platforms.

The ideal candidate has hands-on data engineering experience with cloud data warehouses, transformation frameworks, and BI development. Strong SQL, data modeling, and exposure to AWS, dbt, and Power BI are essential for success.

Qualifications

• Bachelor's degree in CS/Analytics/related field preferred.
• 3+ years in Data Engineering, BI, Analytics Engineering, or Data Warehousing.
• Strong SQL and data modeling skills.
• Hands-on experience with AWS, Redshift, and S3.
• Experience with dbt and modern data transformation practices.
• Strong experience with Power BI and DAX.
• Experience building API-based data pipelines and integrating third-party platforms.
• Familiarity with AWS Aurora, DMS/CDC, Python, and Git/GitHub.
• Solid understanding of data quality, testing, security, and data governance.

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 marketing and payments platforms.
• Implement production-safe ingestion using Aurora Zero-ETL, AWS DMS/CDC, and API 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, etc.
• Maintain version-controlled data projects using Git/GitHub and partner with stakeholders to define KPIs.

Skills

SQL

Data Modeling

BI Development

Education

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

Tools

AWS

Redshift

S3

dbt

Power BI

DAX

Git/GitHub

Python

Aurora

DMS/CDC

Job description

LearnTastic is seeking a motivated Data Warehouse & BI Engineer to join our growing team in Dallas. You will build and maintain a centralized data warehouse and BI platform that consolidates data across brands, marketing, payments, and experimentation platforms.

The ideal candidate has hands-on data engineering experience with cloud data warehouses, transformation frameworks, and BI development. Strong SQL, data modeling, and exposure to AWS, dbt, and Power BI are essential for success.