Loading, Please wait..!!
Data Engineer
-
Posted on: Nov 10, 2026
-
, Pennsylvania
-
Onsite
-
Full-time
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for Data Engineer roles in Pennsylvania.
View Salary Guide →Job Title :
Data Engineer
Job Type :
Full-Time
Job Location :
Pennsylvania United States
Remote :
No
Job Description :
Fulltime Direct Hire
Ideally 1-2 day per week onsite is preferred. Location: Pittsburgh, PA | near by 50 miles max
Role: Sr. Analyst, Data & Analytics Engineering
Purpose:
The Sr. Data & Analytics Engineer 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.
- 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.
Intake Notes:
Senior Data Analytics Engineer: Microsoft/Azure environment with heavy SQL Server, complex stored procedures/views, Azure Data Factory, and potentially Fabric; advanced SQL is preferred, including complex queries, joins, stored procedures, triggers, and database optimization. Databricks or comparable platforms, Power BI, GitHub/source control, AI familiarity, and pharmaceutical/clinical experience are pluses but not required. - Data team is small (one contractor, two team members, and an experienced senior lead) and supports manufacturers/pharmaceutical clients with daily reporting on drug dispensing and patient data; workload can reach approximately 15 reports per day. Candidate should be adaptable, customer-facing, collaborative, and comfortable switching priorities frequently.
Senior Data Analytics Engineer
Strong SQL Server skills required, including complex queries, joins, stored procedures, triggers, and optimization.
Azure Data Factory preferred; equivalent tools such as Databricks are acceptable.
Power BI, GitHub/source control, AI familiarity, and pharmaceutical/healthcare experience are beneficial but not mandatory.
Must be adaptable, communicate well with customers, and work effectively in a fast-paced small team.
Team and opportunity
Small, growing technology organization supporting manufacturers with high-volume patient and drug-related reporting.
Opportunity to help build processes, introduce improvements, and contribute to future AI and analytics initiatives.
Potential for significant team growth as new business opportunities develop.
Decisions Made
Client interviews will begin as one-on-one meetings, followed by broader team interviews for promising candidates.
Normal interview turnaround is approximately one week, but current workload may extend this to two weeks.
Similar Jobs You May Be Interested In
Principal Engineer – Data & Microservices Architecture
Snowflake Data Engineer
Senior Data Engineer, Azure Databricks (remote)
Snowflake ETL/ELT Data Engineer (Hybrid - Must be local to Denver CO)
Databricks Data Engineer
[C]-Sr. Data Engineer Level 4
Data Engineer IV
Data Engineer (Azure/Databricks)
Data Governance Architect (Data Catalog Engineer Role)
Data Engineer Ab initio
Senior Analytics Engineer - Marketing Data
Azure Data Engineer
Position Details
Posted:
Nov 10, 2026
Reference Number:
564-48080
Employment:
Full-time
City:
Job Origin:
CIEPAL_ORGANIC_FEED
Share this job:
Please wait..!!

