Job Description

Cencora is looking for a passionate, innovative and experienced Senior SQL Server Developer to join our Data Warehouse Team. Support our exciting transformation of data delivery operations to carry ICS into the coming decades of growth. This key role is responsible designing new and efficient data processing methods and refactoring current operations to match new standards. The Senior SQL Server Developer will collaborate closely with Business Intelligence, EDI, Account Management many other groups. As a 60/40 split between new development and operational production support, lessons learned from support will provide the insight needed to improve our platform and overall efficiency. If you love a fast-paced and challenging work environment with many future world-wide support opportunities, you may be our ideal candidate.

PRIMARY DUTIES AND RESPONSIBILITIES:

• Monitoring and leading database development requests through their lifecycle and ensures that the technical solution meets business requirements.

• Design of new centralized data processing methods and implementation of refactored code to meet the new standards

• Evaluates designs from other groups and team members to ensure optimal efficiency and performance and supportability.

• Ensures code walk-thru of systems solutions is completed.

• Supports the ongoing operations, Level 3 and On-Call support.

• Ensures all documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) is provided according to standards.

• Examines post-implementation continuous improvement efforts in enhancing performance and helps developers to create and or performance tune database queries.

  View Orignal JOB on: italents.net

• Provides technical assistance and mentors staff in relation to database design and development.

• Ensures data management standards, policies, and procedures and single source data strategy is adhered to.

• Develops work plans or reviews other work plan timelines and manages workflows to meet project timeframes.

• Provides status to stakeholders.

• Contributes to strategic planning meetings and provides guidance and expertise on system options, risk, cost vs. benefits, and impacts on business processes and goals.

EXPERIENCE AND EDUCATIONAL REQUIREMENTS:

• Requires some training in fields such as computer sciences, engineering or similar vocations generally obtained through completion of a four year Bachelor's Degree program,

• Normally requires a minimum of six (6) years directly related and progressively responsible experience, including at least two (2) years experience at a senior / lead level.

MINIMUM SKILLS, KNOWLEDGE AND ABILITY REQUIREMENTS:

• Fundamental knowledge of cost benefit analysis; ability to prepare analyses Familiarity with EDI standards and practices, communications translation software and EDI audits and controls

• Ten (10) or more years of experience with SQL Server – T-SQL  

• Eight (8) or more years of experience with ETL Design and Implementation

• Three (3) or more years experience with SQL Server Administration

• Five (5) or more years of experience with Data Warehouse Database Design           

• Three (3) or more years of experience with Transactional Database Design

• Four (4) or more years experience with PowerShell Scripting

• Four (4) or more years experience with C#                

NICE TO HAVE, NOT REQUIRED:

• 3PL Experience is Major plus

• AS400, RPG Knowledge

• Windows Server Administration               

• Azure Cloud Services

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