Data & Analytics Engineering Lead
About The Position
The Data & Analytics Engineering Lead provides strategic and tactical support to RareMed Solutions and reports directly to the Director of Data Analytics. The role works with RareMed Solutions teams to determine reporting requirements, develop data pipelines, and distribute reports to internal and external stakeholders. It designs, develops, and maintains data infrastructure to support efficient and secure processing of large volumes of data and provides actionable insights through data visualization. The role serves as an organizational expert on data infrastructure, working with leadership to understand team needs and recommend solutions for data and analytics. It also identifies data quality issues and implements solutions, mentors and coaches analysts, engineers, and other data team members, and may delegate work according to organizational priorities. The role is hybrid, combining remote work with in-office requirements. Employees must live within commuting distance of Pittsburgh, Pennsylvania, and be able to report to the office as needed. When working remotely, employees need reliable internet access and are responsible for setting up a private, separate home-office workspace.
Requirements
- Bachelor’s or Master’s degree, or equivalent experience, in Computer Science, Information Technology, or Data Analytics.
- At least 5 years of data engineering experience, focused on 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.
- Experience with SSIS and Tableau or Power BI.
- 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 for data integration, transformation, and loading.
- Oversee management and optimization of data lakes and data warehouses so data is organized, accessible, and secure.
- Use data pipelines and triggers to create and deliver data files reliably and repeatably.
- Use Power BI to create and maintain reports and dashboards that provide actionable insights to stakeholders.
- Collaborate with pharmacists, business stakeholders, and RareMed Solutions leadership to understand data requirements and deliver solutions that meet business needs.
- Monitor and optimize data pipeline and storage solution performance for efficient processing and retrieval.
- Implement and enforce data governance policies and best practices for data quality, consistency, and regulatory compliance.
- Provide technical leadership and mentorship to junior data engineers and foster continuous learning and improvement.
- Stay current with data engineering, Azure, and data visualization developments and apply relevant knowledge to drive innovation.
- Identify data quality issues and implement solutions to potential issues arising through data analysis and reporting.
- Coach analysts, engineers, and other data team members; delegate work based on organizational priorities when needed.
- Perform other duties as assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
