Temperature Equipment Corporation
Jr Business Intelligence Analyst
Temperature Equipment Corporation, Lansing, Illinois, United States, 60438
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 specificationsUtilize MSSQL and other database tools (including but not limited to Oracle EPM) to build and modify meaningful reports and dashboards for business unitsPerform SQL queries - design, code, test, and aggregate the results to create useful informationBuild aggregated data marts to provide data models and visualizations for Power BIWrite technical documentations.Qualifications
Required
Associate degree and/or 4+ years of related experienceBusiness analysis skillsRDBMS (Relational Database Management system) experiencePrevious experience with learning database schemasAbility to write intermediate/advanced queries using T-SQLUnderstanding of data warehousing and ETL processesExcellent verbal and written communication skillsPreferred
Power BIDAX (data analysis expressions)Programming or scripting experienceSSISPrevious experience analyzing financial informationExperience with Infor SX.e ERPProgress SQL-92Schedule 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 experienceBusiness analysis skillsRDBMS (Relational Database Management system) experiencePrevious experience with learning database schemasAbility to write intermediate/advanced queries using T-SQLUnderstanding of data warehousing and ETL processesExcellent verbal and written communication skillsPreferred
Power BIDAX (data analysis expressions)Programming or scripting experienceSSISPrevious experience analyzing financial informationExperience with Infor SX.e ERPProgress SQL-92
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 specificationsUtilize MSSQL and other database tools (including but not limited to Oracle EPM) to build and modify meaningful reports and dashboards for business unitsPerform SQL queries - design, code, test, and aggregate the results to create useful informationBuild aggregated data marts to provide data models and visualizations for Power BIWrite technical documentations.Qualifications
Required
Associate degree and/or 4+ years of related experienceBusiness analysis skillsRDBMS (Relational Database Management system) experiencePrevious experience with learning database schemasAbility to write intermediate/advanced queries using T-SQLUnderstanding of data warehousing and ETL processesExcellent verbal and written communication skillsPreferred
Power BIDAX (data analysis expressions)Programming or scripting experienceSSISPrevious experience analyzing financial informationExperience with Infor SX.e ERPProgress SQL-92Schedule 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 experienceBusiness analysis skillsRDBMS (Relational Database Management system) experiencePrevious experience with learning database schemasAbility to write intermediate/advanced queries using T-SQLUnderstanding of data warehousing and ETL processesExcellent verbal and written communication skillsPreferred
Power BIDAX (data analysis expressions)Programming or scripting experienceSSISPrevious experience analyzing financial informationExperience with Infor SX.e ERPProgress SQL-92