Description

DAT Software & Analytics is seeking a Data Engineer to join our Data and Engineering team in Beaverton, Oregon.

DAT’s industry dominant network of carriers, brokers and shippers makes our data an immensely valuable asset to the industry. 

The range of responsibilities of the Data Engineer are broad and range from traditional ETL & SQL solutions to building cloud infrastructure and serverless data processing solutions (e.g. AWS Lambdas) for sophisticated machine learning models. In this role you will be part of a supportive, collaborative, and diverse team responsible for exploring, making recommendations, and implementing enterprise data solutions primarily in our snowflake data warehouse.

What You’ll Do

• Working closely with product teams and data scientists to determine how to capture, persist, and maintain data
• Building distributed, scalable, and reliable data pipelines that ingest and process data at scale with ever diminishing time processing windows
• Leverage AWS to deliver efficient, cloud-native solutions
• Identifying opportunities in our data landscape where we need data enrichment
• Identifying and make recommendations on data storage solutions using alternate  technologies
• Analyzing  and recommending alternate persistence solutions 
• Serving as a resource for the Data Sciences team by partnering with them to make production quality and supportable solutions 
• Gathering requirements from analysts and the larger business community to optimize, unify, and simplify data according to business needs
• Working either independently on projects or in collaborative teams depending upon the needs of the effort

The Skills You’ll Need

• Exceptional ELT/ETL background with data transformation and operational experience  
• Strong SQL Proficiency with Snowflake including analytic queries and other complex use cases
• Experience with SQL Query Tuning, data investigation, and optimization
• Experience with Snowflake cloud data warehouse administration. 
• Experience modeling star schemas and other summary objects based on business requirements
• Experience building large data stores, modern data warehouse, or advanced data processing solutions
• Experience with AWS tools and infrastructure.  Particularly in regards to s3 storage, data pipelines, and serverless AWS compute services (e.g. Lambdas)
• Deployment pipeline and infrastructure as code and deployment pipeline experience on a cloud platform such as AWS

Bonus Skills

• Understanding of Oracle, SQL Server, Mongo and other database systems
• Scripting experience with Powershell and Python
• Experience with WhereScape RED ELT Software
• Understanding of modern data warehouse architectures such as data vault

About DAT

DAT Software and Analytics is a next-generation SaaS technology company that has been at the leading edge of innovation in transportation supply chain logistics for 43 years. We continue to transform the industry year over year, by deploying a suite of software solutions to millions of customers every day - customers who depend on DAT for the most relevant data and most accurate insights to help them make smarter business decisions and run their companies more profitably. We operate the largest marketplace of its kind in North America, with 226 million freight posts in 2020, and a database of $110 billion of annual global shipment market transaction data. DAT is based in Beaverton, OR, with offices in Colorado, Missouri, Texas, and Bangalore, India.

For additional information, see www.DAT.com/company

DAT Software and Analytics embraces the value of a diverse workforce, and believes it is a core strength of our company that we encourage those values in every DAT employee, at every level of our organization, regardless of tenure or rank. We provide equal employment opportunities (EEO) to all employees and applicants without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state, and local laws.

DAT Software and Analytics offers competitive compensation and an excellent benefit package that includes medical, dental, and vision coverage, flexible savings accounts, 401K, Life and AD&D insurance, a comprehensive Paid Leave program, and a Tuition Reimbursement program.

All referrals and résumés are managed exclusively through the Human Resources Department.

DAT Software and Analytics will not consider unsolicited résumés from vendors including search firms, fee-based referral services, and/or recruitment agencies.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)