Job Description

NCM is the connector between brands and movie audiences.  As America’s largest cinema advertising network, and the #1 Millennial weekend network in the U.S., NCM offers broad reach and unparalleled audience engagement, presenting our Noovie pre-show on over 21,100 screens in over 1,700 theaters.  NCM Digital goes beyond the big screen, reaching entertainment audiences with exclusive content and ground-breaking apps like Noovie Arcade, Fantasy Movie League, and Noovie Shuffle.

POSITION SUMMARY:  

As a member of EIS within the small Business Intelligence (BI) team, the BI Engineer II will be expected to practice Lean software development principles and NCM’s core values of integrity, collaboration, accountability, creativity, customer-focus, and passion for movies.

The BI Engineer II is responsible for designing and implementing reporting and analytic solutions that drive the key decisions of our enterprise departments including Sales & Marketing, Partnerships, Creative/Media Services, Human Resources, Finance, and EIS.  The BI Engineer II works closely with the architecture, application development, project management, software quality assurance, operations, and business intelligence teams, as well as the supported internal departments for the purpose of delivering high-quality data management and business intelligence solutions.

Core duties of the BI Engineer II  include designing and implementing business intelligence software deliverables including: generating entity-relationship diagrams; extracting, transforming, and loading data for data migrations and/or ongoing system integration; cubes, reports, and dashboards; participating in peer reviews; troubleshooting; and implementing developer tests to ensure quality.  

ESSENTIAL FUNCTIONS: Essential duties and responsibilities may include, but are not limited to, the following:

• Deliver work in a collaborative, LEAN development environment under tight deadlines

• Follow and help define standard practices, patterns, and guidelines for database deliverables including conceptual design, deployment scripts, data migration plan and performance tuning

• Participate in decisions around data warehouse architecture and, more specifically, data models and database design

• Active participant in the implementation of BI/DW projects in support of business needs. This includes design, development, test and production support

• Create and maintain 

o ER diagrams for enterprise RDMS

o Complex transact sql (t-sql) scripts

o Cloud solutions for data movement using Azure data platform technologies, e.g., Azure Data Lake Gen 2, Azure Data Factory, Azure Logic Apps, Azure SQL Database, Power BI 

o On-premise solutions for data movement using Microsoft BI stack, e.g., ETL packages using SSIS, script SQL Agent jobs and schedules, maintain job execution and dependency metadata as needed for on-going maintenance by the production DBA team

o Data models using Power BI or MS SQL Server Analysis Services (SSAS) tabular or multi-dimensional to provide aggregated or ad-hoc analytics 

o Reports and dashboards using Power BI, SQL Server Reporting Services (SSRS), or another self-service BI tool

• Perform peer review of BI technical designs, code, unit tests 

• Performs analysis to understand business problems and business data to provide guidance on appropriate Business Intelligence (BI) and Data Warehouse (DW) solutions

• Consult with Data/Information Architect on complex design decisions 

• Perform other work as assigned

QUALIFICATIONS:

Required Knowledge/Skills/Abilities: 

• Able to collaborate cross-functionally and pair-program

• Able to organize work, communicate risk, and meet deadlines

• Able to leverage existing frameworks and patterns

• Able to break solutions into parts to narrow scope of troubleshooting investigations

• Able to act as a technical lead on a project and coach less-experienced individuals

• Experience using an ERD tool, e.g. CRErwin or Dezign

• Demonstrated ability to create tables, store procedures, functions, views, triggers

• In-depth knowledge of the MS SQL Server RDBMS platform with an emphasis on set-based t-sql, the SQL parser/optimizer, and performance tuning

• Able to understand the difference and proper usage of OLAP vs OLTP 

• Strong OLAP design skills with an emphasis on Kimball Methodology

• Able to create Microsoft Sql Server Integration Services (SSIS) packages with complex control and data flows, sequence containers with precedence constraints.  Must know majority of SSIS data flow transforms, when each is appropriate and understand blocking vs non-blocking transforms, and how to best use parallelism

• Understanding of best practices in SSIS design and implementation 

• MS SQL Server Analysis Services (SSAS) with an emphasis on creating data source views, dimensions, hierarchies, measure groups, relationships, and partitioning

• Experience with source code control and SDLC tools

• MS Power BI or any other Self-Service BI tool

• Excellent written and verbal skills 

• Proficiency with MS Office (Word, Excel, PowerPoint, Visio, Power Pivot)

Desired Knowledge/Skills/Abilities: 

• Microsoft Azure Data Factory

• Microsoft Azure Data Lake Storage (Gen2)

• Microsoft Azure Databricks

• Microsoft Azure SQL Database

• Microsoft Azure Analysis Services 

• Understanding of how to implement developer tests in a BI environment: unit, system, integration

• Dashboard design/layout and implementation of near-real-time graphical KPI’s

• Experience/understanding of Balanced Scorecard and KPI’s

• How to optimize ETL processes within and without the MS SQL Server Integration Services (SSIS) toolkit

• MS SQL Server Reporting Services (SSRS) with an emphasis on setup, implementation and report writing

• Master Data Services (MDS)

• Master data management

• Data Quality Services (DQS)

• Working knowledge of cloud technologies for use in data warehouse and analytic solutions

• Strong MDX and DAX skills

Experience and Training: 

Any combination of the following experience and training (designated as required and/or preferred) that would provide the required knowledge and abilities is qualifying.  

Experience: 

• 5+ years of experience with OLAP database design & implementation. 

Education: • Bachelor’s degree in Information Systems, Computer Science, Electrical/Mechanical Engineering, Mathematics or Physics preferred but not required. 

Licensure / Certification: 

WORKING CONDITIONS

Work Conditions: 

This job operates in a professional office environment.  This role routinely uses standard office equipment such as computers, phones, photocopiers, and filing cabinets.

Physical Conditions: 

Essential and marginal functions may require maintaining physical condition necessary for sitting for prolonged periods of time, etc.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. To request an accommodation, please contact People & Organization at (303) 792-8899 or email: P&*@nc*.com.

****Out-of-market applicants are welcome. Please be advised that NCM does not pay any relocation expenses****

How to Apply

Job Types: Full-Time.

409 total views, 0 today

Apply for this Job