Temperature Equipment Corporation
Jr Business Intelligence Developer
Temperature Equipment Corporation, Lansing, Illinois, United States, 60438
*Jr. Business Intelligence Developer*
The information below covers the role requirements, expected candidate experience, and accompanying qualifications.
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 Developer 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#, Python, 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 documentation.
*Qualifications *
*Required*
· Associate degree and/or 4+ years of related experience
· Business Intelligence developer 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/CSD ERP system
· Progress 4GL / ABL, SQL-92
*Schedule & Location*
Monday – Friday Daytime Hours
Lansing, IL
Full-time, 40 hours/week
In-office position
*Salary Expectations*
Minimum starting salary of $60k annually
Starting salary based on experience
Job Type: Full-time
Pay: From $60,000.00 per year
Benefits: * 401(k) * 401(k) matching * Dental insurance * Health insurance * Health savings account * Life insurance * Paid time off * Vision insurance
Work Location: In person
The information below covers the role requirements, expected candidate experience, and accompanying qualifications.
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 Developer 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#, Python, 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 documentation.
*Qualifications *
*Required*
· Associate degree and/or 4+ years of related experience
· Business Intelligence developer 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/CSD ERP system
· Progress 4GL / ABL, SQL-92
*Schedule & Location*
Monday – Friday Daytime Hours
Lansing, IL
Full-time, 40 hours/week
In-office position
*Salary Expectations*
Minimum starting salary of $60k annually
Starting salary based on experience
Job Type: Full-time
Pay: From $60,000.00 per year
Benefits: * 401(k) * 401(k) matching * Dental insurance * Health insurance * Health savings account * Life insurance * Paid time off * Vision insurance
Work Location: In person