Senior Analytics Developer (1 - 2 Days Onsite)

Job Description

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

Responsibilities

• Be a Data Champion - advocate of data accessibility, accuracy and quality
• Be Curious - find data nuggets, trends and other analytical insights
• Be a Team Player - collaborate with a diverse cross-section of technical and business professionals
• 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
• Serve as a functional and content expert of pipelines to synthesize raw data into actionable information
• Apply knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures
• Assist with the design and development of 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, program performance
• Evaluate data quality and interpret results in a clear, concise manner
• Develop documentation on requirements, decisions, design, modifications, and any associated maintenance
• Own analytics projects and collaborate with the business to gather and execute on requirements
• Work collaboratively with and support multi-department efforts and projects
• Share skills, experience, knowledge, and expertise with staff on analytic tools and solutions and serve as subject matter expert within the department
• Participate and contribute to overall training development, maintenance, and facilitate trainings both internally and externally as needed
• Perform other duties and functions as assigned

Qualifications

Minimum Requirements:

• Bachelor's degree required
• 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.)