Data Warehouse & BI Engineer

LearnTastic is seeking a motivated, results-driven Data Warehouse & BI Engineer to join our growing team. This role will be responsible for building and maintaining a centralized data warehouse and Business Intelligence platform that consolidates data across our brands, marketing channels, payment systems, and experimentation platforms.
The ideal candidate is hands-on, analytical, and experienced in data engineering, cloud data warehouses, transformation frameworks, and BI development. Success in this role requires strong SQL and data modeling skills, experience with AWS and dbt, and the ability to turn complex data into reliable business insights.
Essential Duties & 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
Qualifications:
Bachelor's degree in Computer Science, Data Engineering, Analytics, or 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
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
Strong understanding of data quality, testing, security, and data governance
Excellent analytical, problem-solving, and communication skills
Preferred Qualifications
Experience with Stripe, Google Ads, Meta Ads, Microsoft Ads, AWIN, LinkConnector, or VWO
Experience with e-commerce, marketing attribution, or financial reconciliation
Experience working with multi-brand or high-volume transactional data
Familiarity with customer identity resolution and cross-channel attribution
What Success Looks Like
Builds a reliable centralized source of truth across all LearnTastic brands
Delivers accurate and timely data for Sales, Marketing, Finance, and Leadership
Maintains strong data quality and production workload isolation
Develops scalable pipelines, models, and Power BI reporting
Improves visibility into revenue, marketing performance, user behavior, and experimentation
Location: Remote
Project Duration: 4 months
Powered by JazzHR
heEnrGpB4g

Work arrangement
No