About this role
<div> <p><strong><span>Key Responsibilities</span></strong></p> </div> <div> <p><strong>Data Warehouse Design & Development</strong></p> </div> <div> <ul type="disc"> <li>Design and develop dimensional and/or normalized data models (e.g., star/snowflake) to support enterprise reporting and analytics.</li> </ul> </div> <div> <ul type="disc"> <li>Implement and maintain DWH layers (staging, integration/core, and presentation/marts).</li> </ul> </div> <div> <ul type="disc"> <li>Establish and maintain data standards (naming conventions, keys, reference/master data alignment).</li> </ul> </div> <div> <p><strong>ETL/ELT Development (Data Pipelines)</strong></p> </div> <div> <ul type="disc"> <li>Build and maintain ETL/ELT pipelines to ingest data from multiple sources (ERP, operational systems, flat files, APIs).</li> </ul> </div> <div> <ul type="disc"> <li>Develop reusable transformations using SQL and ETL tools to standardize business logic and KPIs.</li> </ul> </div> <div> <ul type="disc"> <li>Schedule, monitor, and optimize jobs for reliability and performance (incremental loads, CDC where applicable).</li> </ul> </div> <div> <p><strong>Data Quality, Controls, and Governance Support</strong></p> </div> <div> <ul type="disc"> <li>Implement automated data quality checks (completeness, validity, duplicates, reconciliations).</li> </ul> </div> <div> <ul type="disc"> <li>Perform root cause analysis for data issues and work with business/IT stakeholders to resolve upstream causes.</li> </ul> </div> <div> <ul type="disc"> <li>Document data lineage, mapping specifications, and transformations to support auditability and trust.</li> </ul> </div> <div> <ul type="disc"> <li>Support data governance practices (certified datasets, definitions, and KPI alignment).</li> </ul> </div> <div> <p><strong>Required Qualifications</strong></p> </div> <div> <ul type="disc"> <li>Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or equivalent practical experience.</li> </ul> </div> <div> <ul type="disc"> <li><strong>3–6 years</strong> of hands-on experience in ETL/ELT and data warehousing.</li> </ul> </div> <div> <ul type="disc"> <li><strong>Strong SQL</strong> (advanced queries, performance tuning).</li> </ul> </div> <div> <ul type="disc"> <li>Proven experience designing and implementing DWH data models.</li> </ul> </div> <div> <ul type="disc"> <li>Experience integrating ERP/data (e.g., Oracle JDE or similar ERP) is highly desirable.</li> </ul> </div> <div> <ul type="disc"> <li>Working knowledge of data quality frameworks and reconciliation methods.</li> </ul> </div> <div> <ul type="disc"> <li>Strong documentation skills.</li> </ul> </div> <div> <p><strong>Technical Skills </strong></p> </div> <div> <ul type="disc"> <li>SQL (advanced): performance tuning, indexing concepts, query optimization</li> </ul> </div> <div> <ul type="disc"> <li>Data warehousing concepts: staging → core → marts, dimensional modeling</li> </ul> </div> <div> <ul type="disc"> <li>ETL/ELT tooling : SSIS.</li> </ul> </div> <div> <ul type="disc"> <li>RDBMS experience (any of): SQL Server, DB2, Snowflake, etc.</li> </ul> </div>