Data Warehouse Developer, Business Intelligence Team

position

Data Warehouse Developer, Business Intelligence Team

division/department

Information Technology

position close date

May 3, 2024

classification

Exempt

nature of position

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.

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.

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

how to apply

Internal candidates: Please send your resume along with your internal job application to kkayhill@chfainfo.com

External candidates: Please submit your resume online at www.chfainfo.com/careers - Job Opportunities Tab

With respect to its programs, services, activities, and employment practices, Colorado Housing and Finance Authority prohibits unlawful discrimination against applicants or employees based on 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.