Res Data Analyst Assoc

**Department:** MED-Urology **Salary/Grade:** EXS/8 *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.* **Job Summary** 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. **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. * 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. **Benefits** *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 parentalleave;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.* **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 University is an Equal Opportunity Employer and does not discriminate on the basis of protected characteristics, including disability and veteran status. View Northwestern’s* *non-discrimination statement* *. Job applicants who wish to request an accommodation in the application or hiring process should contact the Office of Civil Rights and Title IX Compliance. View* *additional information on the accommodations process* *.*