Description
You will own the design, build, and maintenance of scalable data pipelines and warehousing solutions.
This role is on-site.
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.
Required Skills
- 3+ years of experience in Data Warehousing, Data Engineering, or Data Integration projects.
- Strong SQL background with expertise in data warehousing concepts and strategies.
- Experience with Google Cloud Platform including BigQuery, Cloud SQL, Dataflow, Dataproc, Composer (Airflow), Cloud Functions, 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.
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.