Data Analyst II - Institute for Health… at Mount Sinai… · New York

Description 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 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, 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.

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.

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
• 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 you've written (any type), and a Github link if you have one.

Employer Description Strength through Unity and Inclusion

The Mount Sinai Health System is committed to fostering an environment where everyone can contribute to excellence. We share a common dedication to delivering outstanding patient care. When you join us, you become part of Mount Sinai’s unparalleled legacy of achievement, education, and innovation as we work together to transform healthcare. We encourage all team members to actively participate in creating a culture that ensures fair access to opportunities, promotes inclusive practices, and supports the success of every individual.

At Mount Sinai, our leaders are committed to fostering a workplace where all employees feel valued, respected, and empowered to grow. We strive to create an environment where collaboration, fairness, and continuous learning drive positive change, improving the well-being of our staff, patients, and organization. Our leaders are expected to challenge outdated practices, promote a culture of respect, and work toward meaningful improvements that enhance patient care and workplace experiences. We are dedicated to building a supportive and welcoming environment where everyone has the opportunity to thrive and advance professionally. Explore this opportunity and be part of the next chapter in our history.

About the Mount Sinai Health System:

Mount Sinai Health System is one of the largest academic medical systems in the New York metro area, with more than 48,000 employees working across eight hospitals, more than 400 outpatient practices, more than 300 labs, a school of nursing, and a leading school of medicine and graduate education. Mount Sinai advances health for all people, everywhere, by taking on the most complex health care challenges of our time — discovering and applying new scientific learning and knowledge; developing safer, more effective treatments; educating the next generation of medical leaders and innovators; and supporting local communities by delivering high-quality care to all who need it. Through the integration of its hospitals, labs, and schools, Mount Sinai offers comprehensive health care solutions from birth through geriatrics, leveraging innovative approaches such as artificial intelligence and informatics while keeping patients’ medical and emotional needs at the center of all treatment. The Health System includes more than 9,000 primary and specialty care physicians; 13 joint-venture outpatient surgery centers throughout the five boroughs of New York City, Westchester, Long Island, and Florida; and more than 30 affiliated community health centers. We are consistently ranked by U.S. News & World Report's Best Hospitals, receiving high "Honor Roll" status, and are highly ranked: No. 1 in Geriatrics, top 5 in Cardiology/Heart Surgery, and top 20 in Diabetes/Endocrinology, Gastroenterology/GI Surgery, Neurology/Neurosurgery, Orthopedics, Pulmonology/Lung Surgery, Rehabilitation, and Urology. New York Eye and Ear Infirmary of Mount Sinai is ranked No. 12 in Ophthalmology. U.S. News & World Report’s “Best Children’s Hospitals” ranks Mount Sinai Kravis Children's Hospital among the country’s best in several pediatric specialties. The Icahn School of Medicine at Mount Sinai is ranked No. 11 nationwide in National Institutes of Health funding and in the 99th percentile in research dollars per investigator according to the Association of American Medical Colleges. Newsweek’s “The World’s Best Smart Hospitals” ranks The Mount Sinai Hospital as No. 1 in New York and in the top five globally, and Mount Sinai Morningside in the top 20 globally.

Equal Opportunity Employer

The Mount Sinai Health System is an equal opportunity employer, complying with all applicable federal civil rights laws. We do not discriminate, exclude, or treat individuals differently based on race, color, national origin, age, religion, disability, sex, sexual orientation, gender, veteran status, or any other characteristic protected by law. We are deeply committed to fostering an environment where all faculty, staff, students, trainees, patients, visitors, and the communities we serve feel respected and supported. Our goal is to create a healthcare and learning institution that actively works to remove barriers, address challenges, and promote fairness in all aspects of our organization.

Compensation

The Mount Sinai Health System (MSHS) provides salary ranges that comply with the New York City Law on Salary Transparency in Job Advertisements. The salary range for the role is $69999.88 - $105124.12 Annually. Actual salaries depend on a variety of factors, including experience, education, and operational need. The salary range or contractual rate listed does not include bonuses/incentive, differential pay or other forms of compensation or benefits.