Design, build, and maintain the company data warehouse and ETL processes. Partner with business teams to define data solutions and visualizations, support reporting (SSRS, Crystal Reports) and BI (Power BI/Tableau), troubleshoot issues, and provide occasional after-hours support.
Job Summary & Responsibilities
Compensation & BenefitsWe offer a competitive benefits package that includes health, dental, and vision insurance, life and disability, paid holidays, time off, retirement savings plan participation, and additional employee programs.
Salary: $100,000 - $115,000 annually + MyShare Equity Program
Hybrid: Onsite 0-1 days per week in Romeoville, depending on business needs.
Job Purpose: As a Data Engineer your focus will be involved with the engineering and maintenance of RJW's data warehouse environment. Your goals are to make the company more efficient and provide better customer service through connecting the business and technology teams.
The Data Engineer maintains smooth communications between business-critical systems and ensuring easy transitions when changes or maintenance are required. Daily activities will include partnering with the business to determine data solutions, effective methods of data visualization, and executing the plan to create results.
Essential Duties and Responsibilities: Must be able to prioritize multiple projects, while meeting deadlines and quality expectations
Must be able to adapt quickly in a changing environment
Has strong interpersonal communication skills working with both internal and external customers
Ability to relate or explain technical information to non-industry personnel
Adept at working with cross-functional IT teams to meet customer objectives
Qualifications: Bachelor's Degree or equivalent experience in Information Systems, Information Technology, Computer Science, Informatics, or a related technology field
3+ years experience with SQL & ETL development
3+ years experience in data warehouse environments.
3+ years experiencereporting tools including SSRS and Crystal Reports
3+ years experience with BI tools such as Power BI or Tableau Respond quickly to identify and resolve issues Proven critical and analytical thinking skills
Excellent verbal and written communication skills
High level of professionalism
Motivated and results driven attitude
Some after-hours support depending on business requirements
Experience with the following will be viewed as a plusTransportation Management Systems Warehouse Management Systems Both SQL Server and Oracle Data Democratization
Language Skills Sets: Must be able to communicate, read, write, and speak English.
Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.
Ability to write reports, business correspondence, and procedure manuals.
Ability to effectively present information and respond to questions from groups of managers, clients, and customers.
Physical Requirements: Must be able to occasionally lift and/or move up to 50 pounds.
Must be able to activate phone systems utilizing keyboards and buttons.
Must be articulate and comfortable speaking in front of others.
Regularly work in an indoor/office environment and required to sit and/or use repetitive hand motion.Frequently required to talk, hear, stand and walk.
Must be able to work in excess of continuous 8 hours when required.
Must be able to work under stressful situations, have good cognitive skills, maintain work accuracy, and the ability to concentrate on more than one task at a time.
Must have the ability to read and discern visual images on a variety of media with 20/20 corrected vision.
Must hear speech out of both ears in the normal range of 30db at 500 to 2000 Hz range.
Must be able to speak and communicate clearly over telephones.
Must be in sound physical health as determined by a certified licensed physician with no evidence of the use of controlled substances.
The preceding statements are illustrative of the functions of the job and RJW retains the right to modify or change the duties or essential functions of the job at any time.
As with all positions, the duties and responsibilities are subject to change at any time as needs arise and at the discretion of the RJW Transport, Inc. The Company has the right to revise this job description at any time.
Work Environment: While performing the duties of this job, the employee is occasionally exposed to moving mechanical parts, and fumes or airborne particles. The noise level in the work environment will range from quiet to moderately loud.
Employer Rights: This job description is intended to provide general information about the Data Engineer position. The above does not constitute an exhaustive list of the job duties to be performed by an associate holding the position of Data Engineer, nor are the lists of the physical requirements and environmental conditions exhaustive. You may be asked by your supervisor or managers to perform other duties. Your performance will be evaluated in part based upon your performance of the job duties listed in this job description, as well as any job duties not specifically listed above that you may be asked from time to time to perform.
As with all positions, the duties and responsibilities are subject to change at any time as needs arise and at the discretion of the RJW Transport, Inc. The Company has the right to revise this job description at any time.
Employment-At-Will: It is the Company's policy that all associates, other than those covered by a written individual employment or labor agreement with the Company that has been authorized in writing by the Company's Chief Executive Officer or Board of Directors, are not employed for any fixed term and are employed at the will of the Company for an indefinite period.
Just as our associate's, reserve the right to resign their employment at any time for any reason the Company reserves its right to terminate an associate any time for any reason either with or without cause.
Neither this Job Description nor any of its individual terms constitutes commitments between the Company and its associates as to the terms, conditions or duration of employment, nor does it modify the prevailing Employment-At-Will relationship.
Benefits:
401(k) matching
Medical/Dental/Vision insurance
Employee discount
Flexible spending account
Health savings account
Paid time off
Sick Days
Long-term Disability Insurance
Short-term Disability Insurance
Accidental Insurance
Critical Illness Insurance
MyShare program
RJW Logistics Group Woodridge, Illinois, USA Office
Woodridge, IL, United States, 60517
Similar Jobs
.png){kind=avatar}
Fintech • Machine Learning • Software • Financial Services
Design, build, and operate big-data and streaming platforms (Kafka, Hadoop, Dremio). Develop, deploy, and monitor data pipelines using Java, Python, Spark/Flink; collaborate on data modeling and ingestion, ensure data integrity and availability, act as a Big Data SME, and perform root-cause analysis.
Top Skills:
Alert ManagerAlertaBashDatabricksDockerDremioFlinkGrafanaHadoopHdfsIcebergJavaKafkaKubernetesOpsgeniePrometheusPythonS3SparkSQL
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
Develop and maintain Python data pipelines to build business data objects. Implement source-to-target mappings as code, build and deploy CI/CD pipelines, perform unit and integration testing, resolve complex technical issues, ensure software quality, and collaborate across functions to support applications and new program development.
Top Skills:
Aws LambdaAzure DevopsClaude CodeCloudFormationCloudwatchDynamoEventbridgeFargateGenai Developer ToolsGitGithub ActionsGithub CopilotIamJenkinsKinesisPythonRdsS3SagemakerSnowflake
Artificial Intelligence • Fintech • Machine Learning • Mobile • Payments • Retail • Software
Own and modernize Upside s analytics data platform: migrate pipelines, reduce cost, improve governance, design reusable modeling/orchestration patterns, deliver domain-critical data products, lead cross-functional initiatives, mentor engineers, and support ML and product teams.
Top Skills:
AWSCi/CdDagsterDatabricksDbtSnowflakeTerraform
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
