Sr. Analyst, Data & Analytics Engineering

Vanscoy Rare; Coraopolis, Northern (Allegheny County, KY); Hybrid; USD 120,000 - 155,000; Full time

Benefits offered by this job

Hybrid work structure

On-site option in Pittsburgh

Job summary

Vanscoy Rare in Pittsburgh, PA is seeking a Senior Data & Analytics Engineer to design scalable data pipelines and governance frameworks. You will work with Azure Data Factory, Azure Synapse, and Power BI to deliver reliable data, dashboards, and insights for stakeholders.

You will mentor junior engineers, collaborate with cross-functional teams, and help drive AI-enabled analytics initiatives with governance and security in mind.

Qualifications

• Bachelor’s or Master’s degree in CS, IT, or data analytics.
• At least 5 years of data engineering experience with Azure and Power BI.
• Proficiency in SQL and data warehousing concepts.
• Experience designing scalable data pipelines and governance.

Responsibilities

• Design and develop scalable data pipelines using Azure Data Factory and Azure Synapse Analytics.
• Oversee data storage solutions, data lakes and data warehouses.
• Create and deliver data files reliably using pipelines and triggers.
• Create and maintain Power BI reports and dashboards.
• Collaborate with pharmacists, business stakeholders, and leadership to meet data needs.
• Monitor and optimize data pipelines and storage performance.
• Implement data governance policies to ensure data quality and compliance.
• Provide mentorship to junior data engineers.
• Stay updated on Azure tech and data visualization trends.
• Other duties as assigned.

Skills

Data modeling

ETL processes

Data warehousing

SQL

Power BI

Python

Scala

Java

Azure Data Factory

Azure Synapse Analytics

Education

Bachelor’s or Master’s degree in Computer Science, Information Technology, and Data Analytics

Tools

Azure Data Factory

Azure Synapse Analytics

Power BI

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Coraopolis, PA, US

Purpose:

The Sr. Analyst, Data & Analytics Engineering provides strategic and tactical support to Vanscoy Rare Pharmacy and will report directly to the Data Analytics Manager. The Sr. Analyst, Data & Analytics Engineering works directly with Vanscoy Rare Pharmacy teams to determine reporting requirements, develop data pipelines, and distribute reports on to internal and external stakeholders. As a Sr. Analyst, Data & Analytics Engineering, 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 Vanscoy Rare Pharmacy 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 Sr. Analyst will also be responsible for mentoring and coaching analysts, engineers, and other data team members. In some cases, the Sr. Analyst, Data & Analytics Engineering will be responsible for delegating work based on organizational priorities.

The Sr. Analyst, Data & Analytics Engineering will also 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 Sr. Analyst, Data & Analytics Engineering will be responsible for 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.

Responsibilities:

• Design and Development: Assist with 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 to create and maintain reports and dashboards that provide actionable insights to stakeholders.
• Collaboration: Work closely with pharmacists, business stakeholders, and Vanscoy Rare Solutions 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 or equivalent experience in Computer Science, Information Technology, and Data Analytics.
• 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 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.

Vanscoy Rare offers a hybrid work structure, combining remote work and in-office requirements. The frequency of onsite requirements will vary depending on role, operational needs, meetings, client visits, or team collaboration activities. Employees must be within commuting distance to Pittsburgh, PA, and able to report to the office when needed. We will provide advance notice when possible. This role routinely involves standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. When telecommuting, employees must have reliable internet access to utilize required systems and software required for the position's responsibilities. The amount of time the employee is expected to work per day or pay period will not change while working from home. Employees are responsible for the set-up of their home office environment, including physical set-up, internet connection, phone line, electricity, lighting, comfortable temperature, furniture, etc. Employee’s teleworking space should be separate and distinct from their “home space” and allow for privacy.

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.