Data Analyst I

DEVELOPMENTAL PATHWAYS • Aurora, CO

3d • Hybrid

About The Position

Developmental Pathways (DP) has an opportunity for a Data Analyst I in our Information Technology (IT) department. The Data Analyst I role is a valuable opportunity to contribute to impactful, data-driven initiatives across the organization. This role will work with diverse datasets to uncover insights, support reporting needs, and help create visualizations that inform decision-making. As a key member of the Data and Development team, the Data Analyst I will collaborate with cross-functional partners to support business goals through data analysis, visualization, and reporting. This role will apply skills in SQL, Power BI, and data modeling to help turn raw data into meaningful information, while continuing to develop technical and analytical expertise. This role offers a 4-day, 40-hour work week, Monday-Thursday. DP operates a primarily hybrid work environment with in-person requirements at our Colorado office. The frequency of on-site work varies by department and is subject to change based on operational needs.

Requirements

• Bachelor's degree in a computer-related or business studies field and two (2) years of related experience, OR Associate's degree and three (3) to five (5) years of related experience, OR six (6) years of related work experience
• Knowledge and field experience in T-SQL, including experience in writing, maintaining, and optimizing SQL queries for efficient data transformation and complex business logic
• Assist in monitoring and interpreting quality metrics
• Understanding of data visualization principles and best practices, with a proven ability to design clear, engaging, and effective visual representations of data that communicate complex insights to a wide range of stakeholders
• Knowledge in selecting appropriate chart types, designing intuitive dashboards, and ensuring that visualizations are both functional and easy to interpret.
• Familiarity with data visualization best practices and principles
• Excellent communication and presentation skills, with the ability to effectively convey technical concepts to non-technical stakeholders
• Ability to work effectively in a fast-paced environment and manage multiple priorities
• Adaptability and willingness to learn new technologies and methodologies
• Personal vehicle in good operating condition for use during work as appropriate
• Valid Colorado motor vehicle license and proof of motor vehicle insurance
• Ability to meet our driving requirements - no suspensions/ no more than two tickets in the past three years
• Upon request, qualifying need, and approval, driving requirements may be waived in lieu of reliable transportation.
• Professional field experience in SQL and Power BI.
• We are ideally seeking an individual with at least 3 years of experience as a Data Analyst.
• Please note: This position requires workers to be authorized to work in the U.S without requiring visa sponsorship by an employer now or in the future.
• Candidates must reside in Colorado.

Nice To Haves

• Experience with Azure DevOps Boards: Proficiency in using Azure Boards to track, manage, and analyze work items, sprints, and project progress. Familiarity with creating dashboards, generating insights from board data, and using custom queries to support team reporting and agile processes
• Basic understanding of CMS quality measures and regulatory reporting frameworks
• Certifications: (Microsoft Certified: Power BI Data Analyst Associate, Microsoft Certified: Azure Data Engineer Associate, Microsoft Certified: Azure Fundamentals, Certified Analytics Professional (CAP))

Responsibilities

• Analyze large volumes of structured and unstructured data from a variety of internal and external sources. Use data analysis techniques to identify key trends, patterns, and anomalies that support business objectives and strategic priorities
• Write, maintain, and optimize stored procedures, functions, and dynamic SQL for efficient data transformation and complex business logic. Craft T-SQL queries, utilizing window functions, and implementing best practices for error handling
• Design and develop interactive dashboards, reports, and data visualizations using Power BI to translate complex data into easily understandable insights. Utilize Power BI features, including DAX calculations, Power Query, and data modeling to ensure reports meet the needs of business stakeholders
• Collaborate with cross-functional teams to understand business requirements and translate them into well-designed data-driven solutions
• Monitor the performance of data models, dashboards, and reports to ensure they are delivering the expected value to stakeholders. Proactively recommend and implement optimizations to improve speed, efficiency, and scalability
• Stay up to date with the latest trends, emerging technologies, and best practices in data analytics, Power BI, and data visualization. Continuously refine skills and knowledgebase to adopt cutting-edge tools and techniques for optimizing data analysis and reporting processes

Benefits

• $76,839 - $86,444 annually
• Health/dental/vision coverage
• Employer-paid and supplemental life insurance
• Short- and long-term disability insurance
• Generous paid time off and holiday pay
• Flexible work schedule
• Monthly remote work stipend
• 401(k) investment plan, with an employer match of up to 4%
• Mileage reimbursement
• Tuition reimbursement program
• Certified Employer for Public Service Loan Forgiveness Program
• Healthcare reimbursement and flexible spending plan
• Discounts on auto and homeowners’ insurance
• Employee assistance program
• Credit union membership
• Employer-paid trainin

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level