Senior SQL Server Developer (remote)
About the position 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 for 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, and 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. 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. • 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. 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. • 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-haves • 3PL Experience is Major plus. • AS400, RPG Knowledge. • Windows Server Administration. • Azure Cloud Services. Benefits • Medical, dental, and vision care. • Backup dependent care. • Adoption assistance. • Infertility coverage. • Family building support. • Behavioral health solutions. • Paid parental leave. • Paid caregiver leave. • Training programs. • Professional development resources. • Opportunities to participate in mentorship programs. • Employee resource groups. • Volunteer activities. Apply tot his job