Data Warehouse Developer, Business Intelligence Team

4 weeks ago

Denver, United States Colorado Housing & Finance Authoirty Full time

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

  • Data Developer – Business Analytics and Intelligence

    2 weeks ago

    Denver, Colorado, United States Tipico - North America Full time

    Company DescriptionFounded in Europe in 2004, Tipico is now a licensed U.S. Sportsbook operating in New Jersey, Iowa, Ohio, and Colorado. Renowned in Germany and globally, Tipico offers online betting across 30 sports. Guided by values such as innovation and inclusion, Tipico focuses on creating top-notch mobile sports betting and casino products. Recently...

  • Business Intelligence Analyst

    5 days ago

    Denver, United States Appcast Full time

    Job DescriptionThe Business Intelligence (BI) Analyst will be responsible for developing internal tools that allow for easier access and analysis of data. This position will have a quantitative background and will be responsible for creating and maintaining BI dashboarding tools. This role offers a premier opportunity to further develop a career in economics...

  • Business Intelligence Developer

    2 weeks ago

    Denver, United States ACL Digital Full time

    Position: Power Bi DeveloperLocation: Denver, CODuration: 12 monthsMust Have experience in ArcGISRequirements GatheringCollaborates with the business and with data analysts to understand requirements and business objectives for relevant reports & visualizations as well as underlying data model.Capable of identifying relevant data sources and attributes for...

  • Business Intelligence Developer

    2 weeks ago

    Denver, United States ACL Digital Full time

    Position: Power Bi DeveloperLocation: Denver, CODuration: 12 monthsMust Have experience in ArcGISRequirements GatheringCollaborates with the business and with data analysts to understand requirements and business objectives for relevant reports & visualizations as well as underlying data model.Capable of identifying relevant data sources and attributes for...

  • Business Intelligence Developer

    2 weeks ago

    Denver, United States ACL Digital Full time

    Position: Power Bi DeveloperLocation: Denver, CODuration: 12 monthsMust Have experience in ArcGISRequirements GatheringCollaborates with the business and with data analysts to understand requirements and business objectives for relevant reports & visualizations as well as underlying data model.Capable of identifying relevant data sources and attributes for...

  • Business Intelligence Specialist

    7 days ago

    Denver, United States Linbar Solutions Full time

    If you have interest in this position please send resume in word with contact number. # 3 Title: Business Intelligence Specialist (#11666766) Rate: DOE (Recruiter will discuss) Position Type: Contract Job Location: Denver, CO Duration: 6 months with possible extension Openings: 1 Client: State of Colorado Interview Type: Phone/Web with a possible In Person...

  • Senior Business Intelligence Developer

    2 weeks ago

    Denver, United States Aimic Inc Full time

    Title: Power BI DeveloperDuration: 12 Months Contract with an extensionLocation: Denver, Colorado 80203 (Hybrid) Ideally will have expertise in the following technical areas aspects:Requirements GatheringCollaborates with the business and with data analysts to understand requirements and business objectives for relevant reports & visualizations as well as...

  • Senior Business Intelligence Developer

    2 weeks ago

    Denver, United States Aimic Inc Full time

    Title: Power BI DeveloperDuration: 12 Months Contract with an extensionLocation: Denver, Colorado 80203 (Hybrid) Ideally will have expertise in the following technical areas aspects:Requirements GatheringCollaborates with the business and with data analysts to understand requirements and business objectives for relevant reports & visualizations as well as...

  • Senior Business Intelligence Developer

    2 weeks ago

    Denver, United States Aimic Inc Full time

    Title: Power BI DeveloperDuration: 12 Months Contract with an extensionLocation: Denver, Colorado 80203 (Hybrid) Ideally will have expertise in the following technical areas aspects:Requirements GatheringCollaborates with the business and with data analysts to understand requirements and business objectives for relevant reports & visualizations as well as...

  • Data Architect

    2 weeks ago

    Denver, United States Barr Engineering Company Full time

    Job Description: Summary: We are seeking a skilled and experienced data architect to join our dynamic team. The successful candidate will play a crucial role in architecting robust data solutions while also providing support to our Business Intelligence (BI) team in data source development. This is a unique opportunity to contribute to the design and...

  • Senior Data Developer-Contract

    1 week ago

    Denver, United States Sia Partners Full time

    Sia Partners is a next-generation management consulting firm. We offer a unique blend of AI and design capabilities, augmenting traditional consulting to deliver superior value to our clients. Counting 3,000 consultants in 20 countries, we expect to achieve USD 420 million in turnover for the current fiscal year. With a global footprint and expertise in more...

  • Senior Data Developer-Contract

    2 weeks ago

    Denver, United States Sia Partners Full time

    Sia Partners is a next-generation management consulting firm. We offer a unique blend of AI and design capabilities, augmenting traditional consulting to deliver superior value to our clients. Counting 3,000 consultants in 20 countries, we expect to achieve USD 420 million in turnover for the current fiscal year. With a global footprint and expertise in more...

  • Senior Data Developer-Contract

    2 weeks ago

    Denver, United States Sia Partners Full time

    Sia Partners is a next-generation management consulting firm. We offer a unique blend of AI and design capabilities, augmenting traditional consulting to deliver superior value to our clients. Counting 3,000 consultants in 20 countries, we expect to achieve USD 420 million in turnover for the current fiscal year. With a global footprint and expertise in more...

  • Senior Data Developer-Contract

    2 weeks ago

    Denver, United States Sia Partners Full time

    Sia Partners is a next-generation management consulting firm. We offer a unique blend of AI and design capabilities, augmenting traditional consulting to deliver superior value to our clients. Counting 3,000 consultants in 20 countries, we expect to achieve USD 420 million in turnover for the current fiscal year. With a global footprint and expertise in more...

  • Senior Data Developer-Contract

    2 weeks ago

    Denver, United States Sia Partners Full time

    Sia Partners is a next-generation management consulting firm. We offer a unique blend of AI and design capabilities, augmenting traditional consulting to deliver superior value to our clients. Counting 3,000 consultants in 20 countries, we expect to achieve USD 420 million in turnover for the current fiscal year. With a global footprint and expertise in more...

  • Data Integratrion Engineer

    4 weeks ago

    Denver, United States The Judge Group Full time

    Are you a skilled and passionate Data Integration Engineer looking to leverage your expertise in a dynamic and industry-leading organization?Our client seeks a talented Data Integration Engineer to join their team in Denver, CO. This role plays a critical role in supporting the data warehousing project, further enhancing reporting and analysis for informed...

  • Data Integratrion Engineer

    4 weeks ago

    Denver, United States The Judge Group Full time

    Are you a skilled and passionate Data Integration Engineer looking to leverage your expertise in a dynamic and industry-leading organization?Our client seeks a talented Data Integration Engineer to join their team in Denver, CO. This role plays a critical role in supporting the data warehousing project, further enhancing reporting and analysis for informed...

  • Data Warehouse Architect

    2 weeks ago

    Denver, United States Mindlance Full time

    s a Databricks Platform Engineer, your role involves performing Databricks Platform administration and deploying applications on the AWS Databricks platform. You'll handle administration, configuration, and optimization to support data analytics, machine learning, and data engineering activities. Collaborating with data engineers, data scientists, and...

  • Senior Data Integration Engineer

    4 days ago

    Denver, United States Northwood Hospitality Full time

    Firm Overview Northwood Investors LLC (“Northwood”) is a leading, privately held, global real estate private equity investment advisor that invests alongside institutional and private clients in a broad range of real estate opportunities, with $7 billion of equity capital currently under management. Northwood was founded in 2006, by John Z. Kukral, the...

  • Senior Director

    4 days ago

    Denver, United States AZDS Interactive Group Full time

    AZDS is the world’s premier digital agency that provides innovative marketing and technology solutions to the global leaders in the luxury travel and hospitality industry. We pride ourselves on our cutting-edge digital philosophy and portfolio of world-renowned clients – from Montage Hotels & Resorts to The Ritz London to Aspen Skiing Company and 650+...