Demo

Jr Business Intelligence Analyst

Temperature Equipment Corporation
Lansing, IL Full Time
POSTED ON 1/10/2025
AVAILABLE BEFORE 4/11/2025

Job Description

Jr. Business Intelligence Analyst

Temperature Equipment Corporation (TEC), a WATSCO (WSO) Company, has been an industry leader known for technical expertise, value, best-in-class product availability, and driving customer loyalty for nearly 90 years and counting. TEC is also the Midwestern state's largest distributor of air conditioning, heating, and refrigerant equipment, related parts, and supplies. We offer exceptional compensation packages; full benefits include health, dental, life, and AD D insurance, paid holidays vacation, and 401(k) with company matching.

Job Description

Under the direction of the Director of Information Technology, the Business Intelligence Analyst will work alongside the Programmer Analyst to ramp up the evolution of modern business intelligence tools at TEC. This position will be required to learn the ERP database schema, write complex queries, views, and stored procedures, and have the ability to validate result sets to ensure quality and accuracy. This position will be tasked with building reports and dashboards for multiple business units. We desire a candidate with experience in any programming or scripting language (PHP, PowerShell, C#, etc.), an analytical mindset, andthe drive to take theinitiative to learn and grow their knowledge base.

Essential Duties and Responsibilities

  • Collaborate with business users and subject matter experts to establish a vision for providing BI solutions.
  • Translate business intelligence requirements into technical specifications
  • Utilize MSSQL and other database tools (including but not limited to Oracle EPM) to build and modify meaningful reports and dashboards for business units
  • Perform SQL queries - design, code, test, and aggregate the results to create useful information
  • Build aggregated data marts to provide data models and visualizations for Power BI
  • Write technical documentations.

Qualifications

Required

  • Associate degree and / or 4 years of related experience
  • Business analysis skills
  • RDBMS (Relational Database Management system) experience
  • Previous experience with learning database schemas
  • Ability to write intermediate / advanced queries using T-SQL
  • Understanding of data warehousing and ETL processes
  • Excellent verbal and written communication skills
  • Preferred

  • Power BI
  • DAX (data analysis expressions)
  • Programming or scripting experience
  • SSIS
  • Previous experience analyzing financial information
  • Experience with Infor SX.e ERP
  • Progress SQL-92
  • Schedule Location

    Monday – Friday Daytime Hours

    Lansing, IL

    Full-time, 40 hours / week

    In-office

    Salary Expectations

    Minimum starting salary of $60k annually

    Starting salary based on experience

    About Us

    Integrity. Service. Value.

    A nod and a handshake. A live voice when you call. Standing behind everything we do. It's been business as usual for over 80 years.

    Sure, technologies and equipment change. And our growth allows us to satisfy the biggest HVAC / R needs. But we still know our business is built on the little things.

    Keeping it human is what's helped us grow.

    It's what's important to us as your HVAC partner.

    Requirements

    Qualifications

    Required

  • Associate degree and / or 4 years of related experience
  • Business analysis skills
  • RDBMS (Relational Database Management system) experience
  • Previous experience with learning database schemas
  • Ability to write intermediate / advanced queries using T-SQL
  • Understanding of data warehousing and ETL processes
  • Excellent verbal and written communication skills
  • Preferred

  • Power BI
  • DAX (data analysis expressions)
  • Programming or scripting experience
  • SSIS
  • Previous experience analyzing financial information
  • Experience with Infor SX.e ERP
  • Progress SQL-92
  • Salary : $60,000

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Jr Business Intelligence Analyst?

    Sign up to receive alerts about other jobs on the Jr Business Intelligence Analyst career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $64,949 - $84,690
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $64,949 - $84,690
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $124,087 - $161,899
    Income Estimation: 
    $180,084 - $244,913
    Income Estimation: 
    $202,391 - $284,225

    Sign up to receive alerts about other jobs with skills like those required for the Jr Business Intelligence Analyst.

    Click the checkbox next to the jobs that you are interested in.

    • BI Analytics/Reporting Tools Skill

      • Income Estimation: $73,762 - $101,003
      • Income Estimation: $76,293 - $101,657
    • Change Data Capture Skill

      • Income Estimation: $92,249 - $117,370
      • Income Estimation: $96,598 - $126,350
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Temperature Equipment Corporation

    Temperature Equipment Corporation
    Hired Organization Address Lansing, IL Full Time
    Job Description Warehouse Lead Associate w / Sign on Bonus! Temperature Equipment Corporation (TEC), a WATSCO (WSO) Comp...
    Temperature Equipment Corporation
    Hired Organization Address Lansing, IL Full Time
    Job Description Counter Associate w / Sign on Bonus! Temperature Equipment Corporation (TEC), a WATSCO (WSO) Company, ha...
    Temperature Equipment Corporation
    Hired Organization Address Tinley Park, IL Full Time
    Job Description Counter Associate w / Sign on Bonus! Temperature Equipment Corporation (TEC), a WATSCO (WSO) Company, ha...
    Temperature Equipment Corporation
    Hired Organization Address Alsip, IL Full Time
    Job Description Counter Associate w / Sign on Bonus! Temperature Equipment Corporation (TEC), a WATSCO (WSO) Company, ha...

    Not the job you're looking for? Here are some other Jr Business Intelligence Analyst jobs in the Lansing, IL area that may be a better fit.

    Jr. Business Analyst - Remote

    NextGen | GTA: A Kelly Telecom Company, Chicago, IL

    Business Intelligence Analyst III

    Help at Home, Chicago, IL

    AI Assistant is available now!

    Feel free to start your new journey!