Data Conversion Specialist

Job Description

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.

Additional Information

• Experience working with financial data or working with financial data conversions
  • Financial/accounting background would be preferred – accounting principles, debits/credits, transactions, etc.
• Strong experience in SQL, Oracle is another system that is preferred
• Ability to write scripts
• Some experience with programming or developing
• Very analytically minded – strong problem-solving skills
  • A lot of the data they work with does not have much information tied to it. This person needs to be able to problem solve on understanding the data and its source before being able to convert it. The more systems they have experience in, the easier the transition will be.

Manager's team requires candidates who have experience writing scripts from scratch. Some developer/programmer experience will be helpful (we

do not want a full blown programmer or developer

- just someone that has experience in this area). Manager also is looking for someone that has a good understanding of financial/accounting principles since his team works a lot with financials.

-Knowledge in ETL processes

-Minimum of 5 years experience with SQL

-Experience writing scripts from scratch

-Understanding of accounting principles such as debits and credits or experience in data conversion from a financial or accounting industry

-Experience within the justice industry preferred but not required

- Data integration and conversion

-Strong reporting skills

- Some programming or developer experience is highly preferred

Responsibilities

• Knowledge of ETL processes.
• Ability to write conversion scripts with an understanding of accounting/financial principles.
• Some programming or developer experience is highly preferred.
• 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, and 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.
• Set up Windows scheduled tasks.
• Create SQL Queries and test cases to validate post-conversion data.

Essential Skills

• Ability to write conversion scripts with an understanding of accounting/financial principles.
• 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.

Additional Skills & Qualifications

• Bachelor’s degree in Information Technology, Accounting/Finance/Economics or related field, or equivalent experience.
• Experience in County/municipal Government software operations and processes is a plus.
• Minimum of 5 years experience with SQL.
• Experience writing scripts from scratch.
• Understanding of accounting principles such as debits and credits or experience in data conversion from a financial or accounting industry.
• Experience within the justice industry preferred but not required.

Work Environment

100% remote