Analytics Engineer

Information Technology (Technologies de l'information) Chicago, IL


Description

Who We Are:
When you join Traffic Tech, you join a team that keeps the global economy moving – literally.
Traffic Tech is recognized as an industry leader and the logistics partner to many highly recognizable international brands. With 50 offices throughout the United States, Canada, Mexico, and China, the company offers progressive and efficient solutions for moving freight by land, sea, and air.
 
Our platform, corporate culture, and "hardest working Team in transport" have made us an industry leader. We believe that inspiring our employees and giving them opportunities for growth translates into better service for our clients. Each and every Traffic Tech employee is personally invested in ensuring our clients receive the most innovative, efficient, and cost-effective solutions available.
ANALYTICS ENGINEER
What the Job Entails:
 
  • Work with internal customers to understand their data needs, and translate into technical requirements;
  • Develop and maintain data pipelines to extract or ingest new data sources to a data warehouse, using Data Vault methodology;
  • Build and maintain PBI semantic models that centralize business logic and simplify reporting;
  • Monitor the availability and integrity of the data warehouse, and address accordingly;
  • Identify opportunities to improve data quality;
  • Contribute to and enforce internal development standards.
 
What We Are Looking For:
 
  • 7+ years of experience in a data analytics or data engineering role; 
  • Experience with SQL; 
  • Experience with dbt; 
  • Experience with DAX  
  • Experience with PBI semantic models; 
  • Experience with dimensional modeling (Kimball); 
  • Experience with Git; 
  • Actively stays up to date with latest technologies; 
  • Leverages AI tools to increase productivity; 
  • Clear and concise communication skills. 

Bonus:

  • Familiarity with or interest in Data Vault 2.0 methodology; 
  • Experience with Cloud SQL platforms (Databricks, Snowflake, …) 
  • Experience with cloud technologies (Azure, AWS, GCP); 
  • Experience with PBI report building; 
  • Knowledge of transportation and/or logistics. 
 
What We Offer:
  • Full Benefit options, including Medical (Dental & Vision)
  • Life/AD&D Insurance, Long-term Disability
  • 401(k) matching
  • Personal and volunteer days off
  • Dynamic environment and ‘can-do’ culture
 
This is a full-time in-office permanent position from Monday to Friday.
 
 
 
 
 
#LI-JC1