Azure Data Engineering Lead & BI Specialist

RareMed Solutions; Coraopolis (Allegheny County); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Hybrid work structure

On-site when required

Job summary

RareMed Solutions is seeking a Data & Analytics Engineering Lead to design, build, and maintain scalable data pipelines and infrastructure. You will collaborate with pharmacists, stakeholders, and leadership to translate requirements into actionable data solutions using Azure services and Power BI.

The role emphasizes hands-on engineering, data governance, and mentorship of analysts and engineers. A hybrid work setup is offered with on-site presence in the Pittsburgh area as needed.

Qualifications

• Education: Bachelor’s or Master’s degree in Computer Science, Information Technology, or Data Analytics.
• Experience: Minimum of 5 years of experience in data engineering with a focus on Microsoft Azure 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 database management systems.
• Knowledge of Power BI for reporting 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.

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 data storage solutions, including data lakes and data warehouses, ensuring data is organized, accessible, and secure.
• Data Delivery: Create and deliver data files reliably and repeatably via pipelines and triggers.
• Data Visualization: Use Power BI to create and maintain reports and dashboards that provide actionable insights.
• Collaboration: Work with pharmacists, business stakeholders, and RareMed Solutions leadership to understand data requirements.
• Performance Optimization: Monitor and optimize data pipelines and storage solutions for efficiency.
• Data Governance: Implement and enforce data governance policies to ensure quality and compliance.
• Mentorship: Provide technical leadership and mentorship to junior data engineers.
• Innovation: Stay updated with latest industry trends in data engineering, Azure, and visualization tools.
• Other duties as assigned

Skills

Data modeling

ETL

Data warehousing

Azure Data Factory

Azure Synapse Analytics

SQL

Power BI

Python/Scala/Java

Problem solving

Communication

Mentoring

Education

Bachelor’s or Master’s degree in CS/IT/Data Analytics

Tools

Azure Data Factory

Azure Synapse Analytics

Power BI

Snowflake

SSIS

Tableau

Job description

RareMed Solutions is seeking a Data & Analytics Engineering Lead to design, build, and maintain scalable data pipelines and infrastructure. You will collaborate with pharmacists, stakeholders, and leadership to translate requirements into actionable data solutions using Azure services and Power BI.

The role emphasizes hands-on engineering, data governance, and mentorship of analysts and engineers. A hybrid work setup is offered with on-site presence in the Pittsburgh area as needed.