You will build and maintain scalable data processing pipelines to support enterprise-wide analytics and BI solutions.
Responsibilities
- Design and implement dimensional and fact tables, including conceptual, logical, and physical data models with metadata and lineage.
- Develop and maintain ETL workflows to extract, transform, and load data from ERP, CRM, and HRIS systems into the data warehouse.
- Build scalable data processing pipelines to integrate data from various sources into the Enterprise Data Warehouse and Data Lakes.
- Partner with BI teams to design and deploy reports and dashboards while ensuring data integrity and quality.
- Support data governance processes and provide production support for ETL processes to ensure data availability.
Required Skills
- 3+ years of experience in Data Warehousing, Data Engineering, or Data Integration projects.
- Strong SQL background and expertise in data warehousing concepts and strategies.
- Experience with Google Cloud Platform including BigQuery, Cloud SQL, Dataflow, Dataproc, Composer (Airflow), Cloud Function, and GCS.
- Proficiency with relational databases such as SQL Server, PostgreSQL, and MySQL.
- Experience integrating data using APIs, XML, and JSON.
- In-depth understanding of ETL frameworks, OLAP, and database management systems.
- Bachelor’s degree in Computer Science or equivalent work experience.
- Experience leading teams across multiple locations.
- Familiarity with SDLC, Agile, and Scrum processes.
Preferred Skills
- Knowledge of SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
- Experience with Informatica PowerExchange for Mainframe and Salesforce.
- Knowledge of AWS and Azure Cloud environments.