The Population Health & Policy Data Analyst II oversees activities related to data integrity, security and enhancement of the value of data. The Data Analyst II may direct the movement of data across multiple systems; oversee its validation and organization and make sure that data is available to appropriate people and systems within an organization. The Data Analyst II will also develop and execute reports that will be important assets of the practice as they continue to develop and evaluate data tools, repositories, and vocabularies.

The Data Analyst II will support the Kronk Lab within the Institute for Health Equity Research (IHER) and the Queer Data Consortium (QDC), and is expected to collaborate within the consortium, the broader institute, and the Department of Population Health Science & Policy, supporting both funded and unfunded research projects, many of which relate to the development and maintenance of a LGBTQIA+ research database, lgbtDB, and bibliometric analyses related to that database. The Data Analyst II will also participate in projects relating to LGBTQIA+ representation in electronic health records (EHRs) and clinical datasets, as well an in broader linguistic analyses and initiatives related to health equity. In addition to data linking, mapping, analytics, and presentation, especially in relationship to established data and ethics standards and vocabularies, you will also be expected to assist in abstract, manuscript, and grant writing as needed. Duties may be modified from time to time depending on research direction and need, but will focus greatly on the development and maintenance of application programming interfaces (APIs) and broader data pipelining projects, as well as establishing and maintaining communications with other research and data centers, institutions, libraries, and archives.

Day-to-day tasks will involve programming using Python, R, SQL, and SPARQL, and using ontologies and other knowledge organization systems (often represented using OWL and RDF) to parse through and organize broader swathes of data and datasets as part of ETL processes used to maintain larger research projects and make LGBTQIA+ more accessible, usable, searchable, and equitable. Such data often includes research abstracts and manuscripts, archival and library collections, sociopolitical and legal data, and population-related and spatiotemporal datasets. The Data Analyst II will be expected to write and test code, and make code available to other users and research groups, as well as to run programs that parse through and clean data in semi-automated and automated manners.

Qualifications

• Bachelors degree in computer science, statistics and/or related field required, or combination of equivalent work experience and education. Masters degree in relevant field of study preferred (e.g., statistics, epidemiology, computer science, etc.).
• 3+ years of analytics experience including report development and database application/management experience, preferably in a large medical center or healthcare environment

Must be able to work a hybrid schedule; in office 2-3 days/week.

Responsibilities

• Work with the research, clinical, administrative staff to define data reporting needs.
• Develop analytic reports that are easily understandable by research, clinical, and administrative staff.
• Use modeling techniques and tools in analyzing and specifying data structure, such as utilizing controlled vocabularies and ontologies and mapping those entities to one another
• Implement best practices in data management to ensure the integrity of the data, the quality of data processes and deliver analyzable or analyzed data to a variety of internal and external clients of the affiliated practice
• Maintain data integrity and completes data analysis as necessary.
• Complete data capture, data extraction and analysis, including writing and reviewing unit tests for developed tools and technologies.
• Develop, maintain or implement procedures for data entry, data cleaning, documentation and other administrative tasks, including, but not limited to, managing user accounts, monitoring data imports and exports, keeping up with issues and discussions relating to developed software projects, assessing data completeness, and creating data backups.
• Document, implement, maintain or recommend operating methods to improve processing, distribution, data flow, collection, database editing procedures, including, but not limited to, creation of application programming interfaces (APIs) that can assist in ETL with the relevant database systems.
• May define parameters for file or space utilization, as well as work in archiving and documenting data sources.
• Work closely with IT management and staff
• Access data in the Data Warehouse, as required
• Assist research, clinical, administrative staff with queries, statistical analyses, reports and technical difficulties related to data retrieval
• Design and write custom applications needed to ensure the database meets requirements for the entry, management and reporting of data, including creation and management of complex data pipelines and assisting in coding and designing visual interfaces for such data.
• Identify and recommend solutions to data management issues, including ethical and technical issues.
• Maintain knowledge of the current regulations and technologies related to data management.
• Write and prepare manuscripts and other materials for internal and external audiences.
• Perform other related duties.
• Help to build and perpetuate a practice environment and culture of collaboration, respect, learning, flexibility and fun among all team members.