Crunch Fitness - Fitness Holdings North America, LLC.

Business Intelligence Analyst

Crunch Fitness - Fitness Holdings North America, LLC.  •  $60k/yr  •  Lansing, IL (Onsite)  •  1 day ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

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.

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.

Qualifications

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

Qualifications

Qualifications

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
Crunch Fitness - Fitness Holdings North America, LLC.

About Crunch Fitness - Fitness Holdings North America, LLC.

Crunch is a gym that believes in making serious exercise fun by fusing fitness and entertainment and pioneering a philosophy of ‘No Judgments.’ Crunch serves a fitness community for all types of people, with all types of goals, exercising all different ways; working it out at the same place together. Today, we are renowned for creating one-of-a-kind group fitness classes and unique programming for our wildly diverse members.

About Us:

Fitness Holdings Northeast is a leading franchisee of Crunch Fitness. The company is rapidly expanding its club footprint throughout the Northeast with a goal to increase to 100 clubs. With a comprehensive fitness offering and affordable price point, Crunch Fitness offers unmatched value to its members regardless of fitness level and is well positioned to take advantage of consumers' increasing focus on health and wellness.

Industry
Arts & Entertainment
Company Size
51-200 employees
Headquarters
Greenwich, CT
Year Founded
2012
Social Media