Analytics Engineer

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 offices throughout the United States, Canada, Mexico, Europe and China, the company offers progressive & efficient solutions for moving freight by land, sea, and air. Your Part in It:We are looking for an Analytics Engineer, excited to work with data to help provide the company with impactful tools to support decision-making across the company. We are looking for dynamic and creative people eager to learn every day and make a difference! As an Analytics Engineer, you will be part of the central team that builds a data platform to make it easy for the data consumers in the company (self-service BI, financial & operational reporting, analytics, reverse ETL) to have access to the data that they need. You will be part of a small team of 3, so you will have exposure to all aspects of data engineering tasks, but with a focus on analytics engineering. You should strive to implement best practices to build a modern, scalable data platform. 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:

• Robust industry with training and mentorship
• Compensation package that include Medical and Dental benefits
• Life Insurance/AD&D Insurance
• Long-term disability
• Personal and Volunteer days off
• Vacation available after probation period
• Free parking, full-service bistro, gym, and free coffee all day
• Dynamic environment and ‘can-do' culture

This is a full-time permanent position from Monday to Friday. Traffic Tech is committed to fostering a healthy and accessible work environment. Although the above job description may address the male pronoun, Traffic Tech is inclusive and respectful to all male, female and non-binary applicants. Traffic Tech prohibits discrimination based on someone's disability in all aspects of the employment relationship. This includes job applications, recruitment, training, transfers, promotions, apprenticeship terms, dismissal, layoffs and situations where an employee returns to work after a disability-related absence. Accommodations are available upon request. Traffic Tech is an equal opportunity employer that is committed to Diversity, Equity, and Inclusion. We take affirmative action to ensure we provide equal employment opportunity for all applicants and employees, and do not discriminate on the basis of race, ancestry, national or ethnic origin, citizenship, color, religion, sex, sexual orientation, gender identity or expression, age, marital status, family status, mental or physical disability, or any other legally protected characteristics.