AMS - Data Engineer III

Job Title:  Data Engineer III

Job Summary:
The Data Conversion Engineer will perform data profiling and analysis; write Extract, Transform, Load (ETL) scripts using SQL or other tools; and write data reports and provide recommendations for improving data for clients. 

Duties/Responsibilities:
•    Analyze data using SQL, SQL Server, and SSMS
•    Write data migration scripts using the tools listed above
•    Participate in Data Profiling, Data Issue Resolution and Data Mapping Workshops 
•    Document Data Maps and Script Designs 
•    Perform Quality Assurance on analyzed data, migrated data and developed scripts
•    Create tickets or reports exposing data issues
•    Analyze data issues to determine the best course of action for resolution
•    Work well in team environments, including interaction with the client, other vendors and third parties
•    Other duties as assigned

Required Skills/Abilities: 
•    Strong knowledge of SQL, relational databases, and data engineering
•    Able to create clean, well-designed code and systems
•    Able to learn new skills quickly and adjust to changing priorities
•    Able to manage time and priorities
•    Excellent verbal and written communication skills
•    Must work well in a team environment 
•    Excellent organizational skills and attention to detail
•    Strong analytical and problem-solving skills
•    Ability to function on fast-paced projects
•    Proficient with Microsoft Office Suite or related software

Preferred Experience:
•    SQL Server, SSMS, SSIS
•    Dashboard and reporting tools such as Tableau, PowerBI, or SSRS  
•    Snowflake, Redshift, Azure Data Warehouse
•    Python, Java, or similar programming languages 
•    DBeaver or TOAD
•    Oracle, PostgreSQL, or similar databases
•    AI and machine learning technologies
•    Pension and benefits data sets

Education and Experience:
•    Bachelor’s degree in information systems, Computer Science or related field strongly preferred along with demonstrated professional experience.
•    Must be a US citizen.
•    5+ years data engineering experience

Working Conditions:
The physical and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical Demands: 
•    While performing the duties of this job, the employee is required to walk, use hands to finger, handle objects, tools, or controls; reach with hands and arms; balance; stoop; bending or crouching; talk or hear. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus. 
•    Some lifting of files, opening cabinets. 
•    Bending or standing as necessary.

Work Environment: 
Position is sedentary with prolonged periods of standing, bending, sitting, kneeling.

This description is not intended to be, nor should it be construed as an all-inclusive list of responsibilities, skills or working conditions associated with the position. It is intended to accurately reflect the activities and requirements of the position, but duties may be added, deleted, or modified, as necessary. This description does not constitute a written or implied contract of employment.