Database Analyst I
About The Position
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. The team is dedicated to making a difference through improving access to neuroscience research data. This full-time database analyst role with ETL/data mapping and data modeling experience will play a vital role in expanding informatics systems and facilitating research into a number of neurological diseases and disorders.
Requirements
- 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
- Effective verbal and written communication skills
- Good time management and organization skills with attention to detail
- 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
- 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.
Nice To Haves
- Experience with programming languages such as Java a plus
- Expertise in data harmonization a plus
- Preferred Education: Bachelor's degree in Computer Science or Informatics
Responsibilities
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Number of Employees
5,001-10,000 employees
