Data Integration Team Lead

> Position: Data Integration Team Lead Location: Jeffersonville, IN Remote Status: On-Site Job Id: 788 # of Openings: 0 Our Company: PharmaCord is a leading provider in specialty drug patient support services.

We are committed to enhancing the patient experience on therapy by providing them with compassionate support throughout their journey to better health.

We accomplish this through our world class technology and our talented team of benefit specialists, nurses, pharmacists, case managers, data scientists, pharmacy techs, program managers, and other incredibly talented team members.

We are PharmaCord, a purpose-driven organization on a rapid growth journey.

Our Team: Our teams at PharmaCord are highly motivated and passionate for providing the highest quality customer support to our patients.

We look for individuals interested in growing with our company and working in an exciting, open and collegial work environment.

PharmaCord is seeking a Data Integration Team Lead for its Jeffersonville, IN location who will oversee a team of data integration specialists responsible for integrating data from various sources into our company's data warehouse.

The Team Lead will manage the team's workload, delegate tasks, and ensure that projects are completed on time and within budget.

A typical day in the life of the Data Integration Team Lead will include but not be limited to the following: * Work on developing innovative and automated visualizations in Microsoft Power BI as well as SQL queries or procedures for the purpose of insights and analysis pertaining to decision-making process * Responsible for writing complex SQL Queries, Procedures, CTEs, Functions to develop Ad-hoc queries for pharmaceutical clients * Create custom reports and modify existing queries and reports to enhance organizational productivity or supply data to clients * Perform predictive modeling, data analysis, correlation analysis, and regression analysis as required to glean insights from rich patient data * Responsible for designing the technical architectural plan for the launch of new programs for all Data feeds * Analyzing the impact of various Patient Assistance Programs on patient's medication adherence and persistence thereby guiding the team in the key decision-making process * Establish and roll out the better development practices for the team to improve the data feeds quality, including accuracy, guidelines, timeline estimates, agile development, and regular bug triaging * Lead a team of data integration specialists, providing guidance, support, and feedback on their work * Work with stakeholders to understand their data integration needs and ensure that projects align with business goals * Manage the team's workload and delegate tasks to ensure that projects are completed on time and within budget * Design and implement data integration solutions that are scalable, maintainable, and efficient * Develop and maintain data integration processes, including ETL (extract, transform, load) workflows, data mapping, and data validation * Collaborate with other teams, including data engineering, data science, and analytics, to ensure that data is available and accurate for analysis and reporting * Develop and maintain documentation for data integration processes and solutions * Monitor data integration processes to ensure that they are running smoothly and proactively address any issues that arise * Stay up to date with industry trends and best practices in data integration and share this knowledge with the team and other stakeholders.

* Other duties as assigned Qualifications & Requirements: * Must have a Bachelor's degree in Computer Science, Information Systems, or a related field and 4 years of related experience, which must include at least 2 years of experience in the following specific areas: * Data integration, ETL, SQL development, and using Microsoft SQL tools * Utilizing data warehousing concepts and methodologies * T-SQL, Python, MULESOFT, Java, and other programming languages used in data integration * Data governance and security best practices * Database management systems (DBMS) including Oracle, Microsoft SQL Server, MySQL, and PostgreSQL * ETL processes, APIs and data warehouses and tools, including Microsoft SQL Server Integration Services, Informatica and Talend * Data modeling concepts and techniques, which must include entity-relationship modeling, dimensional modeling, and schema design to ensure efficient data integration and optimal database structures * Integrating data through APIs (Application Programming Interfaces) and web services * Using RESTful APIs, SOAP, JSON, XML, and other integration protocols * Working with cloud-based data integration solutions, including AWS Glue and Azure Data Factory Once you land this position, you'll get to enjoy: Our Benefits & Perks * Company paid Short-term Disability (STD) * Increased competitive 401(k) company match up to 4% * Affordable Medical, Dental, and Vision benefits - PharmaCord covers 75% of Medical Premiums for our employees * Wellness discounts of up to $260 per year for participation in wellness program * Annual HSA employer contribution * Company paid and voluntary Life Insurance options * Voluntary Life, AD&D and Long-Term Disability Insurances * Paid Parental Leave of Absence * Wellness and Employee Assistance Programs * PTO benefits, flex days and paid holidays * Employee Referral Program * Tuition reimbursement program A Career You'll Love * Working for PharmaCord - voted Best Places to Work in Kentucky for 2019 and 2021 * Work for a company that values diversity and makes deliberate efforts to create in inclusive workplace * Opportunities for advancement with a company that supports personal and professional growth * A challenging, stimulating work environment that encourages new ideas * Exposure to many learning and development opportunities * Playing a crucial part in the lives of our patients, physicians, and pharmacies by enhancing the patient services experience * Our state of the art Headquarters building offering many amenities including collaborations spaces, outdoor dining, walking path, marketplace café, and more!

At PharmaCord, we don't just accept difference - we celebrate it, support it and we thrive on it for the benefit of our employees, our products and our community.

PharmaCord is proud to be an equal opportunity employer.