Business Intelligence Analyst

Tecmungo

Lansing, Northern (IL, KY)

Hybrid

USD 54,000 - 66,000

Full time

9 days ago

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

TEC Leasing Inc in Lansing, IL seeks a Business Intelligence Analyst to build reports and dashboards, learning ERP schema and validating results for accuracy. You will collaborate with business users to define BI solutions and translate requirements into technical specs.

You should have 4+ years of relevant experience, strong SQL (T-SQL) skills, and familiarity with MS SQL Server, Oracle EPM, and Power BI. This is an in-office role with full-time hours in the Lansing area.

Qualifications

Associate degree and/or 4+ years of related experience
Strong business analysis and data skills
Experience with relational DBMS and learning database schemas
Proficient in writing intermediate/advanced T-SQL queries
Understanding of data warehousing and ETL processes
Excellent verbal and written communication skills

Responsibilities

Collaborate with business users to define BI solutions
Translate BI requirements into technical specifications
Use MSSQL and Oracle EPM to create reports and dashboards
Develop SQL queries to aggregate results for analysis
Build data marts to support Power BI visuals
Produce technical documentation

Skills

T-SQL

Business analysis

Power BI

Verbal and written communication

Education

Associate degree

Tools

MSSQL

Oracle EPM

Power BI

SSIS

Infor SX.e ERP

Job description

Job Description

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