Northwestern Medicine is looking for a data driven, business-minded; results oriented Senior Analytics Developer to join our team to uncover insights that drive strategy and optimal decision making for the executive team and leaders across the organization.
Requirements
- 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 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
- Demonstrated competency with Microsoft Excel, PowerPoint, and/or Access
- Experience developing, designing and supporting applications and relational databases
Responsibilities
- 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.
- 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 design and development 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.
Other
- Bachelor’s degree required
- Four or more years of experience in a role querying and/or analyzing data
- 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
