Data Analyst I

Aurora, CO - USA

Monthly Salary: USD 76839 - 86444

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

Description

Title: Data Analyst I

Location: Candidates must reside in Colorado.

Hybrid Schedule: This position follows a flexible hybrid schedule with an equal balance of remote work and on-site presence at our headquarters in Aurora CO.

Must have: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.

Developmental Pathways (DP)has an opportunity for a Data Analyst Iin 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.

Application Deadline:Sunday February 22nd at 11:59 PM (MST)

Compensation and Benefits
$76839 - $86444 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

You Belong!To learn more about our commitmentto inclusion and diversityvisit our website: degree in a computer-related or business studies field and two (2) years of related experience OR Associates 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.

Preferred

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))

Qualifications

Additional Responsibilities

Data Analysis: 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
T-SQL: 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
Power BI Development: 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
Collaboration: Collaborate with cross-functional teams to understand business requirements and translate them into well-designed data-driven solutions
Performance Monitoring: 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
Continuous Improvement: 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

About Us
Started in 1964 Developmental Pathways (DP) is a nonprofit agency serving more than 15000 individuals with disabilities and their families in Arapahoe Douglas and Elbert counties. We are a designated Case Management Agency (CMA) for long-term care services and are one of Colorados Community Centered Boards (CCB) connecting people to federal state county and private funding. We are also Colorados largest Early Intervention (EI) provider and help connect young children to essential resources serving the City of Aurora in addition. Our mission is to enrich the lives of people with disabilities/delays by partnering to provide expertise support and advocacy in their pursuit of a meaningful life.

At DP we believe that our people are our greatest asset. We want to give you the ability to grow and do what you love. We are committed to creating an inclusive and dynamic work environment where employees can thrive and make a meaningful impact. If you are looking for a challenging and rewarding career with an organization that value.

If you need an accommodation with this application process please contact

Required Experience:

DescriptionTitle: Data Analyst ILocation: Candidates must reside in Colorado.Hybrid Schedule: This position follows a flexible hybrid schedule with an equal balance of remote work and on-site presence at our headquarters in Aurora CO.Must have:Professional field experience in SQL and Power BI. We ar...