A little about this role:

At PRESENCE, data is central to our success. As the Azure Data Engineer, you are primarily responsible for the collection and transformation of data across a multitude of data sources. This individual also is responsible for the optimization of the environment, structure, and processes associated with said data.

A day in the life:

• Data Warehouse - As the Azure Data Engineer, you are responsible for the data warehouse design, development, testing, support, and configuration. You will review business requests for data warehouse data and data warehouse usage. You will also research data sources for new and better data feeds ensuring consistency and integration with existing warehouse structure.
• Data Collection – You will be responsible for developing automated data pipelines and/or data integrations within the Azure Synapse environment. You will use SQL, Python scripts and Azure Functions to automate data collection from a wide variety of sources.

• Data Transformation – You will create BI (Business Intelligence) and Data Warehousing cube design. You will create and manage ETL/ELT processes to transform and load data into data warehouse for consumption within Microsoft PowerBI environment.
• Data Optimization – As the Azure Data Engineer, you will create and maintain standards and policies. You will identify, design, and implement internal process improvements, including automation of manual processes and optimization of data delivery. You will continuously improve data reliability, efficiency, and quality.
• Training – Identify and demonstrate techniques to optimize reporting for Data Visualization Analyst, provide and participate in internal and external training sessions, and produce documentation to support understanding and learnings around the Presence data/reporting environment.

This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Projects and responsibilities may change at any time with or without notice due to our business, industry, and/or market changes.

What we are looking for:

• Previous experience using SQL, Python scripts and Azure Functions
• Experienced in Azure Synapse environment
• Experience designing, building, and maintaining data processing system
• Dependable, extroverted, diplomatic person, able to problem-solve successfully with a wide variety of people and issues
• Attention to detail and strong organizational skills, self-motivated
• Ability to work independently while being a strong team player
• Passion for innovation and “can do” attitude to thrive in a fast-paced environment
• Proficient in time management and adhering to deadlines
• Knowledge and interest of the natural products/brands and retail landscape is a plus
• Proficient computer (MS Office applications) and data-mining skills
• Flexibility to successfully multi-task in a fast-paced environment with a positive attitude
• Regular and predictable attendance is required
• Ability to manage time and deadlines