Data Warehouse Developer (Business Intelligence Team) Save

Our mission

We strengthen Colorado by investing in affordable housing and community development.

Our Vision

Everyone in Colorado will have the opportunity for housing stability and economic prosperity.

Nature of Position

Do you dream about creating an impact in our state and making Colorado a better place to live and work?

The CHFA team works together throughout Colorado to Increase the availability of affordable, decent, and accessible housing for lower income Coloradans; and strengthen the state's economy by providing financial assistance to businesses.

Over the past 50 years, CHFA has invested more than $35 billion into Colorado’s economy. These resources have helped:

• 153,043 Colorado homebuyers achieve homeownership.
• 197,896 households attend homebuyer education classes held statewide;
• 82,597 affordable rental housing units be developed or preserved; and
• 8,945 businesses access capital to support 88,340 jobs.

We are a mission-based organization, enabling us to put our values into action by working to achieve our vision that everyone in Colorado will have the opportunity for housing stability and economic prosperity.

When joining CHFA, you can expect to work for an organization with:

• A leadership team that strives to make this the best place you've ever worked.
• A focus on supporting our employees' mental, physical, and financial well-being.
• A commitment to diversity, equity, and inclusion.
• A highly engaged workforce devoted to innovation, continuous improvement, and collaboration.
• A reputation for excellence, as evidenced by ranking 15^th nationally in the Small and Medium-sized category in the 2023 Fortune Best Workplaces in Financial Services & Insurance™.

What you get to do:

We are looking for two Data Warehouse Developers to join our business intelligence team. You’ll work with a talented group of people to design flexible, adaptable, easy to use business intelligence (BI) solutions that meet the demands of CHFA’s changing business needs. 

The Data Warehouse Developer collaborates with members of CHFA’s BI team 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 ability to independently create BI solutions and be able to present information in a clear and intuitive way.   This person must have the ability to work in a fast-paced, agile development environment and be able to 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 as well 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, 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 document and communicate key data, calculations, and metric definitions.
• 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 in which 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.

Equipment used

Telephone, personal computer, calculator, photocopier, vehicle, audio/visual equipment, fax machine, and smartphone.

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.

The incumbent selected for this position can choose their on-site work frequency.  However, employees must live in Colorado.

Validation statement

This job description is a general description of essential job functions. It is not intended as an employment contract, nor is it intended to describe all duties someone in this position may perform.

Hiring range

$107,360 - $161,040

Benefit information

• Hybrid work - CHFA understands the value of human relationships and operates as a face-to-face culture while also offering the benefit of remote work.
• 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

Division/department

Information Technology

Position close date

May 3, 2024

Classification

Exempt

With respect to its programs, services, activities, and employment practices, Colorado Housing and Finance Authority prohibits unlawful discrimination against applicants or employees on the basis of age 40 years and over, race, sex, sexual orientation, gender identity, gender expression, color, religion, national origin, disability, military status, genetic information, marital status or any other status protected by applicable federal, state or local law. Requests for reasonable accommodation, the provision of auxiliary aids, or any complaints alleging violation of this nondiscrimination policy should be directed to the nondiscrimination coordinator, 1.800.877.2432, TDD/TTY  303.297.7305, CHFA 1981 Blake Street, Denver CO 80202-1272, available weekdays 8:00 a.m. to 5:00 p.m.