What are the responsibilities and job description for the Database Analyst I position at Keck School of Medicine?
The USC Mark and Mary Stevens Neuroimaging and Informatics Institute and Laboratory of Neuroimaging (INI, www.ini.usc.edu) are world leaders in the development of advanced computational and scientific approaches for the comprehensive mapping of brain structure and function. LONI’s unique multidisciplinary environment and cutting-edge resources allow for integration of clinical, psychological and genotypic information with neuroimaging phenotypes for research questions in neurology, psychiatry and developmental neurobiology.
The Laboratory of Neuroimaging has been at the forefront of neuroimaging research for almost three decades and maintains a large research data repository through which thousands of scientists obtain data to study normal development, aging, and disease progression. Our team is dedicated to making a difference through improving access to neuroscience research data. We are looking for a full-time database analyst with ETL/data mapping and data modeling experience. You will play a vital role in expanding our informatics systems and facilitating research into a number of neurological diseases and disorders.
ESSENTIAL FUNCTIONS
- Profile source data and create source-to-target data mappings
- Perform data quality/integrity checks matching pre- and post-mapped data
- Identify & address problems that may impact data mapping/data integration
- Perform data modeling and data manipulation using SQL and rules-based languages
- Document and communicate progress, problems and related issues
- Implement best practices in data quality and metadata management
- Assist with database maintenance tasks
SKILLS, KNOWLEDGE AND ABILITIES
- Solid knowledge of database structures, theories, principles and practices
- Ability to read, write, execute and evaluate SQL, stored procedures, functions and triggers
- Working knowledge of UNIX and experience writing shell scripts
- Familiarity with data integration strategies
- Ability to create, monitor and execute test scripts
- Strong analytical, problem solving and organizational skills
- Experience with programming languages such as Java a plus
- Effective verbal and written communication skills
- Good time management and organization skills with attention to detail
REQUIREMENTS & QUALIFICATIONS
- Experience working with complex data models and data relationship
- Previous experience performing data profiling, data mapping and metadata management
- Strong database design and SQL skills
- Demonstrated understanding of data model entities and their relationships
- Ability to read, write and edit XML
- Expertise in data harmonization a plus
- Minimum Education: Bachelor's degree, Combined experience/education as substitute for minimum education
- Minimum Experience: 1 year in data analytics
- Minimum Field of Expertise: General knowledge of database analysis, design and documentation techniques and tools.
Preferred Education: Bachelor's degree in Computer Science or Informatics
The hourly rate range for this position is $36.57 - $42.07. When extending an offer of employment, the University of Southern California considers factors such as (but not limited to) the scope and responsibilities of the position, the candidate’s work experience, education/training, key skills, internal peer equity, federal, state, and local laws, contractual stipulations, grant funding, as well as external market and organizational considerations.
Minimum Education: Bachelor's degree, Combined experience/education as substitute for minimum education Minimum Experience: 1 year Minimum Field of Expertise: General knowledge of database analysis, design and documentation techniques and tools.
Salary : $37 - $42