Data Warehouse & BI Engineer

• 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., * 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.

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., * 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., * 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.