Senior Analytics Developer
About The Position
The Senior Analytics Developer delivers data warehouse and analytic solutions that help Northwestern Medicine leaders make informed decisions and advance the organization’s mission. The role works cross-functionally with business and technical teams to understand organizational data, uncover insights, and realize the value of NM’s data assets. It includes writing ETL packages, developing visualizations, performing data and statistical analyses, and administering systems that deliver information across the health system. The developer serves as a functional and content expert for data pipelines, supports information delivery through dashboards, reports, and cubes, and contributes to data quality, documentation, training, and collaborative project work. The role calls for curiosity, strong analytical ability, a commitment to data accessibility, accuracy, and quality, and clear communication with diverse stakeholders. Northwestern Medicine Information Services supports healthcare transformation through innovative solutions, advanced technologies, AI and automation, cyber controls, and improved end-user support.
Requirements
- Bachelor’s degree.
- Four or more years of experience in a role querying and/or analyzing data.
- Experience using 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 knowledge of analytic tools and solutions with junior-level staff and serving as a subject matter expert within a team or department.
- 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, with particular emphasis on structured programming.
- Ability to work independently with business users to gather and scope requirements 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 a statistical analysis software package 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, values, and department goals.
- Collaborate with technical and business professionals across the organization.
- Deliver data warehouse and analytic 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 transform raw data into actionable information.
- Use relational database skills, advanced SQL, complex queries, and stored procedures.
- Assist in designing and developing information delivery components, including 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 work with business stakeholders to gather and execute requirements that exceed customer expectations.
- Collaborate on and support multi-department efforts and projects.
- Share expertise on 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.
Benefits
- Tuition reimbursement
- Loan forgiveness
- 401(k) matching
- Lifecycle benefits
- A wide range of benefits supporting physical, emotional, and financial well-being and protection for unexpected life events
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
