Note: The job is a remote job and is open to candidates in USA. Cable One is a company that connects customers and associates to what matters most, emphasizing a rewarding career and an inclusive workplace. The Data Engineer II role involves designing and maintaining data pipelines and infrastructure, ensuring data reliability and security while collaborating with teams to enhance data accessibility and decision-making.
Responsibilities
- Designs and develops moderately complex queries, objects, ETL packages, reporting structures, and other objects necessary to support detailed analysis and self-service reporting needs
- Collaborates with analytics and business teams to create and improve data models that feed BI tools, increasing data accessibility, and fostering data-driven decision making across the organization
- Takes ownership of the health, reliability, and security of the data platform by designing and implementing processes and solutions that proactively monitor data delivery across the full pipeline — ensuring data is accurate, complete, consistent, and timely from source ingestion through gold layer curation
- Investigates, diagnoses, and resolves complex data pipeline failures across all system layers; uses findings to drive pipeline improvements and communicates status, root cause, and resolution clearly to the team throughout the full lifecycle of an incident
- Assists with the development and delivery of data solutions, including data pipelines, API integration, and other structures and processes to support the data platform
- Identifies, designs, and implements internal process improvements, including the automation of manual processes, optimization of data delivery, and refactoring of code for improved performance
- Builds pipelines to enable the optimal extraction, transformation, and loading of data from a wide variety of data sources
- Provides strategic assistance to BI leadership and the BI team by making recommendations in the areas of data management and best practices
- Collaborates with developers, database administrators, data architects, and others on reporting and data management projects as needed
- Takes on other duties needed to help drive our Purpose, fulfill our Brand Principles, and abide by our Organization’s Values
Skills
- Bachelor's degree (B.S.) in Science, Technology, Engineering, or Mathematics, or equivalent practical experience
- 5+ years of equivalent experience can substitute for education
- Demonstrated programming experience with SQL (ANSI-SQL)
- Proven demonstration of exemplary ability to complete the functions of a Data Engineer I or similar position
- Professional experience working in cloud data ecosystems, preferably Azure
- Data warehouse experience, including ER modeling and multi-dimensional modeling
- ETL, Extract-Load-Transform (ELT), and/or data pipeline development experience
- Experience with DevOps principles and platforms (Azure DevOps, GitHub, etc.)
- Experience with migrating data from on-premise to cloud
- Experience working in an Agile / Scrum work environment
- Knowledge of Microsoft Azure data related services such as Data Lake, Data Factory, Databricks, and Delta Lake
- Knowledge of data governance, data quality analysis and/or master data management
- Domain knowledge of broadband or telecommunications industry
- Excellent communication (verbal and written) and interpersonal skills and an ability to effectively communicate with both business and technical teams
- Strong organizational and multitasking skills with ability to balance competing priorities
- Intermediate understanding of database management systems (DBMS) such as Microsoft SQL Server
- Foundational understanding of data modeling and warehousing concepts, including dimensional modeling patterns, slowly changing dimensions (Type 1, Type 2), and their practical application in a medallion lakehouse architecture
- Ability to work, focus, and be productive in a virtual, remote, and on-premise environment
- Intermediate knowledge of BI best practices and recommendations for an advanced analytics data ecosystem, including data visualization, data analysis, data integration, and data modeling
- Familiarity with programming languages such as C#, Python, or similar object-oriented languages
- Ability to orchestrate using automation tools such as PowerShell scripts and bash commands
- Understanding of cloud engineering principles, and data architecture design patterns such as Medallion, Kappa, Mesh, etc
- Ability to solve complex problems using a sequential system
- Ability to assess circumstances using experience and a variety of information gathered
Benefits
- Medical, dental, and vision plans – start when you start!
- Life insurance (self, spouse, children)
- Paid time off (vacation, holiday, and personal/sick days)
- 401(k) - 100% company match starts day 1 of employment (up to 5% of eligible compensation)
- Group Legal plan with Identity Theft Protection
- Tuition reimbursement (up to $5,250 on 1st year)
- Annual community support to various organizations across the U.S.
- Associate recognition & awards programs
- Advancement opportunities
- Collaborative work environment
- FREE Cable One services for associates who live in a serviceable area
- Remote Access to select premium channels (Cable One, Sparklight, Cable America and ValueNet Fiber Only)
Company Overview