Database Analyst I

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.

USC is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or any other characteristic protected by law or USC policy. USC observes affirmative action obligations consistent with state and federal law. USC will consider for employment all qualified applicants with criminal records in a manner consistent with applicable laws and regulations, including the Los Angeles County Fair Chance Ordinance for employers and the Fair Chance Initiative for Hiring Ordinance, and with due consideration for patient and student safety. Please refer to the Background Screening Policy Appendix D for specific employment screen implications for the position for which you are applying. 

We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact USC Human Resources by phone at (213) 821-8100, or by email at uschr@usc.edu. Inquiries will be treated as confidential to the extent permitted by law.

• Notice of Non-discrimination
• Employment Equity
• Read USC’s Clery Act Annual Security Report
• USC is a smoke-free environment
• Digital Accessibility

If you are a current USC employee, please apply to this  USC job posting in Workday by copying and pasting this link into your browser: