$90K - 120K a year
Write code and queries to import, clean, validate, and evaluate datasets; link and integrate data; develop and maintain data transfer routines; and prepare documentation.
Six years related experience or Bachelor's plus two years, knowledge of MSSQL Server ETL and data management, data modeling skills, communication skills, and familiarity with reporting and visualization tools.
This position is limited to California Residents and may require travel to Richmond and/or Sacramento, California. Candidates hired into this position may have the ability to work Remotely/Hybrid in California. Department of Pediatrics is one of the largest departments within the UCSD School of Medicine with comprehensive clinical programs, extensive basic science and clinical research, and diverse educational opportunities for students, residents and fellows. The internationally renowned faculty play a major role in medical and graduate student training, providing educational and programmatic offerings that span several disciplines and provide diversity to meet the interests of a broad spectrum of students and scholars. More than one hundred trainees at the graduate student and postdoctoral level, as well as more than 300 professional, research and administrative staff who along with the department administrators interact closely with the faculty. The diverse mix of ages, backgrounds, and talents creates a robust work environment with challenging career opportunities and a commitment to continued growth potential. We constantly seek to recruit highly motivated, technologically advanced and interested individuals to become a part of our dynamic cutting-edge research, clinical, and educational environment. In collaboration with the California Department of Public Health (CDPH), the Division of Environmental Health oversees the ongoing surveillance activities of the California Birth Defects Monitoring Program (CBDMP). The mission of CBDMP is to collect and analyze data to identify opportunities for preventing birth defects and improving the health of babies. Under the supervision of the CBDMP Registry Data Systems Manager and as a part of the Data Management team, the Data Systems Analyst contributes to continuing the CBDMP legacy as the world-leading birth defects registry. The incumbent writes code and queries to import, clean, validate, and evaluate datasets from multiple sources, link and integrate data using probabilistic and deterministic programming methods, develop and maintain data transfer routines, and prepare documentation. Applies data/information management concepts, department/unit and campus/medical center/OP methodologies, policies and procedures to resolve a variety of data/information management issues. Works on data/information management problems of moderate scope and complexity where analyses of situations or data require a review of a variety of factors. Performs other duties as assigned. MINIMUM QUALIFICATIONS • Six (6)years of related experience, education/training, OR a Bachelor's degree in related area plus two (2) years of related experience/training. • Knowledge of data integration, validation, and ETL in MSSQL Server. • Knowledge of data management systems, practices and standards. • Knowledge relating to logical data design, data warehouse design, data integration or the management of web content or other unstructured data. • Ability to prepare simple data models under guidance of more senior professionals. • Familiarity with important types of data models such as logical/relational models, dimensional models and document models. • Intermediate knowledge of relevant rules and regulations. • Demonstrated ability to work with others from diverse backgrounds. • Demonstrated effective communication and interpersonal skills. Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization. • Self-motivated and works independently and as part of a team. • Demonstrated problem-solving skills. Able to learn effectively and meet deadlines. • Demonstrated service orientation skills. • Strong organizational skills. • Strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems. • Ability to represent relevant information in abstract models. Critical thinking skills and attention to detail. • Familiarity with reporting and data visualization tools such as SSRS, Crystal Reports and Power BI. Knowledge of standard approaches to documenting business and technical processes using diagramming tools such as Visio. PREFERRED QUALIFICATIONS • Experience in data integration using XML and JSON. Familiarity with the HL7 standard a plus. • Knowledge of machine learning tools and AI in the context of data processing, matching, or validation.
This job posting was last updated on 9/4/2025