Business Intelligence Analyst
Role Overview
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, and the drive to take the initiative to learn and grow their knowledge base.
Key Skills for This Role
Full Job Posting
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, and the drive to take the initiative 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.
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 Temperature Equipment Corporation
HVAC distributor serving contractors with Carrier heating, cooling, refrigeration equipment, parts, and supplies.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Temperature Equipment Corporation
Territory Manager
Merriam, USA
Quality Control Specialist
Lansing, USA
Warehouse Associate
Lansing, USA
Counter Warehouse Associate
North Kansas City, USA
Counter Sales Associate
Elgin, USA
Senior Counter Sales Associate
Summit, USA
Counter Sales Associate
Melrose Park, USA
Facilities Maintenance Intern
Melrose Park, USA