Res Data Analyst Assoc

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 business objectives.

Administration

• Develop standardized templates, policies, and procedures for internal and external reporting.
• Designs and prepares documentation for qualitative and quantitative data analysis.
• Discuss findings with senior management

Development

• Develop queries and quality metrics.
• Interprets results using a variety of techniques, ranging from simple data aggregation to more complex statistical analysis.
• Manages complex databases.

Performance

• Completes data cleaning and organizes data files for analysis.
• Reviews data and identifies quality issues.
• Presents findings in an appropriate manner.

Supervises

• Provides work direction and/or supervises staff such as team members, subordinates, contractors, vendors, students, etc.

Miscellaneous

Performs other duties as assigned.

• 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.
• 2 years data analysis/report writing or similar experience required.

Infrastructure

• SQL/MySQL/Postgres

Programming Languages and Frameworks

• PL/SQL
• Python

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.

Target hiring range for this position will be between $56,782 - $70,978 per year or per hour. Offered salary will be determined by the applicant's education, experience, knowledge, skills and abilities, as well as internal equity and alignment with market data., At Northwestern, we are proud to provide meaningful and competitive benefits. The available benefits package for this position will include health, dental, vision, disability, and life insurance; paid vacation and holidays; paid medical/sick and parental leave; tuition benefits for the employee and dependents; pre-tax and flex spending accounts for commuting and dependent care; generous retirement savings options; and wellness programs. For a comprehensive overview of available benefits, including eligibility details, 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.

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.