Application Engineer II

It's More Than a Career, It's a Mission.

Our people are the foundation of our success. By joining our growing team at Sarah Cannon Research Institute (SCRI), a subsidiary of McKesson, you will have the opportunity to become part of one of the largest community-based cancer programs to advance oncology treatments and improve outcomes for cancer patients across the globe. We look for mission-driven candidates who have a desire to advance the fight against cancer and make a difference in the lives of patients diagnosed with cancer every day.

Our Mission

People who live with cancer - those who work to prevent it, fight it, and survive it - are at the heart of every decision we make. Bringing the most innovative medical minds together with the most passionate caregivers in their communities, we are transforming care and personalizing treatment. Through clinical excellence and cutting-edge research, SCRI is redefining cancer care around the world.

The Application Engineer II is a position on the Sarah Cannon Data Integration team. The Sarah Cannon Data Integration team is responsible for analysis, design, development and support of ETL pipelines, reports and databases. The Application Engineer II will spend time developing, testing, and reviewing ETL pipelines and reports alongside other developers.

As an Application Engineer II you will work closely with all team members to create a modular, scalable solution that addresses current needs, but will also serve as a foundation for future success. This role requires 'self-starters' who are experienced in problem solving and capable of bringing clarity to complex situations. It requires contributing to strategic technical direction and system architecture approaches for individual projects and platform migrations. It also requires working closely with others, frequently in a matrixed environment, and with little supervision.

The Application Engineer II is a mid-level development position that focuses on the following items:

• Collaborates with data source owners to determine the best method and requirement for integration/extraction to support the solution

• Designs and develops technical solutions, including integrations with external systems both on premise/private cloud and the public cloud

• Creates databases in both SQL and no-SQL technologies

• Implements Azure data services solutions using Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake

• Designs and develops PowerBI reports and provide insights to improve decision-making

• Provides on-call assistance as needed

• Investigates, determines and communicates root cause of ETL, report and database issues, working with end users and support staff at all levels of the organization

• Participates in/Leads meetings as a member of IT

• Helps define and document Sarah Cannon data integration/reporting development standards and procedures

• Helps define data governance standards and policies for Azure Data Lake(s)

Knowledge, Skills, and Abilities Required:

• 5+ years of experience in a developer role

• 1+ year of Azure - must understand the basics

• Demonstrated ability to establish and build strong relationships across a broad range of personality types

• Excellent ability to communicate effectively with SCRI staff and information technology personnel verbally and in writing

• Demonstrated strong customer orientation

• Practice and adherence to the "Code of Conduct" philosophy and "Mission and Value Statement".

• Working knowledge of Microsoft Office (Outlook, Word, Excel, and PowerPoint)

Experience with at least four of the following technologies:

• Azure Data Factory

• Azure Synapse Analytics

• Azure Data Lake

• SQL Server/Azure SQL Database and SQL Managed Instances

• Microsoft PowerBI with PowerQuery and DAX

• Azure Functions

• Azure Logics Apps

About Sarah Cannon Research Institute

Sarah Cannon Research Institute (SCRI) is one of the world's leading oncology research organizations conducting community-based clinical trials. Focused on advancing therapies for patients over the last three decades, SCRI is a leader in drug development. In 2022, SCRI formed a joint venture with former US Oncology Research to expand clinical trial access across the country. It has conducted more than 750 first-in-human clinical trials since its inception and contributed to pivotal research that has led to the majority of new cancer therapies approved by the FDA today. SCRI's research network brings together more than 1,300 physicians who are actively enrolling patients into clinical trials at more than 250 locations in 24 states across the U.S. Please click here to learn more about our research offerings.

We care about the well-being of the patients and communities we serve, and that starts with caring for our people. That's why we have a Total Rewards package that includes comprehensive benefits to support physical, mental, and financial well-being. Our Total Rewards offerings serve the different needs of our diverse colleague population and ensure they are the healthiest versions of themselves. For more information regarding benefits through our parent company, McKesson, please click here.

As part of Total Rewards, we are proud to offer a competitive compensation package. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.