Description

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.

Education

Bachelor’s degree in Computer Science