Data & Analytics Engineering Lead

Summit Access Solutions,LLC•Coraopolis, PA

3d•Hybrid

About The Position

The Data & Analytics Engineering Lead provides strategic and tactical support to Vanscoy Rare Pharmacy (VRP) and will report directly to the Director of Data Analytics. The Data & Analytics Engineering Lead works directly with VRP teams to determine reporting requirements, develop data pipelines, and distribute reports on to internal and external stakeholders. As the Data & Analytics Engineering Lead, you will be responsible for designing, developing, and maintaining our data infrastructure, ensuring the efficient and secure processing of large volumes of data, and providing actionable insights through data visualization. You will serve as an organizational expert on data infrastructure by working closely with VRP 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 Reporting & Analytics Lead will also be 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. The Data & Analytics Engineering Lead will support the organization’s evolving AI and advanced analytics initiatives by helping evaluate opportunities for intelligent automation, anomaly detection, predictive analytics, workflow optimization, and AI-assisted reporting. AI-enabled capabilities should be implemented with appropriate governance, security, auditability, and human oversight to support operational and compliance objectives. The Reporting & Analytics Lead will also mentor and coach analysts, engineers, and other data team members while promoting best practices in data engineering, reporting development, governance, and documentation. This role may also be responsible for prioritizing and delegating work based on organizational initiatives, project timelines, and operational priorities.

Requirements

Bachelor’s or Master’s degree or equivalent experience in Computer Science, Information Technology, and Data Analytics.
Minimum of 5 years of experience in data engineering, with a focus on using Microsoft Azure services and Power BI.
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.
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.

Nice To Haves

Experience with Snowflake a plus.
Experience with SSIS and Tableau or PowerBI a plus.
Certification in Microsoft Azure Data Engineering or related areas.
Experience in the healthcare or pharmaceutical industry.

Responsibilities

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.
Oversee the management and optimization of data storage solutions, including data lakes and data warehouses, ensuring data is organized, accessible, and secure.
Utilize data pipelines and triggers to create and deliver data files reliably and repeatably.
Utilize Power BI to create and maintain reports and dashboards that provide actionable insights to stakeholders.
Work closely with pharmacists, business stakeholders, and VRP leadership to understand data requirements and deliver solutions that meet business needs.
Monitor and optimize the performance of data pipelines and storage solutions to ensure efficient data processing and retrieval.
Implement and enforce data governance policies and best practices to ensure data quality, consistency, and compliance with regulatory requirements.
Provide technical leadership and mentorship to junior data engineers, fostering a culture of continuous learning and improvement.
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