Lead, Data & Analytics Engineering

Purpose:

The Lead, Data & Analytics Engineering provides strategic and tactical support to the Vanscoy Rare team and will report directly to the President. The Lead, Data & Analytics Engineering works directly with Vanscoy Rare teams to determine reporting requirements, develop data pipelines, and distribute reports to internal and external stakeholders. This role is responsible for designing, developing, and maintaining VRP's data infrastructure, ensuring the efficient and secure processing of large volumes of data, and providing actionable insights through data visualization. The role serves as an organizational expert on data infrastructure by working closely with Vanscoy Rare leadership, determining the needs of the team, and providing knowledge and recommendations to support the data and analytics needs. This role is also responsible for identifying quality issues and implementing solutions to potential issues that may arise through data analysis and reporting. The Lead, Data & Analytics Engineering is also responsible for mentoring and coaching analysts, engineers, and other data team members. In some cases, the Data & Analytics Engineering Lead will be responsible for delegating work based on organizational priorities.

Responsibilities:

• Design and Development: Lead the design and development of scalable data pipelines using Azure Data Factory and Azure Synapse Analytics to support data integration, transformation, and loading processes.
• Data Management: Oversee the management and optimization of data storage solutions, including data lakes and data warehouses, ensuring data is organized, accessible, and secure.
• Data Delivery: Utilize data pipelines and triggers to create and deliver data files reliably and repeatably.
• Data Visualization: Utilize Power BI and other tools to create and maintain reports and dashboards that provide actionable insights to stakeholders.
• Collaboration: Work closely with pharmacists, business stakeholders, and Vanscoy Rare leadership to understand data requirements and deliver solutions that meet business needs.
• Performance Optimization: Monitor and optimize the performance of data pipelines and storage solutions to ensure efficient data processing and retrieval.
• Data Governance: Implement and enforce data governance policies and best practices to ensure data quality, consistency, and compliance with regulatory requirements.

• Mentorship: Provide technical leadership and mentorship to junior data engineers, fostering a culture of continuous learning and improvement.
• Innovation: Stay up-to-date with the latest industry trends and advancements in data engineering, Azure technologies, and data visualization tools, and apply this knowledge to drive innovation within the team.
• Other duties as assigned

Required Qualifications:

• Education: Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
• Experience: Minimum of 5 years of experience in data engineering, with a focus on using Microsoft Azure services and Power BI.
• Technical Skills:
• Proficiency in data modeling, ETL processes, and data warehousing concepts.
• Proficiency in Azure Data Factory and Azure Synapse Analytics.
• Strong knowledge of SQL and experience with database management systems.
• Knowledge of Power BI for creating reports and dashboards.
• Knowledge of programming languages such as Python, Scala, or Java.
• Soft Skills:
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration abilities.
• Ability to lead and mentor junior data analysts and engineers.
• Detail-oriented with a focus on data quality and accuracy.

Preferred Qualifications:

• Experience with Snowflake.

• Experience with SSIS and Tableau.
• Certification in Microsoft Azure Data Engineering or related areas.
• Experience in the healthcare or pharmaceutical industry.

Why Join Us:

• Innovative Environment: Be part of a team building new capabilities that values innovation and continuous improvement.
• Professional Growth: We are a well-backed, young company with a steep trajectory and many opportunities for professional development and career advancement.
• Collaborative Culture: Work in a collaborative and supportive environment where your contributions are valued.

Work Environment

This job may operate in a professional office environment and/or remotely from the employee's home address listed in their employee file. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. When telecommuting employees must have reliable internet access in order to access required systems and software associated with the position's responsibilities. The amount of time the employee is expected to work per day or pay period will not change as a result of participation in the teleworking program. Employees are responsible for the set-up of their home office environment, including physical set-up, internet connection, phone line, electricity, good lighting, comfortable temperature, furniture, etc. Employee's teleworking space should be separate and distinct from their "home space" and allow for privacy. Vanscoy Rare expects employees teleworking to be as efficient and professional as if they were in the office.

Physical Demands

While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand; walk; use hands and fingers, handle or feel; and reach with hands and arms.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential function of the job.