Salary $125,000 - $165,000 a year job type full-time
Benefits pulled from the full job description
401(k) ad&d insurance commuter assistance dental insurance disability insurance flexible spending account show 5 more benefits
Full job description
About ncm: america`s movie network
Who says magic only happens in the movies? come make your own magic at national cinemedia (ncm)! we’re the largest cinema advertising network in the u.sAnd we’re completely obsessed with moviesAs obsessed as darth vader was with taking down the jedi and ruling the galaxy but with less dramaSo, if you like the movies then you’ll love usAnd if you love a great comeback story (who doesn’t love the next installment of james bond?), read onYou might know us from when you get to your seat early at the movie theaterHave you seen the noovie pre-show? we did that! while the world has been battling covid, we’ve also been busy reimagining our business by enhancing our noovie ecosystem and extending our movie-centric content beyond movie theaters via our new digital-out-of-home products and services and addressable digital advertising platformThe movies are making a big comeback & so are we!
We invite you to come join a fun, vibrant and diverse culture with passionate people who thrive on propelling us forwardIf you love to innovate, getting things done, working closely with your teammates and lead with honor, ncm might be the perfect place to grow your careerWe’re committed to building an increasingly diverse team and inclusive culture where every ncmer can thrive and be the best possible version of themselvesWe take our work seriously, but ourselves? not so muchYou’ll come for the job, but you’ll stay for the people!
Check us out at www.ncm.com/careers
The business intelligence (bi) engineer iii is a member of the bi team and supports data management and business intelligence initiativesAs a part of the eis team, the bi engineer helps design and deliver solutions that drive the key decisions of the sales and marketing, creative and media services, accounting, administrative, and eis departmentsThe bi engineer works within the bi team to design and implement modern data and reporting solutions using azure and power bi in addition to supporting legacy ms bi stack solutionsThe bi engineer iii works on highly complex and cross-functional bi solutionsThis position is instrumental in helping the company tackle its bi needs.
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 standard practices, patterns, and guidelines for database deliverables including conceptual design, deployment scripts, data migration plan and performance tuning
Participate in decisions around data architecture including datalake, azure data factory, databricks, and power bi,
Perform peer review of bi engineer designs and implementations
Performs analysis to understand business problems and business data to provide guidance on appropriate business intelligence (bi) and data solutions
Works with the data architect on transforming business requirements into bi design specifications
Act as data/information architect in support of the core internal business application development team work independently or as part of a team to design and develop analytics/reporting solutions
Actively participates in the inception, technical design, development, testing and delivery of bi solutions
Create complex transact sql (t-sql) scripts
Create/maintain 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
Create power bi datasets and reports to provide aggregated or ad-hoc analytics
Create reports and dashboards using power bior other self-service bi tools
Troubleshoot t-sql, ssis, adf, python, reports, dashboards, mds, and other dw/bi solutions and fix as directed
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
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
Able to provide technical consultation to coworkers
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
Experience with source code control and sdlc tools
Understanding and experience with azure and amazon cloud services including sql server, azure data factory, data lake, azure service bus, azure databricks using python notebooks and amazon redshift dw
Understand of and experience with azure devops builds, deploys and other automations
Able to create ms sql server integration services (ssis) packages with complex control and data flows, sequence containers with precedence constraintsMust know majority of ssis data flow transforms, when each is appropriate and understand blocking vs non-blocking transforms, and how to best use parallelism
Extensive hand-on experience in data warehouse design and architecture, dimensional/tabular modeling, data integration/services
Strong experience with dax especially in the power bi context
Experience with data warehouse design techniques including slow changing dimensions, aggregation, partitioning and indexing strategies
Ms sql server analysis services (ssas) tabular with an emphasis on power bi hosted implementations and their integration with power query and partitioned datasets
Experience/understanding of balanced scorecard and kpi’s
Proven experience implementing a master data management solution
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
Working knowledge of cloud technologies for use in data warehouse and analytic solutions
Excellent written, verbal, and documentation skills
Proficiency with ms office (word, excel, powerpoint, visio, power pivot)
Ability to provide technical consultation to coworkers
Experience with master data services (mds)
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., ms power bi or other self-service bi tools
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.
7+ years of technical experience with at least 3+ years of experience supporting major systems.
Education: * bachelor’s degree in information systems, computer science, electrical/mechanical engineering, mathematics or physics preferred but not required.
Licensure / certification:
This job operates in a professional office environmentThis role routinely uses standard office equipment such as computers, phones, photocopiers, and filing cabinets.
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 satisfactorilyReasonable accommodations may be made to enable individuals with disabilities to perform the essential functionsTo request an accommodation, please contact human resources at (303) 792-8899 or email: firstname.lastname@example.org.
****out-of-market applicants are welcomePlease be advised that ncm does not pay any relocation expenses****
Ncm requires employees to be fully vaccinated or have an approved religious or medical accommodationCandidates will be required to show proof of being fully vaccinated against covid-19 upon commencing employmentCurrently, candidates will be considered fully vaccinated two weeks after completing their primary vaccination with a covid-19 vaccine, with, if applicable, at least the minimum recommended interval between doses candidates may also be required to receive covid-19 booster shots in a timely manner to be considered fully vaccinated.
Reasonable accommodations will be considered on a case-by-case basis for exemptions to this requirement in accordance with applicable lawApplicants should be aware that for external-facing roles, accommodations that involve remaining unvaccinated against covid-19 may not be deemed reasonableThe company will engage in the interactive process on an individualized basis to support candidates and employees****
Salary range & benefit options for colorado applicants:
Salary range: base salary $125,000 - $165,000 annually plus bonus - compensation is commensurate with skills & experience.
Medical insurance with wellness reimbursement program
Flexible spending account (fsa)
Health savings account (hsa)
401(k) retirement plan
Life & accidental death & dismemberment insurance
Short and long-term disability insurance
Paid leave (vacation, personal days and sick)
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 positionThe compensation offered to the successful applicant may vary based on factors including experience, skills, education, location, and other job-related reasons.
Job type: full-time
Pay: $125,000.00 - $165,000.00 per year
Posted 30+ days ago