Please note this is not a remote position and residency in Colorado is required. Additionally candidates 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.
Developmental Pathways (DP) has an opportunity for a Data Analystin 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 datainformed decisionmaking 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 crossfunctional teams to deliver highquality datadriven solutions.
This is a 40hour per week hybrid position with the benefit of working remotely and inperson coming into our headquarters office in Aurora CO and/or offsite locations.
Application deadline:Sunday April 20th at 11:59 PM (MST)
Requirements
Bachelors degree in a computerrelated or business studies field and three 3 years of related experience
Or Associates 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 TSQL including strong skills in optimizing query performance through indexing 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 decisionmaking. 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 nontechnical stakeholders
Ability to work effectively in a fastpaced 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)
Compensation & Benefits
$90000 $110000 annually
Health/dental/vision coverage
Employerpaid and supplemental life insurance
Short and longterm 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
Employerpaid training
You Belong! To learn more about our commitmentto inclusion and diversity visit our website:
Key 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
TSQL: 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 crossfunctional teams to understand business requirements and translate them into welldesigned datadriven 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 15000 individuals with disabilities and their families in Arapahoe Douglas and Elbert counties. We are a designated Case Management Agency (CMA) for longterm 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 values.
If you need an accommodation with this application process please contact
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.