JOB TITLE: Data Conversion Engineer
FLSA STATUS: Exempt
DEPARTMENT: JusticeTech
REPORTS TO: Associate Director of Implementations
SUPERVISORY RESPONSIBILITIES: No
JOB LOCATION: Remote - LA
TRAVEL: 20%
ESSENTIAL DUTIES & RESPONSIBILITIES:
- Knowledge of ETL processes.
- Understanding how to extract data from various sources, transform it to meet business needs, and load it into target systems.
- Work with a variety of database and file formats, including SQL Server, dBase, Advantage, Excel, and text files.
- Develop and execute SELECT, UPDATE, INSERT, DELETE, and ALTER queries and stored procedures for data cleansing and transformations.
- Utilize SSIS for importing and managing data in test, development, and production environments.
- Familiarity with core SSIS components such as
- Control and Data Flow tasks
- OLEDB and Flat File Sources
- OLEDB Destinations
- Derived Column, Data Conversion, Sort, and Lookup tasks
- Parameters
- Use Crystal Reports and Visual Studio to customize reports tailored to specific requirements.
- Work with VB, SQL, XML, and JSON to create and modify import scripts.
- Analytical and detail-oriented, ability to identify patterns and trends, and ensure accuracy and consistency.
- Experience setting up Windows scheduled tasks.
- Create SQL Queries and test cases to validate post conversion data.
MINIMUM QUALIFICATIONS (EDUCATION AND EXPERIENCE):
- Excellent verbal and written communication
- Excellent time management skills
- Experience in a client-facing role
- Experience in stakeholder management
- Experience of working in a diverse and challenging environment
- Ability to determine estimates of effort and impacts on a variety of solutions
- Ability to manage rapid change in a fast-paced environment
- Ability to manage deliverables and provide support to multiple projects
- Data Conversion experience
- Knowledge of Microsoft Windows applications
- Developed analytical and problem-solving skills
- Meticulous attention to detail
- Experience in testing and validation of output data including reports
- Must have a minimum of two years of experience with SQL
PREFERRED QUALIFICATIONS (EDUCATION AND EXPERIENCE):
- Bachelor’s degree in Information Technology or related field, or equivalent experience
- Experience in County/municipal Government software operations and processes a plus
Required
-
Data Conversion Experience
Required
Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
