Job Information
Aston Carter Data Conversion Specialist in Nashville, Tennessee
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
(2 positions) 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
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 11, 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 (%20astoncarteraccommodation@astoncarter.com) for other accommodation options.