Utilizes multiple quantitative and qualitative datasets from a variety of sources and interprets results using various techniques, ranging from simple data aggregation via statistical analysis to complex data mining. Assists in the design, development and implementation of business solutions partnering with clients to identify analytical requirements. Compiles reports, charts, and tables based on established statistical methods.

This particular role is the Northwestern Medicine Enterprise Data Warehouse (NMEDW). The Data Analyst Associate will work with physicians, researchers, and other data consumers to define requirements, formulate queries, validate results, and generate reports using Microsoft SQL Server Reporting Services.

Specific Responsibilities:

Strategic Planning

• Partners with clients to define requirements based on research objectives.

Administration

• Designs and prepares documentation for qualitative and quantitative data analysis.

Development

• Merges data from multiple sources in preparation for analysis.
• Interprets results of analyses for use in reports and presentations.
• Develops queries, quality metrics, and reporting tools for the Northwestern Medicine campus.

Performance

• Reviews data and Identifies quality issues

Miscellaneous

• Performs other duties as assigned.

Minimum Qualifications:

• Successful completion of a full 4-year course of study in an accredited college or university leading to a bachelor's or higher degree; OR appropriate combination of education and experience.
• Expert Level SQL skills.
• Please see information highlighted below.
  • Infrastructure
    • SQL/MySQL/Postgres
  • Compliance
    • HIPAA
    • IRB
  • Analytical
    • critical thinking
    • data modeling
    • database design/ data structure
    • decision making
    • problem solving
    • Troubleshooting
  • Project
    • Collaboration and teamwork
    • Organizational skills

Minimum Competencies: (Skills, knowledge, and abilities.)

• Exceptional interpersonal skills, including the ability to establish and maintain effective relationships with physicians, management, staff, and other customers.
• Demonstrated customer service skills, including the ability to use appropriate judgment, independent thinking and creativity when resolving customer issues.
• Ability to effectively handle challenging situations.
• Ability to balance multiple priorities.
• Excellent verbal and written communication skills.

Preferred Qualifications:

• Experience with medical data.
• Experience with Microsoft SQL Server Reporting Services tools is preferred, however other relevant experience will be considered.

Benefits:
At Northwestern, we are proud to provide meaningful, competitive, high-quality health care plans, retirement benefits, tuition discounts and more! Visit us at https://www.northwestern.edu/hr/benefits/index.html to learn more.

Work-Life and Wellness:
Northwestern offers comprehensive programs and services to help you and your family navigate life’s challenges and opportunities, and adopt and maintain healthy lifestyles.
We support flexible work arrangements where possible and programs to help you locate and pay for quality, affordable childcare and senior/adult care. Visit us at https://www.northwestern.edu/hr/benefits/work-life/index.html to learn more.

Professional Growth & Development:
Northwestern supports employee career development in all circumstances whether your workspace is on campus or at home. If you’re interested in developing your professional potential or continuing your formal education, we offer a variety of tools and resources. Visit us at https://www.northwestern.edu/hr/learning/index.html to learn more.

Northwestern strongly recommends COVID-19 vaccinations and boosters for people who can obtain them as a critical tool for minimizing severe illness. More information can be found on the COVID-19 and Campus Updates webpage.

The Northwestern campus sits on the traditional homelands of the people of the Council of Three Fires, the Ojibwe, Potawatomi, and Odawa as well as the Menominee, Miami and Ho-Chunk nations. We acknowledge and honor the original people of the land upon which Northwestern University stands, and the Native people who remain on this land today.