2+ Enterprise Data Warehouse (EDW) Jobs in Mumbai | Enterprise Data Warehouse (EDW) Job openings in Mumbai

About Us: As India's fastest-growing D2C brand, we are at the forefront of innovation and transformation in the market. We’re a well-funded, rapidly growing (we have recently launched our 100th store), omnichannel D2C brand with a passionate and innovative team.

Job Summary: We are seeking a Data Engineer to help us design, build and maintain our BigQuery data warehouse by performing ETL operations and creating unified data models. You will work across various data sources to create a cohesive data infrastructure that supports our omnichannel D2C strategy.

Why Join Us: Experience the exciting world of India's billion-dollar D2C market. As a well-funded, rapidly growing omnichannel D2C brand, we are committed to changing the way India sleeps and sits. You'll have the opportunity to work with a passionate and innovative team and make a real impact on our success.

Key Responsibilities:

ETL Operations: Design, implement, and manage ETL processes to extract, transform, and load data from various sources into BigQuery.

Data Warehousing: Build and maintain a robust data warehouse in BigQuery, ensuring data integrity, security, and performance.

Data Modeling: Create and manage flat, unified data models using SQL and DBT to support business analytics and reporting needs.

Performance Optimization: Optimize ETL processes and data models to ensure timely data delivery for reporting and analytics.

Collaboration: Work closely with data analysts, product managers, and other stakeholders to understand data requirements and deliver actionable.

Documentation: Maintain comprehensive documentation of data workflows, ETL processes, and data models for reference and onboarding

Troubleshoot: Monitor and troubleshoot data pipeline issues, ensuring timely resolution to minimize disruption to business operations.

Skills and Qualifications:

1. Proficiency in SQL and experience with BigQuery
2. Minimum 2 years of experience in data engineering or a similar role
3. Experience with data pipeline and ETL tools (e.g., Apache Airflow, Talend, AWS Glue)
4. Familiarity with cloud platforms (e.g., AWS, Google Cloud, Azure) and their data services
5. Experience with data warehousing solutions (e.g., Amazon Redshift, Google BigQuery, Snowflake)
6. Knowledge of data modeling, data architecture, and data governance best practices.
7. Excellent problem-solving skills and attention to detail
8. Knowledge of DBT (Data Build Tool) for data transformation
9. Self-motivated, proactive, and highly accountable
10. Excellent communication skills to effectively convey technical concepts and solutions

• 15+ years of Experience in OFSAA Financial Solution Data Foundation and OFSAA Regulatory reporting solutions
• Expert in enterprise solution architecture and design
• Strong understanding in the OFSAA Data Model, Dimension Management and Enterprise Data Warehouse Knowledge.
• Strong Understanding of OFSAA instrument balances reconciliation with General Ledger Summary Level balances
• Experience in defining and build the OFSAA data architecture and sourcing strategy to ensure data accuracy, integrity and quality.
• Understanding of Banking treasury products, US Fed regulatory etc.
• Strong understanding of data lineage. building
• Strong in OFSAA Data Management Tools Knowledge (F2T/T2T/PLT/SCD’s).
• Experience in Business rules configurations in OFSAA framework
• Strong Experience in deploying OFSAA platform (OFSAAI – OFSAA Infrastructure) and installation of OFSAA application - preferably OFSAA 8.x onwards.