Data Warehouse Engineer Iii

Headquartered in Portland, Oregon, TEC has 30+ locations from Seattle to San Diego to the Midwest, serving thousands of customers across Washington, Oregon, California, Nevada, Arizona, Nebraska, Iowa and South Dakota.

TEC Equipment features Mack and Volvo heavy-duty trucks, Hino and Isuzu medium duty trucks, Wabash trailers and Cottrell auto transport trailers. We offer a large and desirable inventory of new Mack and Volvo heavy-duty trucks and all makes of used trucks. Our full-service line-up also features quality parts, state-of-the-art service, collision centers and fuel, leasing/rental, financing, and insurance. Our locations are authorized service centers for Mack, Volvo, Cummins, Meritor, Eaton and Fuller warranties. TEC truly offers the convenience of one-stop shopping for all trucking-related needs.

TEC Equipment has an opportunity for a Data Warehouse Engineer to help build out our enterprise Data Warehouse in Azure. This position needs to successfully interact with business stakeholders, product managers, and Power BI developers in order to envision, model and guide the build out of our data & analytics strategy. If you love taking data and turning it into insightful knowledge, this is the position for you!

The person in this position must embody Company values: Teamwork, Entrepreneurship, and Customer Focus and be committed to providing a high level of support to internal customers to better enable managers and employees to fulfill TEC Equipment’s Customer Commitment – to be recognized by customers as their Best Business Partner.

This is a hybrid position with two days per week required working from our corporate office.

• Help define and create a corporate business intelligence center of excellence
• Create, maintain, and improve performance of corporate Power BI models and data sources. This includes knowing when to recommend additional aggregation in OLAP cubes.
• Troubleshoot slow running reports
• Suggest solutions to overcome issues and solve future reporting initiatives
• Document and maintain a reporting catalog based on MDM standards that ensures data quality and governance
• Work directly with application developers, business analysts, SEO analysts and quality assurance personnel to deliver new Power BI models to stakeholders

• BS in Computer Science or related field or equivalent experience
• 5+ years of proven experience designing, developing and maintaining business intelligence solutions
• Experienced in Data Warehouse design (e.g. dimensional modeling), deployment and testing, including best practices
• Solid understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• 3+ years of proven experience with Azure Data Factory
• 5+ years working knowledge of Microsoft SQL Server in Azure (managed instance)
• 3+ years experience creating and maintaining ETL packages
• Experience porting on-prem SSIS packages to Azure Data Factory
• In-depth knowledge of Power BI, Tableau, or equivalent

Preferred Qualifications:

• Ability to create, modify and maintain T-SQL queries and stored procs and associated indexes and health checks
• Crafting and executing queries upon request for stakeholders
• Success presenting information through reports and visualization
• Strong attention to detail
• An understanding of Microsoft SQL Server Reporting Services (SSRS), Crystal Reports or similar reporting tools
• Experience with Azure DevOps and Agile development a plus
• Source control

TEC provides our employees and their families with a full menu of health, wellness, and retirement benefits.

New hires are eligible to participate in TEC Equipment’s comprehensive benefits plan the first of the month following your date of hire.

• Choice of two comprehensive medical plan options that include prescription drug coverage
• Choice of two dental plans that cover preventative and diagnostic care, basic and major services, and orthodontia for children
• Vision care, discounted hearing exams, and hearing aids
• 401(k) retirement savings plan with company contribution
• Life, accident, and disability insurance
• Employee Assistance Program (EAP)
• Education assistance
• Seven paid holidays, vacation accrual of at least 48 hours per year, and paid sick

All offers of employment are contingent upon successful completion of all applicable screenings.

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Pursuant to the San Francisco Fair Chance Ordinance and the Los Angeles Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

We do not accept unsolicited resumes from third-party recruiters. In addition, we are not seeking to expand our 3rd party partnerships at this time.

#ZR