Our team members are at the heart of everything we do. At Cencora, we are united in our responsibility to create healthier futures, and every person here is essential to us being able to deliver on that purpose. If you want to make a difference at the center of health, come join our innovative company and help us improve the lives of people and animals everywhere. Apply today!
SUMMARY:
The position will be responsible for monitoring overnight activities for both Data Innovations team as well as the Cencora Health Innovation Platform (CHIP) APIs. Leveraging monitoring and reporting tools to analyze and identify failed transactions/pipelines, trace and troubleshoot errors, and report outages, this role is vital in ensuring the quality of data for both our analytics and CHIP services.
PRIMARY RESPONSIBILITIES:
Monitor overnight/weekend orchestration jobs to ensure successful data refreshes. Trace, identify, and troubleshoot failed pipelines.
Assess tasks and timelines required for on-time and quality deliverables.
Collaborate with colleagues to share and propagate best practices.
Maintain a data and information environment that provides consistent and accurate reporting of client data.
Monitor health of APIs via system alerts, worker restarts/crashes, high utilization, and any spikes in monitoring queue volumes for potential issue escalation.
Research and analyze alerts, errors, and traffic to identify source of issue. Utilize ServiceNow for issue tracking.
Document/review CHIP transactions/logs for success and failures using admin tools.
Check downstream application and document transaction status to ensure successful filing of transactions.
.
Experience and Educational Requirements
Minimum 3 to 6 years of experience leading the creation/support of data and analytic products.
Strong knowledge of and experience with reporting packages like Power BI, SSRS, Tableau, or Qlik View/Qlik Sence.
Proficient in writing SQL queries for different database environments like SQL Server, Azure, and Snowflake.
Experience in PowerBI/ Tableau Reporting deployments, Tableau administration tasks, including backup and recovery, monitoring, and security a plus.
Proficiency in data analysis and research.
MINIMUM SKILLS, KNOWLEDGE, AND ABILITY REQUIREMENTS:
Azure Data Engineer with Azure Data Factory pipelines skills
Job monitoring skills, ability to trace and identify failed pipelines
Familiar with Data Storage, Databricks, and Pyspark
Skilled in system monitoring, research, and analysis, able to identify issues and root causes.
Strong problem-solving, quantitative, analytical skills.
Ability to understand and update complex SQL queries
Must be able to manage multiple and changing priorities simultaneously in a fast-paced environment, ensuring aggressive deadlines are met.
Working knowledge and experience with App Insights, Power BI, APIs, Oracle (SQL), DevOps, and ServiceNow required.
Strong time management skills - able to prioritize, organize, and plan work effectively.
Ability to track key performance metrics/indicators (KPIs) on API transactions such as system throughput time and others as needed.
Excellent verbal and written communication skills, both with business-facing and technical-facing colleagues.
Strong problem-solving ability.
Benefit offerings outside the US may vary by country and will be aligned to local market practice. The eligibility and effective date may differ for some benefits and for team members covered under collective bargaining agreements.
Cencora is committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, age, disability, veteran status or membership in any other class protected by federal, state or local law.
The company’s continued success depends on the full and effective utilization of qualified individuals. Therefore, harassment is prohibited and all matters related to recruiting, training, compensation, benefits, promotions and transfers comply with equal opportunity principles and are non-discriminatory.
Cencora is committed to providing reasonable accommodations to individuals with disabilities during the employment process which are consistent with legal requirements. If you wish to request an accommodation while seeking employment, please call 888.692.2272 or email hrsc@cencora.com. We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned