Design and build a data warehouse using computing–based data cloud (Snowflake) for machine learning, data analysis, self-serve analytics and reporting needs
Develop Extract, Transform, Load (ETL) pipelines to orchestrate execution of scripts, automate data transformation and loading data into data warehouses
Perform data cleansing, validation, testing and schema design to ensure accuracy and reliability of data insights
Manage and build automated workflows and monitor these pipelines and DAGs (Directed Acyclic Graphs)
Identify and work on improvements by automating manual processes to optimize data delivery, re-design infrastructure for more scalability using python & sql
Collaborate with cross-functional teams including data engineers, analysts and data scientists to understand the business logic and needs to create an effective and efficient pipeline and data model
Create ad-hoc report/data visualizations based on user requirements
Participate in ETL flow design reviews and recommend solutions to improve processes
Perform data quality checks and alerting to identify issues and resolve bugs in a timely manner
Participate in source code and design reviews in a software development lifecycle (SDLC) driven environment using technical, functional, and domain knowledge
Identify issues or gaps and suggest improvements to the team processes
Provide support for customer requests for all the products handled by the team.

Requirements

Master’s degree (or its foreign degree equivalent) in Analytics, Data Science, Engineering (any field), or a related quantitative discipline
Six (6) months of experience in the job offered or in any occupation in related field
Data warehouse design and dimensional modeling
Extract, Transform, Load (ETL)
SQL
Python
Data Visualization (Tableau or Power BI)
Gitlab
Azure
PySpark
OLAP and OLTP system experience (MySQL Database, Postgres DB, or Snowflake)
Machine Learning
Data Pipeline - Performance & Scalability Techniques.

Benefits

Competitive salary
Flexible work arrangements
Professional development opportunities

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills

data warehouse designdimensional modelingExtract Transform Load (ETL)SQLPythondata visualizationmachine learningdata pipeline performancescalability techniquesdata cleansing

Soft skills

collaborationproblem-solvingcommunicationprocess improvementattention to detail