Research Data Analyst

Target hiring range for this position is $70,000 - $75,000. 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.

About the Role

Provides expertise in data management, quality assurance, analysis and reporting. Establishes data accuracy and validity derived from a variety of systems. Performs data analysis using statistical techniques. Researches and analyzes information using multiple databases and creates reports of data and results. Assists in the preparation and delivery of decision support reports to both internal and external customers.

Responsibilities

• Partners with clients to define requirements based on business objectives.
• Develops standardized templates, policies, and procedures for internal and external reporting.
• Designs and prepares documentation for qualitative and quantitative data analysis.
• Discusses findings with senior management.
• Develops queries and quality metrics.
• Interprets results using a variety of techniques, ranging from simple data aggregation to more complex statistical analysis.
• Manages complex databases.
• Completes data cleaning and organizes data files for analysis.
• Reviews data and identifies quality issues.
• Presents findings in an appropriate manner.
• Provides work direction and/or supervises staff such as team members, subordinates, contractors, vendors, students, etc.
• Performs other duties as assigned.

Requirements

• 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.

Skills

• Medium to advanced proficiency in SQL sufficient to pass qualifying examination for Poweruser status within the Northwestern Medicine Enterprise Data Warehouse.
• Programming preferably in scripting language used for data analysis (PERL, Python, R).
• Utilization of data analysis and visualization libraries.
• Demonstrated ability to follow detailed instructions and research protocols.
• Ability to work independently, as well as collaboratively in a team environment.
• Digital Repository
• eIRB
• Code Repositories (Git, Subversion)
• Hadoop, MapReduce
• Information security
• Microsoft Exchange, Microsoft Lync, Microsoft Office (Word, Excel, PowerPoint, Access, Outlook)
• SQL/MySQL/Postgres
• Python, Shell Scripting, XML
• HIPAA, IRB
• Data Mining, Data Modeling, Data Warehouse Design/Develop, Database Design/Data Structure
• Code documentation
• Collaboration and Teamwork, Functional Documentation
• Iterative & Incremental Development, Planning

Preferred Qualifications

• Education or experience in scientific computing.
• Experience programming and/or analyzing data in healthcare environment.
• Development and deployment of web-based systems for secure database access and management.
• Browser and web-based interactive data visualizations (e.g. D3.js).
• Machine learning and other data mining libraries (e.g. scikit-learn, NLP).
• Proficiency in SQL concepts such as joining tables, filtering data, aggregating data, sorting data, and identifying bad data.
• Proficiency in commonly used functions to enhance the output of SQL queries, such as aggregate, ranking, string, date and time functions.
• Knowledge of neurosciences and/or cancer biology.
• Confidence and experience in interacting with surgeons, physicians, nurses, and scientific experts.

Benefits

• 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.
• Wellness programs.
• Comprehensive programs and services to help with life’s challenges and opportunities, including flexible work arrangements, childcare, and senior/adult care support.
• Professional growth and development resources.