Analytics Developer, Hospital Medicine (1-2 Days a week Onsite)

Northwesternmedicine; Chicago (IL); On-site; USD 85,000 - 115,000; Full time

Job summary

Northwestern Medicine is seeking an Analytics Developer to transform data into actionable insights for executives and leaders across the organization. You will work cross-functionally to understand the who, what, and whys of the business and deliver analytic solutions that drive strategic decisions.

The role focuses on building data warehouse and analytic capabilities, pipelines, and visualizations, while partnering with clinical and administrative teams to enable data-driven decision making and

Qualifications

• Bachelor's degree required.
• Two or more years of experience in a role querying and/or analyzing data.
• Experience using SQL for data extraction, manipulation, and reporting.
• Experience working with business users in developing analytical solutions to meet business needs.
• Experience with data visualization tools such as Tableau, Crystal Reports, SSRS, Power BI, etc.
• Experience in development lifecycle including analysis, design, development and support with emphasis on structured programming.
• Knowledge of relational database skills including SQL knowledge and ability to create queries and stored procedures.

Responsibilities

• Develop 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.
• Assists with development of pipelines to synthesize raw data into actionable information.
• Evaluates data quality and interprets results in a clear, concise manner.
• Develops documentation on requirements, decisions, design, modifications, and maintenance.
• Collaborates with the business to gather and execute on requirements, exceeding customer expectations.
• Works with multiple departments on joint projects and training.

Skills

SQL

Data visualization

Analytical thinking

Communication

Python

Epic Clarity data

Education

Bachelor's degree

Tools

Tableau

Crystal Reports

SSRS

Power BI

SSIS

SSAS

SQL Server

Epic Clarity

Job description

The 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 oriented Analytics Developer to join our team.

The Analytics Developer uncovers 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.

The Analytics Developer is 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.¿

• Assists with development of pipelines to synthesize raw data into actionable information.
• Evaluates data quality and interprets results in a clear, concise manner.
• Develops documentation on requirements, decisions, design, modifications, and any associated maintenance.¿
• Supports analytics projects and is accountable for collaborating with the business to gather and execute on requirements, which exceed customer expectations.
• Works collaboratively with and support multi-departments efforts and projects.
• Participates and contributes to overall training development, maintenance, and facilitate trainings both internally and externally as needed.
• Performs other duties and functions as assigned.

Minimum Requirements:

Education:

Bachelor's degree required.

Experience:

• Two or more years of experience in a role querying and/or analyzing data
• Experience using SQL for data extraction, manipulation, and reporting
• Experience working with business users in developing analytical solutions to meet business needs
• Experience with 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
• Knowledge of relational database skills including SQL knowledge and the ability to create queries and stored procedures

Behavioral Attributes:

• 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 the Microsoft stack (SSRS, SSMS, SSIS, SSAS)
• Previous experience working in an Agile environment
• Experience using a software package for statistical analysis (R, Python, etc.)

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 t