Essential functions
DATA ANALYSIS/PROFILING SKILLSfor our Enterprise Data Organization to develop and manage data pipelines (data ingestion, transformation, storage etc.) for an Azure/Snowflake cloud-based data analytics platform.
Qualifications
- Advanced SQL queries, scripts, stored procedures, materialized views, and views
- Focus on ELT to load data into database and perform transformations in database
- Ability to use analytical SQL functions
- Snowflake experience
- Cloud Data Warehouse solutions experience (Snowflake, Azure DW, or Redshift); data modeling, analysis, programming
- Experience with DevOps models utilizing a CI/CD tool
- Work in hands-on Cloud environment in Azure Cloud Platform (ADLS, Blob)
- Airflow
Would be a plus
- Good interpersonal skills; comfort and competence in dealing with different teams within the organization.
- Requires an ability to interface with multiple constituent groups and build sustainable relationships.
- Strong and effective communication skills (verbal and written).
- Strong analytical, problem-solving skills.
- Experience of working in a matrix organization.
- Ability to prioritize and deliver.
- Results-oriented, flexible, adaptable.
- Work well independently and lead a team.
- Versatile, creative temperament, ability to think out-of-the box while defining sound and practical solutions.
- Ability to master new skills.
- Familiar with Agile practices and methodologies
- Professional data engineering experience focused on batch and real-time data pipelines using Spark, Python, SQL
- Data warehouse (data modeling, programming)
- Experience working with Snowflake
- Experience working on a cloud environment, preferably, Microsoft Azure Cloud Data Warehouse solutions (Snowflake, Azure DW)
