Developer III - Database

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!

Job Details

PRIMARY DUTIES AND RESPONSIBILITIES:

Intrinsiq Specialty Solutions, Inc. - Work with business analysts and business users to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses. Design and develop database applications using SQL Server Integration Services, TSQL, and Stored Procedures. Consult with the business to determine the logical design for new business solutions according to existing data architecture. Perform code reviews, analyze execution plans, and re-factor inefficient code. Follow data standards, resolve data issues, complete unit testing, and complete system documentation for ETL processes. Collaborate with business analysts, source system experts, and other team members to determine data extraction and transformation requirements. Design, develop, test, deploy, and maintain data processing systems and build scalable data pipelines using Azure Data Factory to extract, transform, and load structured as well as unstructured data. Implement secure storage and access controls for sensitive data using Azure Key Vaults. Leverage Azure Databricks for advanced analytics tasks including ETL jobs and machine learning workflows. Utilize Spark fundamentals to optimize the performance of big data processing tasks. Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions. Ensure data quality by implementing appropriate validation checks and error-handling mechanisms. Work closely with DevOps teams to integrate data engineering processes into CI/CD pipelines. Monitor the performance of data pipelines and troubleshooting any issues that arise. Document technical specifications processes, and best practices. Utilize Azure Databricks, Azure DW, Python and Scripts. #LI-DNI

MINIMUM SKILLS, KNOWLEDGE AND ABILITY REQUIREMENTS:

Requires a Bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering, Information Technology or a related field. Requires minimum 2 years of experience in a Data Engineer, Software Engineer or related position maintaining data processing systems and building scalable data pipelines using Azure Data Factory. Experience must include: writing complex SQL queries to perform data extraction; troubleshooting issues in production in a timely fashion and working across teams of different skill levels; configuring and supporting managing ETL automation with SQL Server Integration Services; developing Spark applications for data extraction, transformation, and aggregation; and utilizing Azure Functions, Azure Databricks, Azure DW, Python and Scripts. Fully remote work permitted.

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

Full time

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 CompaniesAffiliated Companies: IntrinsiQ Specialty Solutions, Inc