Business Intelligence Specialist

Nortek Global HVAC – O\'Fallon, MO

About Nortek Air Management

Nortek Air Management’s mission is Creating a Better Tomorrow Every Day. By living our core values of Safety, Integrity, Performance Driven Culture and Teamwork, we want to be the premier HVAC Company offering energy efficient and sustainable products and solutions that exceed customer expectations through employee’s commitment to quality, customer service and operational excellence. Nortek Air Management has annual sales of close to $1 billion and is comprised of three businesses, Residential, Light Commercial and Air Solutions.

Position Summary: The Business Intelligence Analyst will focus on consolidated reporting of disparate ERP systems and databases through the Cloud Data ware house Platform.

Position Key Attributes:

  • Ability to personally live safe and hold themselves and other team members accountable by having their back in support of our Safety core value.
  • Has integrity, works transparently and recognized for treating others with respect.
  • Takes accountability to create and execute solutions that deliver desired results and can “own it” in a Performance Driven Culture.
  • Works collaboratively as one team in a Teamwork culture.
  • Enjoys embracing and igniting change as a catalyst for improvement.
  • A “builder” who is comfortable in a continuous improvement culture.
  • Can thrive in a “legacy now” culture in which we strive to do the right thing for the company today, even if it is the hard thing, and leave behind a stronger company for the next generation of employees.
  • Position Responsibilities:

  • Design, Build, and Support Enterprise Datawarehouse, Data Marts and Reporting / Dashboards.
  • Meet with internal business and IT clients to document business requirements, functional specifications, and testing cases.
  • Work independently with minimal supervision on new projects and support existing applications.
  • Maintains an attitude which consistently represents the organizational culture, including: the mission, vision and core attributes.
  • Translate from function to technical specifications and perform build, test, and deployment of BI Solutions.
  • Participating in data model reviews.
  • Identifies, quantifies, and proposes solutions to address data integrity and data quality issues, including performing source data analysis and data profiling to assess data quality.
  • Other Adhoc duties as assigned by manager.
  • Position Experience/Qualifications:


  • Bachelor’s Degree in Computer Science or Information Systems.
  • Strong critical thinking and analytical problem-solving skills.
  • Strong understanding of relational database and Datawarehouse concepts and SQL.
  • 3+ years of experience in a Business Intelligence Developer role with two or more technologies including SQL DW / SQL Server, SSIS, SSAS (SQL Server Analysis Services & SQL Server Integration Services).
  • Experience to work one or more of source systems for Enterprise Datawarehouse including but not limited to ERP solutions like Microsoft Dynamics AX ERP and/or InfoR SyteLine. Additional systems may include Workday, Synerion, Shop Track, and Custom applications built in .net & java.
  • Preferred:

  • Power BI Experience
  • Working knowledge of Talend ETL, MDM tools
  • Experience with metadata and data modeling tools (Erwin)
  • Experience in Azure / AWS Cloud Environment
  • Working knowledge of AWS BI technology stack including AWS S3, redshift, glue, Data Pipeline, Kinesis or Azure BI Technology stack Azure Data Lake, Azure Data Factory, Azure Data Bricks, SQL Data Warehouse
  • Nortek Air Management and its divisions offer a comprehensive compensation and benefits package.

    Nortek Global HVAC and Nortek Air Solutions are equal opportunity employers and do not unlawfully discriminate against any applicant on the basis of race, color, religion, sex national origin, age disability, sexual orientation, or any other class protected by federal or state law.

    All Jobs in O\'Fallon, MO

    • Business Intelligence Specialist

      Nortek Global HVAC O'Fallon, MO

      View Job
    • Marketing Email and Digital Implementation Specialist

      Mom365 Saint Charles, MO

      View Job
    • Marketing Specialist

      GoHealth Urgent Care Des Peres, MO

      View Job
    • HR Business Consultant I - St. Louis, MO/Remote Opportunity

      Magellan Health Maryland Heights, MO

      View Job
    • Consultant, Software Engineering- Business Intelligence

      MasterCard O'Fallon, MO

      View Job
    • Paid Search Specialist

      Evolve Digital Labs St. Louis, MO

      View Job
    • Region Manager - Central Midwest Territory

      DISH Network Saint Charles, MO

      View Job
    • Region Manager - Central Midwest Territory

      DISH Network Saint Peters, MO

      View Job
    • Region Manager - Central Midwest Territory

      DISH Network Chesterfield, MO

      View Job
    • Region Manager - Central Midwest Territory

      DISH Network Florissant, MO

      View Job
    • Region Manager - Central Midwest Territory

      DISH Network Ballwin, MO

      View Job

    Featured Articles

    H1B Visa Application Processing – H1B Premium and Regular Processing Time

    07 September 2017

    H1B visa application are limited to a total of 85,000 visas for each fiscal year; 20,000 out of which are restricted to foreign individual who have a master’s or any higher degree from the U.S. colleges or universities also known as H1B Cap. Applying for H1B or any

    read more..

    Tips For Getting An F1 Student Visa Approval

    29 December 2015

    There are various types of visas that cover the immigrant and non-immigrant types for visiting the USA. From all of those types, the non-immigrant type F1 student visa is the most talked about. F1 visa is necessary for those who wish to study in the USA. After attaini

    read more..

    Android Development Training

    09 May 2016

    ❯ What is Android & Android Development Training? Android is a software stack for mobile devices that includes an OS, middleware, and key applications. The Android SDK provides the tools and APIs necessary to begin developing applications on the Android platform using the Java prog

    read more..

    Bill Seeking Exemptions for Foreigners with American PhD introduced in US

    02 June 2017

    A bill has been re-introduced in the US House of Representatives that seeks exemption for foreign-born or non-US citizens holding an US Ph.D. from American universities in science, technology, engineering or mathematics from the limitations in the annual cap for the H1B visa; employment-based green

    read more..

    Thanks For Your Feedback

    OPT Nation© 2018 Powered By Ragns Inc

    Attach A Resume First