What are the responsibilities and job description for the Data Conversion Engineer position at i3-Milestone?
Job Details
Description
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
Description
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.
- 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
- Bachelor’s degree in Information Technology or related field, or equivalent experience
- Experience in County/municipal Government software operations and processes a plus