
Lead Engineer, Data & Analytics
NBCUniversal
full-time
Posted on:
Location Type: Hybrid
Location: Philadelphia • Illinois • Pennsylvania • United States
Visit company websiteExplore more
Salary
💰 $116,475 - $192,184 per year
Job Level
About the role
- Develops data structures and pipelines aligned to established standards and guidelines to organize, collect, standardize and transform data that helps generate insights and address reporting needs
- Creates standard ingestion frameworks for structured and unstructured data as well as checking and reporting on the quality of the data being processed
- Develops and maintains information systems (e.g., data warehouses, data lakes) including data access Application Programming Interfaces
Requirements
- Bachelor's Degree
- 7-10 Years Relevant Work Experience
- Strong design skills for full load, incremental load, and CDC based ingestion patterns in an OLAP environment
- Proficiency in SQL/T SQL for pipeline development and optimization
- On Prem Data Systems Experience with SQL Server on prem and SSIS, Stored Procedures
Benefits
- Best-in-class Benefits to eligible employees
- array of options, expert guidance and always-on tools
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data structuresdata pipelinesSQLT SQLOLAPincremental loadCDCdata ingestiondata access APIsdata optimization
Soft Skills
design skills
Certifications
Bachelor's Degree