Jr Business Intelligence Analyst

$60,000 - $60,000/Yr

Tec Leasing - Lansing, IL

Full-time - Entry Level

Lansing, IL

Rental and Leasing Services

About the position

The Jr. Business Intelligence Analyst at Temperature Equipment Corporation (TEC) will support the evolution of modern business intelligence tools under the guidance of the Director of Information Technology. This role involves learning the ERP database schema, writing complex SQL queries, and building reports and dashboards for various business units, contributing to data-driven decision-making within the company.

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 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 documentation.

Requirements

• 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.

Nice-to-haves

• Power BI DAX (data analysis expressions) experience.
• Programming or scripting experience (PHP, PowerShell, C#, etc.).
• SSIS experience.
• Previous experience analyzing financial information.
• Experience with Infor SX.e ERP and Progress SQL-92.

Benefits

• 401(k) matching
• AD&D insurance
• Dental insurance
• Health insurance
• Paid holidays