Senior Business Intelligence Developer

Trans Lease, Inc.; Denver (CO); On-site; USD 115,000 - 150,000; Full time

Benefits offered by this job

Medical, Dental, and Vision Insurance

Life and Disability Insurance

401(K) with company match

Paid Time Off and Sick Time

Employee Car Discount Program

Job summary

A leading technology firm is seeking a passionate BI Developer in Denver, Colorado. This full-time position involves designing automated ETL processes, optimizing complex T-SQL queries, and creating impactful reporting solutions. Candidates should have a bachelor's degree or equivalent experience, along with proficiency in Microsoft BI tools. Full benefits are included with the role.

Qualifications

• Proficiency with the Microsoft BI Stack and T-SQL.
• Bachelor's degree or equivalent experience is required.
• Experience with data modeling and report design best practices.

Responsibilities

• Design, build, and maintain automated ETL processes.
• Develop and optimize T-SQL queries and stored procedures.
• Build reporting solutions using Power BI and SSIS.

Skills

Proficiency with Microsoft BI Stack: T-SQL, Power BI, SSIS, and SSRS

Strong understanding of DAX, data modeling

Excellent communication skills

Attention to detail

Education

Bachelor's degree in a related field or equivalent professional experience

Tools

Power BI

T-SQL

SSIS

SSRS

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by Trans Lease, Inc.. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$115,000.00/yr - $150,000.00/yr

Direct message the job poster from Trans Lease, Inc.

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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Science

Referrals increase your chances of interviewing at Trans Lease, Inc. by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Get notified when a new job is posted.

Sign in to set job alerts for “Business Intelligence Developer” roles.

Denver, CO $100,000.00-$120,000.00 3 days ago

Senior Analyst, Business and Market Intelligence

Denver, CO $90,000.00-$120,000.00 3 weeks ago

Senior Data Analyst – Operations & Supply Chain

Aurora, CO $100,300.00-$187,300.00 3 days ago

C++ Staff / Sr. Staff Software Engineer ADS - Boulder, CO

Boulder, CO $93,000.00-$137,000.00 1 week ago

Business Intelligence Developer/Architect

Denver, CO $92,003.00-$129,954.50 2 days ago

Lone Tree, CO $82,039.00-$112,803.00 4 days ago

Westminster, CO $110,000.00-$130,000.00 3 hours ago

Denver, CO $138,000.00-$208,000.00 3 days ago

Greenwood Village, CO $105,000.00-$115,000.00 3 months ago

Senior Business Intelligence Engineer New (Remote)

Senior Business Intelligence Engineer, GCID (Global Capacity & Infrastructure Development)

Remote SQL Database developer and SQL Server administrator

Broomfield, CO $120,000.00-$130,000.00 4 days ago

Entry Level Data Analyst, application via RippleMatch

Broomfield, CO $77,618.50-$97,023.13 1 week ago

Data Analyst, Revenue Strategy & Operations

Denver, CO $130,000.00-$180,000.00 47 minutes ago

Full Stack Developer (C# / .Net / JS / SQL / AWS)

Data Analyst Intern, application via RippleMatch

Junior Data Analyst, Revenue Strategy & Operations

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.