Senior Analytics Developer (1 - 2 Days Onsite)

Northwestern Memorial Healthcare•Chicago, IL

21h•$46 - $62•Hybrid

About The Position

The Senior Analytics Developer delivers data warehouse and analytics solutions that provide actionable information to Northwestern Medicine. The role works with business leaders and technical teams to understand organizational needs and use the health system’s data assets to support strategy and decision-making. It includes developing ETL packages, visualizations, analyses, and systems; synthesizing raw data through data pipelines; and supporting information delivery across the organization. The position serves as a content expert for analytics pipelines and relational databases, contributes to dashboards, reports, and cubes, and supports ETL design and development. The developer evaluates data quality, documents requirements and technical decisions, owns analytics projects, collaborates with business partners, and shares expertise with colleagues. The role also contributes to training and supports cross-department projects.

Requirements

Bachelor’s degree.
Four or more years of experience querying and/or analyzing data.
Experience with the Microsoft stack, including SSRS, SSMS, SSIS, and SSAS.
Experience using SQL for data extraction, manipulation, and reporting.
Strong relational database skills, including advanced SQL and the ability to create complex queries and stored procedures.
Experience sharing analytic tools and solutions expertise with junior-level staff and serving as a subject matter expert.
Previous experience working in an Agile environment.
Experience with report-writing and data-visualization tools such as Tableau, Crystal Reports, SSRS, or Microsoft Power BI.
Experience across development activities including analysis, design, development, and support, particularly structured programming.
Ability to independently gather and scope requirements with business users and recommend analytical solutions.
Demonstrated competency with Microsoft Excel, PowerPoint, and/or Access.
Ability to communicate complex quantitative analysis clearly, precisely, and in an actionable manner.
Excellent verbal and written communication skills.
Ability to manage multiple priorities.
Effective problem-solving and critical-thinking skills.

Nice To Haves

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 statistical analysis software such as R or Python.

Responsibilities

Advocate for data accessibility, accuracy, and quality.
Identify data trends and insights that support the organization’s mission, vision, and values.
Deliver data warehouse and analytics solutions by writing ETL packages, developing visualizations, performing data and statistical analyses, and administering systems.
Serve as a functional and content expert for pipelines that synthesize raw data into actionable information.
Use relational database skills, advanced SQL, complex queries, and stored procedures.
Assist with the design and development of dashboards, reports, and cubes.
Assist with ETL design and development, including data analysis, source-target mapping, quality profiling, change data capture, and program performance.
Evaluate data quality and communicate results clearly and concisely.
Document requirements, decisions, designs, modifications, and associated maintenance.
Own analytics projects and collaborate with business partners to gather and execute requirements.
Collaborate on and support multi-department efforts and projects.
Share expertise in analytic tools and solutions and serve as a subject matter expert within the department.
Contribute to training development and maintenance, and facilitate training internally and externally as needed.
Perform other duties and functions as assigned.