Microsoft BI Developer

Are you a passionate BI Developer with a deep knowledge of the Microsoft BI stack? Join Transwest as we build the next generation of enterprise data solutions. You will work cross-functionally to deliver high-impact analytics, reports, data pipelines, and full end-to-end solutions that empower decision-makers across all departments and business units.

This is an on-site role based in Denver, Colorado.

WE OFFER A FULL BENEFITS PACKAGE FOR ELIGIBLE EMPLOYEES INCLUDING:

• Medical, Dental, and Vision Insurance
• Life (Voluntary and Employer Paid) and Disability Insurance
• 401(K) with company match beginning with your first contribution.
• HSA and/or FSA, as applicable
• Paid Time Off, Sick Time, and Company Paid Holidays
• Employee Car Discount Program

ESSENTIAL DUTIES & RESPONSIBILITIES:

• Design, build, and maintain automated ETL processes, reports, dashboards, and KPIs.
• Develop and optimize complex T-SQL queries and stored procedures.
• Build robust reporting solutions using Power BI, SSIS, and SSRS/RDL.
• Transform and model data for effective analytics and visualization.
• Collaborate with stakeholders to gather requirements and translate them into technical solutions.
• Analyze trends, anomalies, and patterns to support business decisions.
• Create and maintain up-to-date technical documentation.
• Estimate effort and deliver high-quality solutions on time.

WORK ENVIRONMENT & PHYSICAL ABILITIES:

• Requires frequent sitting for prolonged periods of time in an office setting.
• Requires eye-hand coordination and manual dexterity sufficient to operate a keyboard, photocopier, telephone, calculator, and other office equipment.
• Ability to communicate providing verbal feedback in a professional manner.
• Ability to receive and analyze data and input into the computer.
• Ability to lift up to 30 lbs.
• Normal range of hearing and vision.

REQUIRED EDUCATION, EXPERIENCE, KNOWLEDGE & SKILLS:

• Bachelor's degree in a related field or equivalent professional experience.
• Proficiency with the Microsoft BI Stack: T-SQL, Power BI, SSIS, and SSRS.
• Strong understanding of DAX, data modeling, and report design best practices.
• Excellent communication skills and attention to detail.
• Ability to work both independently and collaboratively in a cross-functional environment.
• Must pass a post-offer background check, physical, drug screening, and general abilities assessment.

PREFERRED QUALIFICATIONS:

• Familiarity with business functions across departments such as: Finance, Sales, Marketing, Operations, Supply Chain, and HR.
• Experience working with complex data integrations and large datasets.

JOB DETAILS:

• Type: Salary
• Compensation Range: $60,000 - $70,000
• Reports To: Director of Analytics and Engineering
• Closing Date: Open Until Filled