What are the responsibilities and job description for the Data Analyst position at DEVELOPMENTAL PATHWAYS?
Job Details
Job Location: Developmental Pathways Aurora Office - Aurora, CO
Position Type: FT - 40 hrs/week
Salary Range: $90,000.00 - $110,000.00
Job Shift: Day
Job Category: Information Technology
Developmental Pathways (DP) has an opportunity for a Data Analyst in our Information Technology (IT) department.
The Data Analyst role is a crucial and dynamic position within DP, providing an exciting opportunity to influence key decisions across the organization. In this role, you will be responsible for analyzing large, complex datasets, providing actionable insights, and creating impactful visualizations that drive data-informed decision-making across the organization. As a critical member of the Data and Development team, you will be instrumental in transforming raw data into strategic information that empowers stakeholders at all levels. Your expertise in Power BI, SQL, and data modeling will be vital as you collaborate with cross-functional teams to deliver high-quality, data-driven solutions.
This is a 40-hour per week, hybrid position, with the benefit of working remotely and in-person coming into our headquarters office in Aurora, CO and/or off-site locations
*Please note this is not a remote position, Colorado residency is required.
Application Deadline: Sunday, February 9, 2025, at 11:59 PM (MST)
Starting Salary & Benefits
$90,000–$110,000 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 training
You Belong! To learn more about our commitment to inclusion and diversity, visit our website: https://www.dpcolo.org/about-us/inclusion-and-diversity/
Requirements
-
Bachelor’s degree in a computer-related or business studies field and three (3) years of related experience
-
Or Associate’s degree and four (4) to six (6) years of related work experience
-
Or seven (7) years of related work experience
-
-
3 years of experience as a Data Analyst or similar role
-
Advanced expertise and job experience in T-SQL, including strong skills in optimizing query performance through indexing, execution plan analysis, and query cost reduction. This role requires experience in writing, maintaining, and optimizing stored procedures, functions, and dynamic SQL for efficient data transformation and complex business logic. Proficiency in crafting complex queries, utilizing window functions, and implementing best practices for transaction management and error handling is essential
-
Strong Power BI proficiency and job experience: Demonstrated experience in building and maintaining Power BI reports and dashboards that support team insights and decision-making. Competence with data modeling, DAX basics, and Power Query for data transformation
-
Familiarity with creating visually effective dashboards and optimizing reports for performance with moderate data volumes is preferred
-
-
Strong analytical skills with the ability to translate complex data into actionable insights
-
Experience working with SQL for data extraction, transformation, and analysis
-
Comprehensive 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
-
This role requires expertise 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
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
-
Certifications: (Microsoft Certified: Power BI Data Analyst Associate, Microsoft Certified: Azure Data Engineer Associate, Microsoft Certified: Azure Fundamentals, Certified Analytics Professional (CAP))
Additional Responsibilities
-
Data Collection & Analysis: Gather and analyze large volumes of structured and unstructured data from a variety of internal and external sources. Use advanced data analysis techniques to identify key trends, patterns, and anomalies that support business objectives and strategic priorities
-
T-SQL: Crafting complex queries, utilizing window functions, and implementing best practices for transaction management and error handling is essential
-
Power BI Development: Design and develop interactive dashboards, reports, and data visualizations using Power BI to translate complex data into easily understandable insights.
-
Collaboration: Collaborate with cross-functional teams to understand business requirements and translate them into well-designed data-driven solutions
-
Data Modeling & Query Design: Design and implement data models and queries to support business intelligence and analytics reporting. Design and optimize SQL queries to efficiently extract, transform, and load (ETL) data into appropriate formats for analysis
-
Data Validation & Quality Assurance: Ensure the accuracy, integrity, and consistency of data through rigorous validation and quality checks. Reconcile discrepancies between different data sources and ensure data correctness before generating reports or dashboards
-
Data Governance & Documentation: Develop and maintain comprehensive documentation for data models, dashboards, and reporting processes to ensure transparency and support for future improvements
-
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
About Us
Started in 1964, Developmental Pathways (DP) is a nonprofit agency serving more than 15,000 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 Colorado’s Community Centered Boards (CCB), connecting people to federal, state, county, and private funding. We are also Colorado’s 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.
Started in 1964, Developmental Pathways (DP) is a nonprofit agency serving more than 15,000 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 Colorado’s Community Centered Boards (CCB), connecting people to federal, state, county, and private funding. We are also Colorado’s 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 values
If you need an accommodation with this application process, please contact Support-HR@dpcolo.org
Salary : $90,000 - $110,000
