database analyst
Role details
Job location
Tech stack
Job description
- 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
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
- 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, * 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.