What are the responsibilities and job description for the Data Conversion Engineer position at i3 Verticals?
JOB TITLE: Data Conversion Engineer
DEPARTMENT: JusticeTech
REPORTS TO: Associate Director, Implementations
JOB LOCATION: Remote
TRAVEL: Up to 20%
SUMMARY OF POSITION:
The ideal candidate will have knowledge in ETL processes, SQL queries, and data integration, combined with strong scripting and reporting skills. This role focuses on extracting, transforming, and loading (ETL) data from various sources, and creating custom reports to meet client-specific requirements.
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