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

    • Filtration Sales Specialist - Food & Beverage

      Eaton Ellisville, MO

      View Job
    • Benefits Manager

      Aegion Corporation Chesterfield, MO

      View Job
    • Marketing Specialist

      GoHealth Urgent Care Des Peres, MO

      View Job
    • Business Intelligence Developer

      Relay Technology Inc. St. Louis, MO

      View Job
    • Senior Recruiting Specialist

      Drury Hotels Creve Coeur, MO

      View Job
    • Business Development Officer (BDO)

      Bank of America Clayton, MO

      View Job
    • Trane Supply - Inside Sales Representative- Earth City, MO

      Ingersoll Rand Earth City, MO

      View Job
    • Digital Marketing Specialist

      Interface Security Systems LLC Earth City, MO

      View Job
    • Content Marketing Specialist St. Louis, MO

      View Job
    • Bindery Operator IV (3rd Shift)

      Epsilon Saint Charles, MO

      View Job
    • Bindery Operator IV (3rd Shift)

      AllianceData Saint Charles, MO

      View Job

    Featured Articles

    Best SAP BW Online Training Conducted By Experts

    29 April 2016

    SAP BW stands for SAP Business Warehouse. It is BI, analytical, reporting, and data warehousing software. It is an embedded analytical engine. It is a valuable tool for developing data warehouses that accurately and effectively support critical business decision-making. It facilitates various featur

    read more..

    Best SAP XI Online Training By Professionals In USA

    29 April 2016

    SAP XI stands for SAP Exchange Infrastructure. It is SAP’s enterprise application integration (EAI) software. It is a component of Net Weaver product group used to facilitate exchange information among company’s internal software and systems. It is compatible with software products of other comp

    read more..

    Last Minute Tips For H1B Visa Applicants

    17 September 2015

    All the H1B visa applicants are scared of the H1-B cap gap because it limits the total number of H1B visa to be approved. Not all the petition filers get the positive reply; some may have to the visa rejection while others have to wait for another turn during the year. The H1B visa applicants who a

    read more..

    How to Negotiate Salary for New Job Offer over Phone, Email Samples with Counter Offer

    06 November 2018

    People often face this scenario in life when they’ve given their best during an interview process and convinced the company to offer them the job they’ve been eyeing for, but as soon as the hiring manager reveals the compensation to them, their feeling of excitement disappears. It is an undeniab

    read more..

    Thanks For Your Feedback

    OPT Nation© 2018 Powered By Ragns Inc

    Attach A Resume First