Senior Analytics Developer

Job Title: Senior Analytics Developers

Location: Various and unanticipated worksites throughout the U.S. (HQ: Chicago, IL)

Schedule: Full-time

Requisition ID:

At Northwestern Medicine, every patient interaction makes a difference in cultivating a positive workplace. This patient-first approach is what sets us apart as a leader in the healthcare industry. As an integral part of our team, you'll have the opportunity to join our quest for better healthcare, no matter where you work within the Northwestern Medicine system. At Northwestern Medicine, we pride ourselves on providing competitive benefits: from tuition reimbursement and loan forgiveness to 401(k) matching and lifecycle benefits, we take care of our employees. Ready to join our quest for better?

Senior Analytics Developers for various and unanticipated locations (HQ: Chicago, IL). Deliver 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 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. 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

Server DB, create complex queries and stored procedures; agile environment; Tableau; Microsoft BI;

Databricks; Azure DevOps; all areas of development including analysis, design, development, support,

structured programming.

Bachelor's degree in Computer Science, IT, Information Systems or related field plus 4 years of

experience in ETL/DW/data analytics required.

Required: 4 years with: SQL for data extraction, manipulation, and reporting; 2 years: SQL Server DB:

create complex queries and stored procedures; Tableau/ PowerBI/CrystalR /SSRS. Experience must

include: SSIS; SSMS; Azure DevOps; Databricks; gather and scope requirements and recommend

analytical solutions to meet business needs; mentor/train junior staff on analytics tools and solutions; serve

as analytics subject matter expert; Agile environment; solution analysis, design, development and support;

structured programming.

Some remote work available from states NM is registered for business but must be available for onsite

training or meetings as needed. Background check and drug screen required. SQL skills assessment

required. $110,282/year- $126,680/year.

LMT87138Y

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.

If we offer you a job, we will perform a background check that includes a review of any criminal convictions. A conviction does not disqualify you from employment at Northwestern Medicine. We consider this on a case-by-case basis and follow all state and federal guidelines.

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. Please visit our Benefits section to learn more.