Summary:

Under the direction of the Action Intelligence & Operations Manager, the Senior Data Analyst is responsible for database utilization and administration, data consolidation, data analysis and management reporting. Oversees the metrics and develops actionable recommendation for data consolidation and standardization requirements to execute. Collaborates with other teams such as Business Solutions Analysts, sales and IT to achieve business results.

Primary Duties and Responsibilities:

• Responsible for collaborating on the development, documentation of customized reports from the database

• Understands tables in the Micro data warehouse and associated data marts to establish accurate retrieval of information for analytical use

• Utilize available tools such as SQL, Business Objects, SAS and Microsoft Access to provide analytic reports for senior management as well as customers

• Very strong communication skills to translate reporting in order to accurately meet the actual information and deadline needs of users

• Educate requestors as to appropriate and desirable parameters to ensure they get the information they need

• Sets the guidelines for the collaboration with end users to gather data consolidation and standardization requirements and ensure proper testing and validation

• Driving force on data remediation, standardization and cleansing

• Relies on experience and judgment to plan and accomplish goals along with setting teams priorities

• Performs a variety of strategic and tactical tasks

• Other duties as assigned

Required Skills and Qualifications:

• Requires a Bachelor's degree in Information Science or related discipline and/or 3-5 years of experience in the field or in a related area

• Experience in full project life cycle data management and analytic development experience, preferably 2 years supervisory and/or cross-functional experience

• Proven experience with report design, writing, technical requirements analysis, business process modeling/mapping, methodology development, and data modeling

• Extensive experience with core development tools Business Objects, Crystal , SQL, SQL Server Report Services

• Considerable exposure to the operation and analysis of relational database software and standards, as well as data retrieval methodologies

• Specific knowledge of DB2, Oracle, MS SQL Server

• Ability to communicate effectively both orally and in writing; interacts with all levels of associates and management within the organization

• Thorough knowledge and understanding of business principles, processes and technology

• Excellent analytical, conceptual and problem solving skills to evaluate business problems and apply knowledge to identify appropriate solutions

• Extensive knowledge of data processes and methodologies, data imports and export protocols (EDI, API)

• Experienced with Pivot tables, Multi-Dimensional analysis and Cross Tabulations

• Strong project management skills. Ability to be self-directed and accountable for reporting function

• Ability to think outside the box to identify solutions

• Ability to work across the organization in all business segments with the ability to address technical and non-technical issues

• Sound understanding of data management principles including data architecture, strategy, preparation, quality and maintenance; solid understanding of the integration aspects of various modules of MS SQL Server

• In depth knowledge of data and information governance methodologies and underlying MS SQL Server technologies are required skills in this role

• Able to manage priorities and timelines

• Excellent organizational and leadership skills

• Solid teamwork and interpersonal skills

• Strong presentation skills

What Cencora offers

We provide compensation, benefits, and resources that enable a highly inclusive culture and support our team members’ ability to live with purpose every day. In addition to traditional offerings like medical, dental, and vision care, we also provide a comprehensive suite of benefits that focus on the physical, emotional, financial, and social aspects of wellness. This encompasses support for working families, which may include backup dependent care, adoption assistance, infertility coverage, family building support, behavioral health solutions, paid parental leave, and paid caregiver leave. To encourage your personal growth, we also offer a variety of training programs, professional development resources, and opportunities to participate in mentorship programs, employee resource groups, volunteer activities, and much more. For details, visit https://www.virtualfairhub.com/cencora

Equal Employment Opportunity

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

Affiliated Companies