Developer BI & ETL

Key Responsibilities

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).

ETL/ELT Development (Data Pipelines)

• 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).

Data Quality, Controls, and Governance Support

• 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).

Required Qualifications

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

Technical 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.