Summary
✨ AI‑Generated
A BI and ETL developer will design enterprise data warehouse structures, build reusable data pipelines, standardize business logic, and improve data quality and governance. The role involves integrating multiple operational sources and optimizing reliable, high-performance data processing.
Highlights
Build enterprise data warehouses and reliable ETL/ELT pipelines while improving data quality, governance, reporting, and analytics capabilities across multiple source systems.
Description
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 optimizationData warehousing concepts: staging → core → marts, dimensional modelingETL/ELT tooling : SSIS.RDBMS experience (any of): SQL Server, DB2, Snowflake, etc.
