Data Analyst IV
Job Summary
Our client, a leading communications provider, is seeking a Senior Data Analyst to join their team. This position is located in Greenwood Village, Colorado.
We're looking for a highly analytical Senior Data Analyst to join a small, highly tenured team responsible for improving the reliability and performance of customer premise equipment (CPE), including modems and routers. This team partners closely with engineering and connectivity experts to investigate complex issues, identify trends within massive telemetry datasets, and drive improvements that directly impact the customer experience. This is an ideal opportunity for someone who enjoys solving difficult problems, digging into data to uncover root causes, and using analytics to influence technical decisions. Success in this role requires curiosity, strong SQL skills, and the ability to translate complex data into actionable insights.
Core Responsibilities
- Analyze large-scale telemetry data to identify trends, anomalies, and opportunities to improve modem and router reliability
- Investigate activation and connectivity issues through deep data analysis and long-term problem investigation
- Write and optimize complex SQL queries using joins, CTEs, window functions, aggregations, and other advanced techniques
- Work with large datasets and understand how data models, schemas, and relationships support accurate analysis
- Partner with engineering, networking, and product teams to troubleshoot issues and validate findings
- Build dashboards and visualizations that clearly communicate insights and support data-driven decision making
- Develop scripts and automation to improve analytical workflows and eliminate repetitive manual tasks
- Monitor data quality, ETL processes, and pipeline health to ensure reliable reporting and analysis
- Balance multiple investigations and priorities in a fast-paced, collaborative environment
Required Skills/Experience (Must-Haves)
- 2+ years of experience in a Data Analyst, Business Analyst, or similar analytical role
- Advanced SQL skills, including:
- Complex joins
- Common Table Expressions (CTEs)
- Window functions
- Aggregations
- Query optimization
- Strong understanding of relational data models, database schemas, normalization, and how data relates across systems
- Experience working with large datasets and data warehouses
- Knowledge of ETL processes, data pipelines, and data quality concepts
- Experience creating dashboards and visualizations that communicate business insights
- Programming or scripting experience with Python, Java, or another procedural language
- Experience automating repetitive analytical tasks
Preferred Skills/Experience (Nice-to-Haves)
- Experience with AWS Athena, Amazon Redshift, or other cloud-based analytics platforms
- Tableau, Power BI, or advanced Microsoft Excel (Pivot Tables) experience
- Experience with Git or another version control system
- Networking knowledge, including TCP/IP, DHCP, OSI Model, and modem/WiFi concepts
- Experience analyzing telemetry, operational, or device data
Key Competencies & Behaviors
- Ability to manage multiple priorities in a lean, collaborative team environment
- Excellent analytical, troubleshooting, and problem-solving skills
- Strong communication skills with the ability to explain technical findings to a variety of audiences
Work Environment
- Location: Greenwood Village, Colorado
- Onsite
Compensation & Benefits
- Pay Range: The approximate pay range for this position is between $101,000 and $123,480. Please note that the pay range provided is a good faith estimate. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location. We comply with local wage minimums.
- Medical, Dental, & Vision Insurance Plans
- Employee-Owned Profit Sharing (ESOP)
- 401K offered
About KellyMitchell
At KellyMitchell, our culture is world class. We’re movers and shakers! We don’t mind a bit of friendly competition, and we reward hard work with unlimited potential for growth. This is an exciting opportunity to join a company known for innovative solutions and unsurpassed customer service. We're passionate about helping companies solve their biggest IT staffing & project solutions challenges. As an employee-owned, women-led organization serving Fortune 500 companies nationwide, we deliver expert service at a moment's notice.
Marketing Disclosure
By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from KellyMitchell and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at https://www.careers.kellymitchell.com/privacy-policy