Technical Lead, Data Warehouse and Client Integration
Internal Number: 20130214-1
Headquartered in Dublin, Ohio, Cardinal Health, Inc. (NYSE: CAH) is a global, integrated healthcare services and products company connecting patients, providers, payers, pharmacists and manufacturers for integrated care coordination and better patient management. Backed by nearly 100 years of experience, with more than 50,000 employees in nearly 60 countries, Cardinal Health ranks among the top 20 on the Fortune 500. At Cardinal Health, we're developing the innovative products and services that make healthcare safer and more productive. Join a growing, global company genuinely committed to making a difference for our customers and communities.
The Third Party Logistics (3PL) business is a complex service rich organization that is a tremendous growth driver for Cardinal Health.
We are seeking an experienced technical lead to join the 3PL team to design new, innovative data warehouse and integration solutions that support the 3PL business and its integration with other businesses / areas across the pharmaceutical segment.
Provide technical leadership over 3PL data warehouse and data feeds. Manage a team of contractors delivering BI enhancements and data feed integrations. Lead delivery of new BI reports and data feeds as well as advanced integrations including Veeva (CRM) integrations, and API client integrations with other Cardinal Health business (i.e. Sonexus).
Lead high level design and implementation estimates for client reports and integrations partnering with appropriate business, IT, and clients (manufacturers).
Own and drive the 3PL data warehouse and client integration strategy and roadmap partnering with all appropriate stakeholders on the 3PL IT and business teams.
Identify and drive ways to improve, streamline, and standardize client integration patterns including driving new ways for clients to gain access to their data through APIs or data sharing.
Support existing client integrations including troubleshooting and resolving client integration issues.
Partner with 3PL run team on resolving client integration issues as they arise.
Manage the scheduling and monitoring / alerting of client data feeds and other integrations.
Participate in the audit and validation of systems as needed.
What is expected of you and others at this level:
Applies advanced knowledge and understanding of concepts, principles, and technical capabilities to manage a wide variety of projects
Participates in the development of policies and procedures to achieve specific goals
Recommends new practices, processes, metrics, or models
Works on or may lead complex projects of large scope
Projects may have significant and long-term impact
Provides solutions which may set precedent
Independently determines method for completion of new projects
Receives guidance on overall project objectives
Acts as a mentor to less experienced colleagues
Bachelor's degree in information technology, management information systems, business/operations analysis preferred, or equivalent experience preferred.
5+ years' experience with relational database and star schema design and expert knowledge of SQL preferred.
Experience with the Snowflake data warehouse platform is a plus.
3+ years' experience with designing, building, and monitoring of interfaces (ideally experience with Axway, Boomi, GXS, and Splunk) is preferred.
Willingness to learn proprietary integration technologies such as Lua / Iguana.
Familiarity with batch integration including EDI terminology, transmissions and documentation standards is required. Experience with EDI translation and the OpenText platforms is a plus.
Experience in integration architecture and patterns including integration via APIs and services is required.
Conceptual knowledge of hardware/software platforms and cloud architecture including but not limited to operating systems, databases, application servers, web servers and integration technologies is preferred.
Experience with reporting and integration development languages and paradigms including Business Objects, Tableau, REST/SOAP APIs, Python, Perl, and microservices architecture is a plus
Anticipated salary range: $115,000 - $140,000
Bonus eligible: Yes
Benefits: Health insurance, 401k Contributions, Paid Time Off, Vacation, STD/LTD
Candidates who are back-to-work, people with disabilities, without a college degree, and Veterans are encouraged to apply.
Cardinal Health supports an inclusive workplace that values diversity of thought, experience and background. We celebrate the power of our differences to create better solutions for our customers by ensuring employees can be their authentic selves each day. Cardinal Health is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, ancestry, age, physical or mental disability, sex, sexual orientation, gender identity/expression, pregnancy, veteran status, marital status, creed, status with regard to public assistance, genetic status or any other status protected by federal, state or local law.
Headquartered in Dublin, Ohio, Cardinal Health, Inc. (NYSE: CAH) is a distributor of pharmaceuticals, a global manufacturer and distributor of medical and laboratory products, and a provider of performance and data solutions for healthcare facilities.We are a crucial link between the clinical and operational sides of healthcare, delivering end-to-end solutions and data-driving insights that advance healthcare and improve lives every day. With deep partnerships, diverse perspectives and innovative digital solutions, we build connections across the continuum of care. With more than 50 years of experience, we seize the opportunity to address healthcare's most complicated challenges – now, and in the future.As a global, growing company, we’re able to offer rewarding careers that let you make a positive impact on our customers and communities.