Job Information
Colorado Housing & Finance Authoirty Data Warehouse Developer, Business Intelligence Team in Denver, Colorado
position Data Warehouse Developer, Business Intelligence Team
division/department Information Technology
position close date May 3, 2024
classification Exempt
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.
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 necessa y. 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