Database Analyst I

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.