Senior Analytics Developer

Northwestern Medicine; Chicago (IL); On-site; USD 110,000 - 140,000; Full time

Job summary

Northwestern Medicine in Chicago seeks a Senior Analytics Developer to translate data into strategic insights for senior leaders. You will collaborate across functions to turn NM’s data assets into decision-ready information. The role emphasizes data quality, analytics governance, and cross-team partnership.

The position requires 4+ years in data analysis, strong SQL, and proficiency with SQL Server, SSIS/SSRS/SSAS, and BI tools like Power BI or Tableau. Healthcare experience preferred.

Qualifications

• Four or more years of experience querying and/or analyzing data.
• Experience using the Microsoft stack (SSRS, SSMS, SSIS, SSAS).
• Experience using SQL for data extraction, manipulation, and reporting.
• Strong knowledge of relational databases and complex queries.
• Experience mentoring junior staff and working in an Agile environment.
• Experience with report writing and data visualization tools (Tableau, Crystal Reports, SSRS, Power BI).
• Experience across development lifecycle with emphasis on structured programming.

Responsibilities

• Deliver data warehouse and analytic solutions by building ETL packages and dashboards.
• Synthesize raw data into actionable information for stakeholders.
• Develop documentation on requirements, decisions, design and maintenance.
• Own analytics projects and collaborate with business teams to gather requirements.
• Share expertise and train staff on analytic tools and solutions.
• Support multi-department initiatives and cross-functional projects.

Skills

SQL

Microsoft Excel

PowerPoint

Data analysis

Data visualization

Education

Bachelor’s degree

Tools

SSRS

SSMS

SSIS

SSAS

Tableau

Crystal Reports

Power BI

Epic Clarity

Job description

Description

TheSenior Analytics Developer, reflects the mission, vision, and values of NM, adheres to the organization’s Code of Ethics and Corporate Compliance Program, and complies with all relevant policies, procedures, guidelines and all other regulatory and accreditation standards.

Northwestern Medicine is looking for a data driven, business-minded; results orientedSenior Analytics Developerto join our team. TheSenior Analytics Developeruncovers insights that drive strategy and optimal decision making for the executive team and leaders across the organization. In this role, you will be charged with understanding the ‘who, what, and whys’ of our business - working cross-functionally to realize the value of NM’s data assets.

Northwestern Medicine Information Services drives innovative, high-value solutions to transform health care.

We are committed to supporting the relentless pursuit of better medicine by providing exceptional service to our patients and guests as well as internal clients across the organization. To ensure excellence, our team goes to extraordinary lengths to ensure that our systems work together seamlessly.

Northwestern Medicine understands that technology plays an integral role in shaping the future of health care. Information Services strategically supports the organization by:

• Leveraging AI, automation and rollout of advanced cyber controls that support digital transformation strategies
• Implementing advanced technologies in clinical and administrative areas
• Furthering development of the end user support model to help enhance modern infrastructure

Responsibilities:

To succeed in this role, you must be innately curious, deeply analytical, highly driven, and a strong communicator. Some of those qualities include but are not limited to:

• Be a Data Champion! Effective analysis is only possible with good data - be an advocate of data accessibility, accuracy and quality.
• Be Curious! Find data nuggets, trends and other analytical goodies that help support our mission, vision, and values and advance our department as a whole.
• Be a Team Player! Collaboration is what makes us great – come prepared to work with a diverse cross-section of technical and business professionals.

• TheSenior Analytics Developeris responsible for delivering data warehouse and analytic solutions by 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 design and development 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 and execute on requirements, which exceed customer expectations.
• 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 both internally and externally as needed.
• Performs other duties and functions as assigned.

Qualifications

Minimum Requirements:

Education

• Bachelor’s degree required

Experience

• Four or more years of experience in a role querying and/or analyzing data
• Experience using the Microsoft stack (SSRS, SSMS, SSIS, SSAS)
• Experience using SQL for data extraction, manipulation, and reporting
• Strong knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures
• Experience sharing skills, experience, knowledge, and expertise with junior level staff on analytic tools and solutions and serve as subject matter expert within team and department
• Previous experience working in an Agile environment
• Experience with report writing and data visualization tools such as:¿ Tableau, Crystal Reports,¿SSRS, Microsoft Power BI, etc.¿
• Experience in all areas of development including analysis, design, development and support with particular emphasis on structured programming¿¿

Behavioral Attributes

• Independently work with business users to gather and scope requirements and recommend analytical solutions to meet business needs
• Demonstrated competency with Microsoft Excel, PowerPoint, and/or Access
• Ability to communicate complex quantitative analysis in a clear, precise, and actionable manner
• Excellent verbal and written communication skills
• Ability to manage multiple-priorities
• Effective problem solving and critical thinking skills

Preferred:

• Experience developing, designing and supporting applications and relational databases¿
• Previous experience working with Epic Clarity data
• Previous healthcare experience, ideally with a health system
• Experience using a software package for statistical analysis (R, Python, etc.)

Equal Opportunity

Northwestern Medicine is an equal opportunity employer (disability, VETS) 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.

Background Check

Northwestern Medicine conducts a background check that includes criminal history on newly hired team members and, at times, internal transfers. If you are offered a position with us, you will be required to complete an authorization and disclosure form that gives Northwestern Medicine permission to run the background check. Results are evaluated on a case-by-case basis, and we follow all local, state, and federal laws, including the Illinois Health Care Worker Background Check Act.

Artificial Intelligence Disclosure

Artificial Intelligence (AI) tools may be used in some portions of the candidate review process for this position, however, all employment decisions will be made by a person.

Benefits

We offer a wide range of benefits that provide employees with tools and resources to improve their physical, emotional, and financial well-being while providing protection for unexpected life events.

Click on or copy and paste URL to your browser to view detailed benefits information https://jobs.nm.org/benefits

Please refer to the Benefits Eligibility by Employment Classification to determine benefits eligibility for job postings.

If sign-on bonus is included in a job posting eligibility is as followed: Internal employees and rehires who left Northwestern Medicine within 1 year are not eligible for the sign-on bonus. Exception: New graduate internal employees seeking their first licensed clinical position as a Registered Nurse at NM may be eligible.