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
Senior Analytics Developers for Chicago, IL location. Deliver data warehouse and analytic solutions. Writing ETL packages, developing visualizations, performing data and statistical analyses, and administering systems to deliver information to the health system. Serves as a functional and content expert of pipelines to synthesize raw data into actionable information. Applies knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures. Assists with the analysis, design and development and support of information delivery components including dashboards, reports, and cubes. 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 analytics projects and is accountable for collaborating with the business to gather, scope and execute on requirements and recommend analytical solutions to meet business needs. Works collaboratively with and supports multi-departments efforts and projects. Shares skills, experience, knowledge, and expertise with staff on analytic tools and solutions and serves as subject matter expert within the department. Participates and contributes to overall training development, maintenance, and facilitate trainings. Technical Environment: SSIS, SSAS; SSRS; SSMS; SQL for data extraction, manipulation, and reporting; SQL DB, create complex queries and stored procedures; agile environment; Tableau, Crystal Reports, Microsoft Power BI; all areas of development including analysis, design, development, support, structured programming.
EV64412G
Qualifications
Bachelor's degree in IT, Information Systems or related field plus 4 years of experience in ETL/DW/Data Analytics required. Required: 2 years with: SSIS, SSAS; SSRS; SSMS; SQL for data extraction, manipulation, and reporting; SQL DB: create complex queries and stored procedures; Experience must include gather and scope requirements and recommend analytical solutions to meet business needs; mentor/train junior staff on analytics tools; serve as subject matter expert; Agile environment; Tableau, MS Power BI; analysis, design, development and support; structured programming. May work remotely in Chicago area with ability to commute to HQ Chicago office as required. Background check and drug screen required.
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
Senior Analytics Developers for Chicago, IL location. Deliver data warehouse and analytic solutions. Writing ETL packages, developing visualizations, performing data and statistical analyses, and administering systems to deliver information to the health system. Serves as a functional and content expert of pipelines to synthesize raw data into actionable information. Applies knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures. Assists with the analysis, design and development and support of information delivery components including dashboards, reports, and cubes. 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 analytics projects and is accountable for collaborating with the business to gather, scope and execute on requirements and recommend analytical solutions to meet business needs. Works collaboratively with and supports multi-departments efforts and projects. Shares skills, experience, knowledge, and expertise with staff on analytic tools and solutions and serves as subject matter expert within the department. Participates and contributes to overall training development, maintenance, and facilitate trainings. Technical Environment: SSIS, SSAS; SSRS; SSMS; SQL for data extraction, manipulation, and reporting; SQL DB, create complex queries and stored procedures; agile environment; Tableau, Crystal Reports, Microsoft Power BI; all areas of development including analysis, design, development, support, structured programming.
EV64412G
Qualifications
Bachelor's degree in IT, Information Systems or related field plus 4 years of experience in ETL/DW/Data Analytics required. Required: 2 years with: SSIS, SSAS; SSRS; SSMS; SQL for data extraction, manipulation, and reporting; SQL DB: create complex queries and stored procedures; Experience must include gather and scope requirements and recommend analytical solutions to meet business needs; mentor/train junior staff on analytics tools; serve as subject matter expert; Agile environment; Tableau, MS Power BI; analysis, design, development and support; structured programming. May work remotely in Chicago area with ability to commute to HQ Chicago office as required. Background check and drug screen required.
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.