Job description
Scripps Corporate is seeking a Senior Data Engineer. This person is responsible for the information needs of the organization. Primarily responsible for building complex data pipelines and designing systems for use by the business. Also responsible for monitoring the health status of the data ecosystem and digging into the vast repository of raw data to create insights on the data, its use and growth. This position plays an integral role in designing and building new data products/systems, leading projects, and supporting other engineers. This is a remote position.
WHAT YOU'LL DO:
-
Work with / mentor data engineers in programming best practices
-
Provide management on statistics around data usage
-
Identify and create strategies to address data quality concerns and enforce standards.
-
Implement data management repositories based on multiple internal and external data sources
-
Manage logical and physical data models and maintain detailed design documents
-
Troubleshoot critical ETL workflow and data centric problems and recommend solutions
-
Work with analytics business partners to analyze business needs, data sources and develop technical data pipeline solutions to ingest raw data into data warehouse tables
-
Write new or modify existing code and conduct complete end to end unit tests on data and data pipelines
-
Collaborate with the business analytics team to analyze, resolve, and put in place corrective measures to maintain data accuracy and integrity in support of strategic analytics applications
-
Work with SQL databases, APIs, flat files, web scrape and other methods to obtain and ingest raw data leveraging appropriate coding languages such as SQL or Python
-
Write transformation logic on raw data and subsequently create semantic layers to publish data in a form suitable for consumption by business users and BI visualization tools
-
Performance tune processes to ensure data processing is meeting all business and technical expectations
-
Develop API’s to enable business and/or other system’s consumption of published data
-
Create and maintain pipeline process documentation and recovery procedures on how to resume failed pipeline processing
-
Consult with and assists other programmers to analyze, schedule and implement new or modified workflows
-
Provide training to engineers and other IT personnel to grow knowledge in techniques and processes
WHAT YOU'LL NEED:
-
Bachelor’s degree in computer science, Management information systems (MIS) or related degree / experience commensurate to a degree preferred
-
5+ years of hands-on experience implementing, maintaining, and supporting data management solutions including program/project delivery
-
7+ years of experience with SQL & T-SQL code development - experience with Snowflake preferred
-
5+ years of experience with Python
-
4+ years of experience with Databricks
-
4+ years of experience designing, building and deploying solutions with Azure Data Factory
-
4+ years of experience with logical modeling for visualization tools (Tableau, Power BI, Sigma)
-
4+ years of Experience with Data lake technologies including ADLS Gen. 2, AWS S3, AWS Glue preferred
WHAT YOU'LL BRING:
-
Superior technical analysis, critical thinking, troubleshooting and problem-solving skills
-
Extensive SQL & general data analysis expertise
-
Outstanding Experience with ETL tools and techniques
-
Experience building high volume pipelines
-
Expert in data discovery and data analysis
-
Experience with data virtualization techniques
-
Full understanding of data base concepts, data typing and database cardinality principles
-
Predictive analytics experience is a plus
-
Experience with PySpark is a plus
-
Scripps offers a remote work option for this position
SCRIPPS' COMMITMENT TO EQUITY, DIVERSITY AND INCLUSION:
At Scripps, we are committed to a diverse and inclusive culture that reflects the communities we serve. We are intentional about creating an environment where employees, our audiences and other stakeholders feel valued and inspired to reach their full potential and make authentic connections. We foster a workplace culture that embraces each person’s diversity, including the extent to which they are similar or different. Scripps leaders believe that an equitable and inclusive culture is not only the right thing to do, it is a business imperative. Read more about our commitment to equity, diversity and inclusion at
scripps.com
.
ABOUT SCRIPPS:
The E.W. Scripps Company
(NASDAQ: SSP) is a diversified media company focused on creating a better-informed world. As one of the nation’s largest local TV broadcasters, Scripps serves communities with quality, objective local journalism and operates a portfolio of 61 stations in 41 markets. The Scripps Networks reach nearly every American through the national news outlets Court TV and Scripps News and popular entertainment brands ION, Bounce, Defy TV, Grit, ION Mystery and Laff. Scripps is the nation’s largest holder of broadcast spectrum. Scripps runs an award-winning investigative reporting newsroom in Washington, D.C., and is the longtime steward of the Scripps National Spelling Bee. Founded in 1878, Scripps has held for decades to the motto, “Give light and the people will find their own way.”
As an equal employment opportunity employer, The E.W. Scripps Company and its affiliates do not discriminate in its employment decisions on the basis of race, sex, sexual orientation, transgender status, gender, color, religion, age, genetic information, medical condition, disability, marital status, citizenship or national origin, and military membership or veteran status, or on any other basis which would be in violation of any applicable federal, state or local law. Furthermore, the company will make reasonable accommodations for qualified individuals with known disabilities unless doing so would result in an undue hardship for the company.
gatheringourvoice.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, gatheringourvoice.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, gatheringourvoice.org is the ideal place to find your next job.