What are the responsibilities and job description for the DATA ENGINEER W2/FULLTIME position at S3 Staffing USA?
Job Details
Mid level Data Engineer
Type : W2/Full time
Work onsite at either location
- St. Louis, MO
- Mt. Sterling, IL
Update From the manager:
Datastage : main ETL tool (on IBM Cloud Pak (platform)). Future move to new ETL tool
Fivetran : Data replication tool.
DB2 : Current, switching to Snowflake soon.
Familiarity with
- OOP and scripting tools will be helpful.
- Cloud-based technology is helpful.
- concepts in logistics (transportation and warehousing) is a plus since this is DOT’s business.
Data Engineer - Mid (Snowflake/DB2, Python, DataStage, FiveTran)
Client | Dot Foods |
Work location | Onsite Work onsite at either location
Open to a person who will relocate to St. Louis and provide proof of relocation by the first day of work. Must pay for your own relocation |
Term | 6 month Contract to hire |
Work Status | |
Required
- 5 years SQL, data warehousing/analytics, data engineering
- Create/Maintain - machine learning/artificial intelligence data pipelines
- designing scalable data models like handling slowly changing dimensions (SCDs) and performance tuning.
- Cleanse/transform data
- ETL/ELT tools (IBM Cloud Pak, DataStage, Fivetran, Talend, or Informatica)
- Moving away from DataStage in the future (new tool not named)
- Required : DataStage
- Strongly Desired: Fivetran
- 2 years of Snowflake (Required)(Desired Snowflake Data Engineer Certification)
- 3 years Python OO programming (also would be useful Java, or C#)
- 2 years Azure (or similar Cloud with AWS, Google Cloud Platform)
- Bachelor’s degree in Business Analytics, Computer Science, Mathematics, Statistics, or related field
Desired
- IBM Cloud, DB2 (strongly desired), watsonX.ai, Supply Chain
- concepts in logistics (transportation and warehousing) is a plus since this is DOT’s business (distribution of Food)
Date | Candidate Name | C-Phone | C-Email | Data Engineer Years | Snowflake Years | Python Years | Datastage Years | C- Location | Rate W2 | Fee | Your email | |
12/4/25 | $.00 W2 | $5 |
Data Engineer - Mid Level
You’re analytical, a big picture thinker, and detail oriented. You’re a problem solver, and you’re able to present technical ideas to the business. You enjoy interacting with people and communicating across teams. If this sounds like you, Dot Foods wants you on our team.
As a Data Engineer, you will design, test, and maintain data pipelines for advanced analytics. You’ll transform complex datasets, ensuring alignment with strategic goals, and collaborate with IT and business experts to deliver crucial insights in adherence to information best practices.
WHAT YOU’LL DO
- Automate data wrangling from a wide variety of sources (flat files, remote servers, databases, legacy systems, message queues, APIs and more)
- Identify opportunities to improve system and business process efficiencies
- Cleanse/transform data in preparation for all levels of analytical use
- Leverage many technologies and methodologies as required—includes scripting and programming languages
- Assist in the preparation, deployment, and maintenance of machine learning/artificial intelligence data pipelines
- Work with vendors and consultants as appropriate.
- Assist with designing scalable data models for real-world applications, including handling slowly changing dimensions (SCDs) and performance tuning.
- Applies lean thinking and tools to identify and eliminate waste in all areas of the position
YOU MUST HAVE
- Bachelor’s degree in applicable field
- 5 years of experience in applied SQL development, data warehousing/analytics, and data engineering (or equivalent experience)
- Proven experience with ETL/ELT tools such as IBM Cloud Pak, DataStage, Fivetran, Talend, or Informatica
- 2 years of experience working with Snowflake
- Hands-on experience with the full software development lifecycle (SDLC)
- 2 years of experience in object-oriented programming using Python, Java, or C#.
- Strong interpersonal skills with professional verbal and written communication abilities
YOU MAY ALSO HAVE
- Bachelor’s degree in Business Analytics, Computer Science, Mathematics, Statistics, or related field
- Snowflake Data Engineer Certification
- Ability to work independently as well as within a team environment
- Effective project management and planning skills
ROLE SPECIFICS
- Travel – Occasional overnight travel 1-3 nights per quarter for company meetings. Must have ability to travel independently as needed, without restriction by all modes of transportation, including car, plane, or train.
- Schedule – ability to work flexible hours; may include evening & weekend hours as needed
About Dot Food
Dot Foods makes products more accessible and affordable to the food industry. We add efficiency to the supply chain and build strong partnerships with distributors, suppliers, and operators. Our company was created on a foundation of respect and dependability. People who are open to input, ask questions, embrace diversity, and seek innovative solutions thrive here.
WHAT DOT CAN OFFER YOU
As a family-owned and operated company since 1960, Dot Foods has created a strong family culture. We make everyone feel included and respected. In addition to an inclusive working environment, we will provide you with:
- Competitive compensation package, including bonuses for successful performance
- Extensive benefits including medical, dental, 401k, and profit-sharing
- Significant advancement opportunities
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Salary : $105,000 - $110,000