Microsoft BI Developer at Transwest Inc

Chicago, Illinois, United States -

Full Time

Start Date

Immediate

Expiry Date

20 Mar, 26

Salary

70000.0

Posted On

21 Dec, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Microsoft BI Stack, T-SQL, Power BI, SSIS, SSRS, DAX, Data Modeling, Report Design, Communication Skills, Attention to Detail, ETL Processes, Data Visualization, Technical Documentation, Data Analysis, Collaboration, Complex Data Integrations

Industry

Transportation/Trucking/Railroad

Description

Description 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. Requirements 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

Responsibilities

The Microsoft BI Developer will design, build, and maintain automated ETL processes, reports, dashboards, and KPIs. They will collaborate with stakeholders to gather requirements and deliver high-impact analytics and solutions.