Data Engineer Full-time Job

As a data engineer at Day & Ross, you will be a key team member leading us through our digital transformation.  Your primary role will be to design and build enterprise data sets and pipelines using modern tools that will be used to generate insights that fuel our business.  You will work closely with a team of IT and business professionals to ensure our enterprise data needs are understood and we have the right data & analytics solutions in place to support our needs.

 

How You’ll Help

• Gather, document, and communicate data requirements, specifications, and assumptions.
• Collaborate with data architects, scientists, analysts, and business consumers to prepare data models and Power BI data sets for a variety of uses ranging from operational reporting to more advanced data science solutions.
• Transform data into facts and dimensions using SQL.
• Validate and test data models for accuracy and performance.
• Troubleshoot and resolve data issues and anomalies.
• Provide data insights and recommendations to support business decisions.
• Design, build, test, & optimize data pipelines to support numerous business analytics initiatives and solutions.
• Design, build, test, & document data structures and models that are accurate, secure, timely, and can be trusted by the business.
• Propose & create innovative and automated processes to ensure data integrity, completeness, and accuracy.
• Educate & train other team members on the enterprise data assets available, how they have been constructed, and how they can be used.
• Participate in data governance activities to drive high data quality and standards and support data cleansing initiatives.
• Participate in agile ceremonies like daily stand ups, product demos, retrospectives.

 

Your Skills & Experience: 

• Bachelor’s or master’s degree in computer science or related education with at least six years of work experience in data management disciplines including data integration, modeling, & optimization.
• Strong experience in designing & building data warehousing, data lake, data ingestion, business intelligence, and analytics solutions.
• Strong experience building data acquisition & ingestion with a variety of patterns and techniques include batch, streaming, replication, API, etc. for structure and unstructured data.
• Hands on experience working with a variety data structures and formats including relational, star schema, columnar, JSON, Parquet, etc.
• Hands on experience delivering modern data & analytics platforms & technologies including  Snowflake, Power BI, Informatica, ETL tools.
• Knowledge and experience building and deploying advanced analytics models using ML Ops.
• Strong experience with modern data programming languages including SQL, NoSQL, PL/SQL.
• Familiar with data modeling tools and techniques.
• Experience developing in modern analytics programming languages include Python, R, Scala, and others.
• Working knowledge of modern BI platforms including Power BI.
• Curious about modern digital technologies and passionate about keeping skills & knowledge current with the industry.
• Confident self starter that can work in a team environment as well as independently.
• Works with a high sense of urgency to deliver maximum value.

 
If you’re chosen for the role, you’ll be asked to provide reference and criminal background checks before employment. You’ll only be contacted if you’re selected for an interview. 

From a single truckload of potatoes in the 1950s to a fleet of thousands, Day & Ross has grown to become one of the largest transportation and logistics providers in North America. With over 7,500 team members on and off the road in the US and Canada, we offer a diversified portfolio of freight and delivery solutions, including LTL, Truckload, Residential, Dedicated Fleet Solutions, and Logistics.
We believe our people are our greatest strength. For over a decade, weve been recognized as one of Canadas Best Managed Companies. Weve also been named a Top Company for Women to Work for in Transportation since 2018. Our recognition reflects the family values we share with our parent company, McCain Foods Limited.