Benefits
Northwestern Medicine is powered by a community of colleagues who are purpose-driven and committed to our mission to deliver world-class care. Here, you'll work alongside some of the best clinical talent in the nation leading the way in medical innovation and breakthrough research with Northwestern University Feinberg School of Medicine.
We recognize where you've been, and we support where you're headed. We celebrate diverse perspectives and experiences, which fuel our commitment to equity and culture of service.
Grow your career with comprehensive training and development opportunities, mentorship programs, educational support and student loan repayment.
From discovery to delivery, come help us shape the future of medicine.
Description
IS Team Leads for various and unanticipated worksites throughout the U.S (HQ: Chicago, IL). Applies knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures. Provides facilitation, analysis, design, and execution of analytical solutions and ensures those solutions are leveraged by users and across teams. Creates, documents, and communicates the integrated approach of all the components of the solution. Independently works with business users to gather and scope requirements and recommend solutions to meet business needs. Assists with ETL design and development including data analysis, source-target mapping, quality profiling, change data capture, program performance. Evaluates data quality and interprets results in a clear, concise manner. Develops documentation on requirements, decisions, design, modifications, and any associated maintenance. Owns healthcare analytics projects and is accountable for collaborating with the business to gather and execute on requirements. Mentors staff at all levels and seen as subject matter expert through sharing skills, experience, knowledge, and expertise. Participates and contributes to overall training development and maintenance as well as facilitates trainings both internally and externally as needed. Present technical solutions to stakeholders. Tech: SQL Server: complex queries and stored procedures; SQL for data extraction, manipulation and reporting; SSRS, SSMS, SSIS, SSAS; Power BI/Tableau/Crystal Reports; R/Python for statistical analysis; Excel: Pivot Tables, Dashboards; Agile environment.
REF64958Q
Qualifications
Bachelor's degree in IS or related field plus five years of progressive experience in Querying/Analyzing Data required. Required skills: 3 years experience in: SQL Server: complex queries and stored procedures; SQL for data extraction, manipulation and reporting; mentoring staff. Experience must include: SSRS, SSMS, SSIS, SSAS; Power BI/Tableau/Crystal Reports; Agile environment; R/Python for statistical analysis; healthcare analytics; present technical solutions to stakeholders; Excel: Pivot Tables, Dashboards. Background and health screen required. Some remote work available.
Equal Opportunity
Northwestern Medicine is an affirmative action/equal opportunity employer and does not discriminate in hiring or employment on the basis of age, sex, race, color, religion, national origin, gender identity, veteran status, disability, sexual orientation or any other protected status.
Benefits
Northwestern Medicine is powered by a community of colleagues who are purpose-driven and committed to our mission to deliver world-class care. Here, you'll work alongside some of the best clinical talent in the nation leading the way in medical innovation and breakthrough research with Northwestern University Feinberg School of Medicine.
We recognize where you've been, and we support where you're headed. We celebrate diverse perspectives and experiences, which fuel our commitment to equity and culture of service.
Grow your career with comprehensive training and development opportunities, mentorship programs, educational support and student loan repayment.
From discovery to delivery, come help us shape the future of medicine.
Description
IS Team Leads for various and unanticipated worksites throughout the U.S (HQ: Chicago, IL). Applies knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures. Provides facilitation, analysis, design, and execution of analytical solutions and ensures those solutions are leveraged by users and across teams. Creates, documents, and communicates the integrated approach of all the components of the solution. Independently works with business users to gather and scope requirements and recommend solutions to meet business needs. Assists with ETL design and development including data analysis, source-target mapping, quality profiling, change data capture, program performance. Evaluates data quality and interprets results in a clear, concise manner. Develops documentation on requirements, decisions, design, modifications, and any associated maintenance. Owns healthcare analytics projects and is accountable for collaborating with the business to gather and execute on requirements. Mentors staff at all levels and seen as subject matter expert through sharing skills, experience, knowledge, and expertise. Participates and contributes to overall training development and maintenance as well as facilitates trainings both internally and externally as needed. Present technical solutions to stakeholders. Tech: SQL Server: complex queries and stored procedures; SQL for data extraction, manipulation and reporting; SSRS, SSMS, SSIS, SSAS; Power BI/Tableau/Crystal Reports; R/Python for statistical analysis; Excel: Pivot Tables, Dashboards; Agile environment.
REF64958Q
Qualifications
Bachelor's degree in IS or related field plus five years of progressive experience in Querying/Analyzing Data required. Required skills: 3 years experience in: SQL Server: complex queries and stored procedures; SQL for data extraction, manipulation and reporting; mentoring staff. Experience must include: SSRS, SSMS, SSIS, SSAS; Power BI/Tableau/Crystal Reports; Agile environment; R/Python for statistical analysis; healthcare analytics; present technical solutions to stakeholders; Excel: Pivot Tables, Dashboards. Background and health screen required. Some remote work available.
Equal Opportunity
Northwestern Medicine is an affirmative action/equal opportunity employer and does not discriminate in hiring or employment on the basis of age, sex, race, color, religion, national origin, gender identity, veteran status, disability, sexual orientation or any other protected status.