Jr Business Intelligence Analyst

2 days ago


Lansing, United States Temperature Equipment Corporation Full time
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 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

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 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


  • Lansing, United States Temperature Equipment Corporation Full time

    *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...


  • Lansing, Michigan, United States Temperature Equipment Corporation Full time

    The Business Intelligence Analyst role at Temperature Equipment Corporation is a key position in helping us drive customer loyalty and technical excellence. The successful candidate will work alongside the Programmer Analyst to develop and implement modern business intelligence tools, collaborating with business users and subject matter experts to establish...


  • Lansing, Michigan, United States System Soft Technologies Full time

    We are looking for a highly skilled Business Intelligence Developer to join our team at System Soft Technologies. As a key member of our organization, you will play a crucial role in shaping the future of our business.Salary: $50.00 per hour on W2The ideal candidate will have a minimum of 3 years of experience as a System/Business Analyst conducting Joint...


  • Lansing, Michigan, United States Auto-Owners Insurance Full time

    The Business Intelligence Technical Lead will design and implement BI solutions that enhance data-driven decision making across the organization, working closely with stakeholders to gather requirements and understand their data needs.


  • Lansing, Michigan, United States Auto-Owners Insurance Full time

    Auto-Owners Insurance is a top-rated insurance carrier seeking a Business Intelligence Technical Lead to join our Actuarial division. This role combines leadership, technical expertise, and strategic vision to develop and maintain BI systems and processes.">The position's essential functions are:BI Architecture and DevelopmentDesign and implement robust BI...

  • Business Analyst

    7 months ago


    Lansing, United States Global Pharma Tek Full time

    Job Title: Business Analyst Location: Lansing, MI (Hybrid) Duration: Months Short Description: This project resource will work with the Michigan Customer of Corrections to review, analyze, and evaluate business processes around the implementation of a new enterprise-level software solution that will replace numerous aging legacy systems. Special...

  • Business Analyst

    2 days ago


    Lansing, United States Rose International Full time

    Date Posted: 12/19/2024Hiring Organization: Rose InternationalPosition Number: 475815Job Title: Business AnalystJob Location: Lansing, MI, USA, 48933Work Model: HybridShift: Onsite 2 days per weekEmployment Type: TemporaryEstimated Duration (In months): 13Min Hourly Rate($): 62.00Max Hourly Rate($): 62.00Must Have Skills/Attributes: Azure, DevOps,...


  • Lansing, United States Auto-Owners Insurance Group Full time

    We offer a merit-based work-from-home program based on job responsibilities. After initial training in-person, you could have the flexibility of work-from-home time as defined by the leadership team. Auto-Owners Insurance, a top-rated insurance carri Business Analyst, Business, Associate, Analyst

  • Business Analyst

    2 months ago


    Lansing, United States System Soft Technologies Full time

    Title: : Business AnalystLocation: Lansing, MIContract: 12 MonthsRate: $.5000/HR on W2Top Skills & Years of Experience Required:Skill Required / Desired Required Years of experienceExposure to Complex IT web Applications, within thepast 5 years Required 5 YearsExperience in gathering and documenting businessrequirements Required 5 YearsExperience in a role,...

  • Business Analyst

    2 days ago


    Lansing, United States PSR Associates, Inc. Full time

    About the RolePlease note this role is not open to C2C and third parties. Candidates must work on PSR Associates w2.PSR Associates is immediately seeking a Business Analyst to join our team providing direct support to our client onsite in Lansing, MI. **Seeking candidates who are within a commutable distance to Lansing, MIJob Description:We are seeking a...

  • Business Analyst

    2 months ago


    lansing, United States System Soft Technologies Full time

    Title:Business Analyst Location Lansing, MI Duration 12 Months Rate: 50 on W2 Top Skills & Years of Experience Required:• Experience working with multiple agencies and/or vendors and/or departments in an enterprise environment• Business Understanding• Identifies systemic gaps and possible solutions for continuous improvements and modernization.•...


  • Lansing, United States Brooksource Full time

    Job Title: Junior Business Analyst (Veterans|Transitioning Service Members)Contract: 12M Contract to HirePay: $20-$30/hr DOELocation: 100% remote until March 2025, and then onsite 2 days/week in Lansing, MI due to office renovations. Interview Process: 15m phone screening with Brooksource recruiter, 30m Microsoft Teams video interview with Brooksource...

  • Business Analyst

    2 months ago


    Lansing, United States V Group Inc. Full time

    The ideal candidate is a team player who will be responsible for working with company data in various business areas. Specific responsibilities include reporting metrics, analyzing methodologies, suggesting operation improvements, and building proposal evaluations in a cross-functional environment. Required:Exposure to Complex IT web Applications, within...

  • Business Analyst

    2 months ago


    Lansing, United States System Soft Technologies Full time

    Title:Business Analyst Location Lansing, MI Duration 12 Months Rate: 50 on W2 Top Skills & Years of Experience Required:• Experience working with multiple agencies and/or vendors and/or departments in an enterprise environment• Business Understanding• Identifies systemic gaps and possible solutions for continuous improvements and modernization.•...

  • Business Analyst

    1 month ago


    Lansing, United States System Soft Technologies Full time

    Title:Business AnalystLocation Lansing, MIDuration 12 MonthsRate: 50 on W2Top Skills & Years of Experience Required:• Experience working with multiple agencies and/or vendors and/or departments in an enterprise environment• Business Understanding• Identifies systemic gaps and possible solutions for continuous improvements and modernization.•...


  • Lansing, Michigan, United States System Soft Technologies Full time

    About the RoleAs a Business Systems Analyst at System Soft Technologies, you will be responsible for gathering and documenting business requirements, as well as providing technical support to various stakeholders.You will work closely with cross-functional teams to analyze business needs and develop solutions that meet those needs.

  • Business Analyst MI

    6 days ago


    lansing, United States Rose International Full time

    Date Posted: 12/19/2024 Hiring Organization: Rose International Position Number: 475815 Job Title: Business Analyst Job Location: Lansing, MI, USA, 48933 Work Model: Hybrid Shift: Onsite 2 days per week Employment Type: Temporary Estimated Duration (In months): 13 Min Hourly Rate ($): 62.00 Max Hourly Rate ($): 62.00 Must Have...


  • Lansing, United States System Soft Technologies Full time

    Senior Business Analyst Location: Lansing, MIWork Schedule: Hybrid (2 days onsite)Contract Duration: 1 year with possible extensionJob Summary:We are seeking a highly experienced Senior Business Analyst to provide ongoing maintenance and support for applications within the Public Health program area, including Women, Infants, and Children (WIC), Kindergarten...


  • Lansing, United States Brooksource Full time

    Senior Business AnalystTasks:Facilitates meetings with the technical team and business client.Gathers requirements and project specifications by leading requirement sessions independently.Maintain backlog of work items.Manage project tasks, timelines, and communication between business product owner and development team associated with the Change Management...

  • Business Analyst

    2 days ago


    Lansing, United States ARK Solutions, Inc. Full time

    Business Analyst 5 - Senior BAPosition Justification:(Why this resource is being procured and which applications/projects/other areas this resource will be working on)The position is responsible for providing ongoing maintenance and support for applications supported within our department.These applications are part of the health program area.The resource is...