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. You

will be responsible for taking customer data from the previous vendor's

databases and migrating it into our database, ensuring data is as clean as

possible.

Additional Information

-Manager's team handles the law enforcement side of this project. Manager's team is taking data from their vendors databases and migrating it into the Client

database. Manger's needs someone that has analytical/problem solving abilities to migrate the data and clean it up as much as possible

- pull data and migrate it into the right areas, doing analysis to ensure it is migrated correctly, manage scripts.

- SQL,SQL database management, database administration, QA testing, managing scripts, data conversion

- 5+years of relevant experience

-Bachelor's or associate's preferred, but can also consider someone with technical school experience and work experience

-Technical schooling or certifications can be considered as well

-Looking for a go-getter and someone who is excited about this opportunity. Open to someone more green if they have these soft skills

Responsibilities

• Understand and implement ETL processes.
• 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, 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 in setting up Windows scheduled tasks.
• Create SQL Queries and test cases to validate post conversion data.

Essential Skills

• Excellent verbal and written communication.
• Excellent time management skills.
• Experience in a client-facing role.
• Experience in stakeholder management.
• Experience 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.
• Minimum of two years of experience with SQL.

Additional Skills & Qualifications

• Bachelor’s or Associate's degree in Information Technology or related field, or equivalent experience.
• Technical schooling/Certifications can be considered as well.
• Experience in County/municipal Government software operations and processes a plus.
• 5 years of relevant work experience.

Work Environment

100% remote - will need to be open to traveling to Temple, GA for around 2 weeks of training

Pay and Benefits

The pay range for this position is $38.46 - $38.46/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:

• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a fully remote position.

Application Deadline

This position is anticipated to close on Apr 4, 2025.

About Aston Carter:

Aston Carter provides world-class corporate talent solutions to thousands of clients across the globe. Specialized in accounting, finance, human resources, talent acquisition, procurement, supply chain and select administrative professions, we extend the capabilities of industry-leading companies. We draw on our deep recruiting expertise and expansive network to meet the evolving needs of our clients and talent community with agility and excellence. With offices across the U.S., Canada, Asia Pacific and Europe, Aston Carter serves many of the Fortune 500. We are proud to be a ClearlyRated Best of Staffing® double diamond winner for both client and talent service.

Diversity, Equity & Inclusion

At Aston Carter, diversity and inclusion are a bridge towards the equity and success of our people. DE&I are embedded into our culture through:

• Hiring diverse talent
• Maintaining an inclusive environment through persistent self-reflection
• Building a culture of care, engagement, and recognition with clear outcomes
• Ensuring growth opportunities for our people

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email astoncarteraccommodation@astoncarter.com for other accommodation options.