Developer BI & ETL

Data Warehouse Design & Development

• Design and develop dimensional and/or normalized data models (e.g., star/snowflake) to support enterprise reporting and analytics.
• Implement and maintain DWH layers (staging, integration/core, and presentation/marts).
• Establish and maintain data standards (naming conventions, keys, reference/master data alignment).

• Build and maintain ETL/ELT pipelines to ingest data from multiple sources (ERP, operational systems, flat files, APIs).
• Develop reusable transformations using SQL and ETL tools to standardize business logic and KPIs.
• Schedule, monitor, and optimize jobs for reliability and performance (incremental loads, CDC where applicable).

• Implement automated data quality checks (completeness, validity, duplicates, reconciliations).
• Perform root cause analysis for data issues and work with business/IT stakeholders to resolve upstream causes.
• Document data lineage, mapping specifications, and transformations to support auditability and trust.
• Support data governance practices (certified datasets, definitions, and KPI alignment).

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or equivalent practical experience.
• 3–6 years of hands-on experience in ETL/ELT and data warehousing.
• Strong SQL (advanced queries, performance tuning).
• Proven experience designing and implementing DWH data models.
• Experience integrating ERP/data (e.g., Oracle JDE or similar ERP) is highly desirable.
• Working knowledge of data quality frameworks and reconciliation methods.
• Strong documentation skills.

• SQL (advanced): performance tuning, indexing concepts, query optimization
• Data warehousing concepts: staging → core → marts, dimensional modeling
• ETL/ELT tooling : SSIS.
• RDBMS experience (any of): SQL Server, DB2, Snowflake, etc.