Analyst - Data Integration, Kroll Government Solutions
Diamond Bar, CA, United States
Full Time Entry-level / Junior USD 50K - 90K
Kroll
As the leading independent provider of risk and financial advisory solutions, Kroll leverages our unique insights, data and technology to help clients stay ahead of complex demands. Click for more details.We are looking for an Analyst, Data Integration.
Note: This position will be hybrid.
Day-to-day responsibilities:
Essential duties and responsibilities include the following. Other duties may be assigned.
- Ability to examine and determine various data set file formats, data field separation mechanism, and database import approaches.
- Support multiple audit projects with designing and developing Extract Transform and Load (ETL) routines to load raw data into Oracle Database Server.
- Program data import, data analysis, data export, and reporting applications with Microsoft Access Database and/or other software tools.
- Proficiency with Structure Query Language (SQL) syntax and operation.
- Execute system production programs based on audit types and requirements
- Work with senior developer to prepare the input data sets for systematic processing and reporting.
- Demonstrate skills and knowledge of relational database management system, e.g. Microsoft Access Database, Oracle Database Server, and others.
- Ability to prepare data flow diagram and data mapping documentation.
- Work continuously to improve efficiency and repeatability of processes and procedures.
Essential traits:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
Education and Experience –
- Bachelor’s Degree (BS/BA) in Computer Science or Business Information System Management is preferred.
- More than one year experiences working in a professional Oracle Database Server development environment.
Computer/Software Skills and Abilities –
- 3+ years working with Microsoft Windows Operating System.
- 1+ years programming relational database server technology, SQL, PL/SQL, SQL*Loader, SQL-Developer.
- 1+ years programming Microsoft Access Database Management System, Microsoft SQL Server, or other data integration tools.
- 1+ years of importing/exporting and manipulating relational data in modern relational database management system.
- Experience with Python a plus.
- Experience with Linux a plus.
- Strong work ethic
Other Skills and Abilities –
- Exceptional problem solver
- Ability to communicate professionally and clearly with requestors and fellow team members.
- Ability to plan tasks in a logical and achievable manner.
- Ability to summarize, conclude, and report on analytical results in both tabular and graphical formats.
About Kroll
Join the global leader in risk and financial advisory solutions—Kroll. With a nearly century-long legacy, we blend trusted expertise with cutting-edge technology to navigate and redefine industry complexities. As a part of One Team, One Kroll, you'll contribute to a collaborative and empowering environment, propelling your career to new heights. Ready to build, protect, restore and maximize our clients’ value? Your journey begins with Kroll.
In order to be considered for a position, you must formally apply via careers.kroll.com.
Kroll is committed to creating an inclusive work environment. We are proud to be an equal opportunity employer and will consider all qualified applicants regardless of gender, gender identity, race, religion, color, nationality, ethnic origin, sexual orientation, marital status, veteran status, age or disability.
The California salary range for this position is $50,000 - $90,000 USD
#LI-SS1
Tags: Computer Science Data analysis ETL Linux Oracle Python RDBMS SQL
Perks/benefits: Career development
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.