The Data Warehouse Developer collaborates with CHFA’s BI team members to design, develop, and optimize data to ensure the delivery of high-quality, reliable solutions for various analytics purposes. The role enhances business effectiveness by creating and maintaining business intelligence (BI) solutions that leverage information across the enterprise, supporting a learning organization that values continuous improvement.
The person in this role must have exceptionally strong analytical skills and the ability to independently create BI solutions and be able to present information clearly and intuitively. This person must be able to work in a fast-paced, agile development environment and effectively engage with CHFA’s business community to deliver the best solution.
The successful candidate will be a self-starter, detail-oriented, and possess a learning mindset. They will have excellent communication skills, enabling them to effectively convey complex technical concepts to a diverse audience. Their growth mindset will drive them to embrace change and innovation, continuously learning and adapting to new technologies and methodologies. This role requires a proactive individual who can work independently and as part of a team and has a strong work ethic.
The Data Warehouse Developer will report to the IT Director and participate in all phases of BI development from technical concept and design, build, implementation, quality assurance and deployment.
what you will contribute:
A willingness to develop your skills and expertise while enhancing our mission-critical business intelligence solutions.
A desire to work with other talented, committed people.
A strong commitment to making a positive difference in communities across the state
An enthusiasm about developing and supporting great software
A sense of pride in creating new solutions with high quality
A capability to prioritizing your work to adhere to a deliverable schedule to ensure successful delivery
A strong eye for detail and quality of your code
An eagerness to dig into hard problems and an enjoyment of experimentation to come up with simple, elegant solutions.
essential functions
Manage and develop CHFA’s data warehouse solutions, including data ingestion from key source systems.
Develop, install, configure, deploy, and troubleshoot the reporting environment.
Develop logical and physical data models, ETL scripts, multidimensional semantic layer, metadata definitions, queries and reports, and maintenance procedures.
Understand, coordinate, and map changes to source systems as they impact the reporting environment.
Work with others to identify, create, and deliver reports according to requirements.
Uncovers business needs and opportunities through root cause analysis, shadowing, benchmarking, or use of other business analysis techniques.
Create models for new data warehouse development and/or changes to existing data stores.
Contribute to data warehouse improvement projects.
Identify inefficiencies and gaps in current data warehouses and leverage solutions to ensure data standards
Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.
Diagnose and resolve data warehouse access and performance issues.
Collaborate with our database administrators on data warehouse configuration and performance tuning.
Monitor system details within the data warehouse, including stored procedures and execution time, and implement efficiency improvements.
Follow CHFA’s change control and testing processes for modifications to systems.
Participate in data governance as a technical steward to ensure that key data, calculations, and metric definitions are documented and communicated.
Participate and contribute to activities and/or projects that directly support CHFA in fulfilling its mission and achieving its vision through dedication to the community CHFA serves, operational excellence, and fiscal responsibility.
Other duties as assigned.
key deliverables
Robust, sustainable architecture that supports CHFA’s analytics needs.
Functional, accurate, reliable, well-documented, and efficient analytic reporting environment
Evolving conceptual and logical models for the data warehouse or data mart to meet new and changing business requirements.
Reports and dashboards using reporting services and Tableau.
knowledge, skills, and ability
Understand BI theory and practicable tool architecture, functions, and features.
Understanding of source and target data structures, ETL processes, and products.
Willingness to learn business domain knowledge.
Exceptionally strong conceptual and analytic problem-solving skills translating business needs into technical solutions
Relational and multidimensional SQL database modeling, design, administration, and performance tuning.
Ability to develop in Wherescape RED.
Ability to develop in Alteryx.
Flexibility, diplomacy, and problem-solving.
Ability to effectively communicate with people at all levels within the organization as well as external product vendors.
Ability to operate with a sense of integrity.
Ability to have fun with a demonstrated sense of humor.
Ability to establish rapport with persons of diverse ethnic, racial, and cultural backgrounds.
Able to continuously improve and develop knowledge and skills, while adapting quickly to changing circumstances and processes.
Able to work towards inclusion in all activities, and decisions through the solicitation and appreciation of diverse perspectives.
Able to exercise personal accountability and integrity in all activities and decisions.
Able to embrace a culture of operational excellence to ensure processes are continually evaluated and improved as necessary.
Able to establish rapport with persons of diverse ethnic, racial, and cultural backgrounds.
Able to have fun with a demonstrated sense of humor.
experience/education
Bachelor’s Degree in Information Systems, Computer Science, or a related field a plus. Equivalent work experience may be substituted for degree requirements.
10+ years of experience in writing SQL statements.
6+ years of experience in the data warehouse space.
6+ years of experience with schema design and dimensional data modeling.
4+ years of experience in custom ETL design, implementation, maintenance
Proficient with BI Reporting tools, preferably Wherescape RED, Tableau and Alteryx
Demonstrated knowledge of Azure DevOps and version control systems
Proficient with Microsoft SQL Server Reporting Services (SSRS), including the ability to design, develop, and integrate data sources to support reports using SQL Server data sources.
Experience working in the financial services industry and knowledge of related business processes is preferred.
benefit information
Hybrid work CHFA understands the value of human relationships and operates as a face-to-face culture while offering remote work benefits.
Flexible Schedule
Culture of Wellness
We value diversity, equity and inclusion.
Comprehensive medical, dental, and vision insurance plans with very low rates
Generous Paid Time Off, including paid volunteer time, holidays, and other leave programs
401k match, educational assistance, and professional development opportunities
Up to a 5% match on 401(k) contributions
Up to 12 weeks of Paid Family and Medical Leave at 90% pay
An extensive Employee Assistance Program that provides personalized care options for your whole household
Ample opportunity to learn, develop and grow with opportunity for career and leadership development programs, job shadowing, a mentor program, and tuition reimbursement
Please visit our benefits page for additional information
physical environment
The incumbent in this position must reside in Colorado and will perform the essential functions of the position primarily in a hybrid which requires sitting at a desk for most of the day and must be able to act with or without reasonable accommodation. Ability to read, hear and speak. Ability to type and work on computers, with or without assisting devices. Ability to lift up to 10 pounds.