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.