Develop ETL pipelines in Azure Data Factory to support various types of data loads and business needs.
Work with the Enterprise Data Management team to create, expand and sustain data procedures with the Data Lakehouse.
Use Sql to support National Pharmacy Team business/users, create new data deliverables, and enhance current scripts.
Map data from source to target by applying standardization techniques to ensure accuracy.
Migrate legacy SSIS packages into Azure Data Factory
Apply quality assurance practices that minimize errors and/or data discrepancies.
Perform data resolution efforts if an issue arises.
Apply database schema concepts that ensure optimally running applications / routines.
Collaborate directly with internal teammates to take business ideas and develop technical requirements that meet the business request.
Follow all department procedures, including source control, release, and change management procedures.

Requirements

Previous experience working in the pharmacy industry.
Experience with Azure Data Factory
Experience with SSIS
Worked in a Scrum and or Kanban based team
Comfortable using MS Teams, chat, channels, and integration with SharePoint for communications and collaboration
Computer Science Degree of related fields OR direct applicable experience in an enterprise environment
2+ years of working with ETL tools in an enterprise environment.
2+ years of direct experience using SQL Server with advanced knowledge in relational database querying.

Benefits

📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLAzure Data FactorySQLSSISdata standardizationdata migrationquality assurancedatabase schemadata resolutionrelational database querying

Soft Skills

collaborationcommunicationproblem-solvingattention to detailadaptabilityteamworktechnical requirements developmentprocess adherence

Certifications

Computer Science Degree