Note: The job is a remote job and is open to candidates in USA. LearnTastic is seeking a motivated, results-driven Data Warehouse & BI Engineer to join its growing team. The role will build and maintain a centralized data warehouse and Business Intelligence platform, develop secure data pipelines and dbt transformation models, create Power BI reporting, and turn complex data into reliable business insights.
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
- * 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
- * Bachelor's degree in Computer Science, Data Engineering, Analytics, or related field preferred
- * 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
Benefits
- Remote work arrangement
Company Overview