Data Engineer at Thompson Machinery
La Vergne, TN
About the Job
Job Description: Data Engineer
Location: On-site in Lavergne, Tennessee.
We are seeking a highly skilled Data Engineer to join our dynamic and innovative team. Your expertise in SSIS, SQL programming, and scripting will be crucial in developing our data integration pipelines, ensuring data accuracy, and supporting various data-driven initiatives within our organization. The Data Engineer will work with internal teams and external organizations to move data reliably, quickly, and securely among internal and external systems to help the company achieve its vision “To be the best Cat dealer, Period.”
Essential Duties and Responsibilities
- Design, develop, and maintain scripts and SQL Server Integration Services (SSIS) packages to efficiently move data sets among internal and external systems.
- Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications.
- Where necessary, create and optimize complex SQL queries, stored procedures, and functions.
- Implement data cleansing, transformation, and validation rules when needed to ensure the accuracy and consistency of data.
- Develop and maintain documentation of integration processes.
- Monitor, troubleshoot, and optimize the performance of integration processes to ensure efficient and reliable operation.
- Stay current with industry trends and best practices and recommend new methods and technologies to improve the organization’s integration processes.
- Strong understanding of the SQL language beyond simple SELECT, UPDATE, and INSERT. Ability to create tables, views, schema, stored procedures, and dynamic SQL.
- Experience in calling REST APIs to retrieve and post data – especially with JSON.
- Experience using FTP, SFTP, and SSH to send and receive data.
- In-depth knowledge of Microsoft SQL Server Integration Services (SSIS) and experience in designing and developing database load/update processes.
- Excellent communication and collaboration skills, with the ability to work effectively in a team environment. Ability and desire to share knowledge, approaches, and experience with team members.
- Ability to work on multiple projects simultaneously and meet deadlines.
Required Qualifications
- Minimum of 2 years of experience designing integration pipelines leveraging SSIS, scripting languages (e.g., Python, Powershell, etc.), and other tools. Experience developing integration jobs with SSH or FTP/SFTP critical.
- Bachelor’s degree in Computer Science, Information Systems, or a related field or equivalent professional experience.
- Experience with SQL Server Integration Services (SSIS).
- Working knowledge of at least one scripting language, such as PowerShell, Python, etc.
Preferred knowledge, skills, or abilities:
- Experience with Kingswaysoft tools is a plus.
- Knowledge of at least one RPA tool desired (e.g., Microsoft Power Automate, Automation Anywhere, UiPath, etc.). Microsoft Power Automate is preferred.
- Experience with Microsoft Dataverse desired
Safety
- Must have the physical ability to wear Personal Protective Equipment (PPE), including protective glasses, protective gloves, and protective clothing and footwear as required by the job.
- ·Know and follow all Company and customer safety rules, including maintaining a safe, clean, and orderly work area, fully participating in Company accident prevention and safety improvement activities.·
Customer Satisfaction
- Respond to all customer requests in a professional and courteous, timely and responsive manner.
- Maintain a clean, professional personal appearance always, meeting all Company standards for professionalism.
- Keep the Manager continually apprised to assist in answering customer questions and problems when necessary.
Business
- Supports the organization’s mission, vision and values by exhibiting the following behaviors: honesty, integrity, and respect while delivering high quality solutions and maintaining a positive attitude and a safe work environment.
- Accepts responsibility for mistakes or problems. Maintains “ownership” of assigned tasks.
- Demonstrate a positive attitude and a high level of personal credibility and integrity with customers, management, and dealership co-workers.
- Must be dependable. Consistently arrives at work on time when scheduled, fully ready to work.
- Maintain company and product confidentiality.
- Attend and participate in all meetings, training, and activities as required.
- Adhere to all Company policies and departmental procedures and rules.
- All other duties as assigned.
Work Conditions
- Maintain a clean, safe working environment.
- Communicate effectively, verbally and in writing.
- Must be honest, reliable, and dependable, and display a positive attitude.
- Must be able to work well under occasional pressure or within work standards and deadlines.
- Must be able to work independently and/or with others in a team environment.
- Able to work standard five-day schedule, including daily overtime and occasional weekend hours as needed.
- Meet all eligibility requirements to drive Company vehicles, including a current, valid driver's license issued by the resident State, and maintain current motor vehicle liability insurance.
Physical Requirements
- Pass pre-employment background check, physical exam including drug screen, and meet all physical requirements for the position.
- Able to lift 20-50 pounds occasionally.
Enjoy a competitive benefit package as all our employees do:
- Medical, Dental, and Vision Coverage – (Company paid benefits option is available)
- Flexible Spending Account – Medical and Dependent Care
- 401K Plan with Company Match
- Company Paid Basic Life Insurance, and Voluntary Life Insurance Options
- Paid Holidays and Generous Paid Time Off Schedule
- Wellness Resources and More!
- Benefits begin the 1st day of the following month after your hire date.
About the Company:
Thompson Machinery is a Caterpillar equipment dealer serving the middle and west Tennessee and northern Mississippi region. Since 1944, Thompson Machinery has been an industry leader, renowned for superior solutions, lasting relationships, and stronger communities. Serving a broad range of customers in the construction, forestry, mining, industrial, governmental, and agricultural industries, as well as trucking, power generation, and marine businesses, Thompson Machinery is a total equipment solution provider. Thompson Machinery offers competitive salaries and a complete benefits package including Matching 401K, profit sharing plan, employee paid benefits option and more.
Thompson Machinery is an equal opportunity employer: Minorities/Women/Veterans/Disabled.