ABOUT NCM:We are the country's largest, most innovative cinema advertising platform whose mission is to unite brands with our young, diverse audience through the power of movies and pop culture. Hundreds of millions of moviegoers watch The Noovie Show each year, which airs in movie theaters nationwide prior to the trailers and feature film. NCM offers advertisers incredible reach with unrivaled engagement, making cinema a premium destination for advertisers. We're a dynamic, fast-moving company focused on enhancing the moviegoing experience while developing creative ways for brands to connect with our hard-to-reach audience.
We're committed to diversity, inclusion, and belonging, and strive to create a culture that leans into innovation, collaboration, accountability, honor, and perseverance. We're obsessed with the movies, client solutions, and having fun while we work. If that sounds like a great sequel to your career's story, check us out at NCM.com/careers.
POSITION SUMMARY: Join our dynamic team as a Data Engineer and spearhead the evolution of our data management platform! We're on a mission to revolutionize our data landscape, empowering innovation, efficiency, and ongoing enhancement as the keystones of our effort. Leveraging tools and languages such as Python, Java, and SQL, our goal is to craft streamlined data pipelines in a way that is as platform agnostic as possible. As part of this journey, you'll craft an enterprise-wide data model, facilitating our business-centric analysts in generating insightful reports across our entire data ecosystem. We're seeking individuals with a knack for tackling intricate data challenges, coupled with a passion for continuous learning and adaptation to emerging technologies. In this role, you'll work in a collaborative environment, supporting a variety of teams, stakeholders, and products with their data requirements. Join us and be at the forefront of driving data-driven success!
ESSENTIAL FUNCTIONS: Essential duties and responsibilities may include, but are not limited to, the following:
- Product and thrive in a collaborative development environment.
- Participate in decisions around data warehouse architecture and, more specifically, data models and database design.
- Design, build and maintain optimal data pipeline architecture.
- Maintain and optimize the data infrastructure required for accurate extraction, transformation, and loading of data from a wide variety of data sources.
- Follow standard practices, patterns, and guidelines for database deliverables including conceptual design, deployment scripts, data migration plan and performance tuning.
- Ensure data accuracy, integrity, privacy, security, and compliance through quality control procedures.
- Provide access to datasets using REST and Python APIs.
- Design and develop the extraction, transformation, and loading of data from a wide variety of data sources using Python or Java, SQL and cloud technologies.
- Monitor data systems performance and implement optimization strategies.
- Actively participates in the inception, technical design, development, testing and delivery of data solutions.
- Ability to understand and disseminate requirements information from requirements documents into practical work instructions.
- Estimate level of effort, evaluate new options of similar technology, and offer suggestions to improve processes.
- Contribute to long-term strategic vision of platform and tools.
- Support data management efforts and continued improvements to our internal technical infrastructure.
- Perform other work as assigned.
QUALIFICATIONS: Required Knowledge/Skills/Abilities: - Strong proficiency in object-oriented languages: Python, Java, C#, Scala.
- Ability to design, build and unit test applications on Spark framework on Python.
- Build PySpark based applications for both batch and streaming requirements.
- Develop and execute data pipeline testing processes and validate business rules and policies.
- Able to provide technical consultation and coaching to coworkers.
- Experience working with cloud Data Warehouse solutions (e.g., Snowflake, Redshift, Azure, etc.).
- Working knowledge of AWS and Azure cloud platforms.
- Experience working with Databricks.
- Excellent problem-solving, communication, and organizational skills.
- Able to organize work, communicate risk, and meet deadlines.
- Advanced SQL skills and experience with relational databases and database design.
- Experience with source code control and SDLC tools.
- Strong OLAP design skills with an emphasis on Kimball Methodology.
- Understanding of best practices in SSIS design and implementation.
- Extensive hands-on experience in Data Warehouse Design and Architecture, Dimensional/Tabular Modeling, Data Integration/Services.
- Experience with data warehouse design techniques including slow changing dimensions, aggregation, partitioning and indexing strategies.
- Understanding of how to implement developer tests in a BI environment: unit, system, integration.
- Able to break solutions into parts to narrow scope of troubleshooting investigations.
Desired Knowledge/Skills/Abilities: - Experience with Master Data Services (MDS)
- Experience with MDX and DAX
- Experience with cloud analytics
- Experience working in an environment with successful data governance
- Knowledge of advanced data management & processing concepts such as partitioning, sharding, and compression
- Experience architecting and implementing complex operational reporting and dashboard design/layout and implementation of near-real-time graphical KPI's
- Demonstrated design portfolio of descriptive, predictive, and prescriptive analytics using multiple dashboard and reporting tools, e.g., SSRS, MS Power BI, Tableau or any other self-service BI tool
Experience:
7+ years of relevant working experience.
Education:
Bachelor's degree in Information Systems, Computer Science, or related field is required.
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 Human Resources at ([redacted] or email: HR[redacted]
****Out-of-market applicants are welcome. Please be advised that NCM does not pay any relocation expenses****SALARY RANGE & BENEFIT OPTIONS FOR COLORADO APPLICANTS:Salary Range: Base Salary of approximately $140,000-$150,000 plus bonus - compensation is commensurate with skills & experience.
Benefits Options:- Medical insurance with wellness reimbursement program
- Dental insurance
- Vision insurance
- Flexible Spending Account (FSA)
- Health Savings Account (HSA)
- 401(k) Retirement Plan
- Life & Accidental Death & Dismemberment Insurance
- Short and Long-Term Disability Insurance
- Paid Holidays
- Paid Leave (vacation, personal days and sick)
- Commuter benefits
- Pet insurance
This information is provided in compliance with the Colorado Equal Pay for Equal Work Act and is the company's good faith and reasonable estimate of the compensation range and benefits offered for this position. The compensation offered to the successful applicant may vary based on factors including experience, skills, education, location, and other job-related reasons.
NOTICE TO CALIFORNIA APPLICANTS: For details about the Personal Information We may receive in connection with your application with and/or employment with National CineMedia and your rights regarding that Personal Information, please see our Employee / Officer / Director / Owner / Applicant / Independent Contractor Privacy Policy For California Residents at www.noovie.com/privacy.