Data Analyst II Institute for Health Equity Research

The 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 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 libraires 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.

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

• 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
• Advanced knowledge of database applications / management Python RDF SQL and SPARQL R and Git. Knowledge of Wikibase MediaWiki PHP and SHACL preferred; some familiarity with ontologies controlled vocabularies and other knowledge organization systems expected.

When submitting the application please include a brief writing sample (topic of choice) a piece of code youve written (any type) and a Github link if you have one.