Jobs
>
Denver

    Data Warehouse Developer, Business Intelligence Team - Denver, United States - Colorado Housing & Finance Authoirty

    Colorado Housing & Finance Authoirty
    Colorado Housing & Finance Authoirty Denver, United States

    2 weeks ago

    Default job background
    Description
    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
  • DISH

    Software Engineering Manager

    3 weeks ago

    DISH Denver, United States Full time

    Company Summary · DISH, an EchoStar Company, has been reimagining the future of connectivity for more than 40 years. Our business reach spans satellite television service, live-streaming and on-demand programming, smart home installation services, mobile plans and products, and n ...

  • Matrix Innovations

    Logistics Clerk

    2 days ago

    Matrix Innovations The Plains, United States

    Logistics Clerk (m/f/d) · Unleash Your Talent in a World of Precious Metals. · For over 170 years, we have been known for intelligent and leading technologies in the field of precious metals. As a family-owned company, we have always stood for numerous innovations surrounding the ...

  • Tri-Force Consulting Services, Inc.

    Database Programmer/Analyst

    1 week ago

    Tri-Force Consulting Services, Inc. Denver, United States

    Title: Database Programmer/Analyst · Duration: 6 Months · Location: Denver, Colorado · Note: Hybrid role · "Candidate must be local" · Job description: · We are looking for a highly experienced Data Specialist with hands-on experience in SQL (ideally MS Sql Server/Google Big Que ...

  • Harrison Consulting Solutions

    Traffic/Technology Engineer

    2 weeks ago

    Harrison Consulting Solutions Denver, United States

    Multi-state design firm is seeking a Senior Traffic/Technology Engineer for their team in Denver, Colorado · Responsibilities: · Conduct citywide safety studies, signal timing, improving signal systems, and evaluating/designing Intelligent Transportation Systems (ITS) · Traffic ...

  • Tri-Force Consulting Services, Inc.

    Power BI Developer

    1 week ago

    Tri-Force Consulting Services, Inc. Denver, United States

    Title: Power BI Developer · Duration: 12 Months · Location: Denver, Colorado · Note: Hybrid role · "Candidate must be within 50 miles" · Job description: · OIT is seeking a skilled Power BI Developer to assist with our BI Program. Ideally, will have expertise in the following te ...

  • FASTENER DISTRIBUTION HOLDINGS LLC.

    Buyer I

    2 weeks ago

    FASTENER DISTRIBUTION HOLDINGS LLC. Commerce, United States

    **FDH Aero **is a trusted global supply chain partner for aerospace and defense companies. With more than 55 years of experience, it specializes in c-class components that include hardware, electrical, chemical, and consumable products and services for global OEM and aftermarket ...

  • AltaMed

    Healthcare Business Analyst

    1 week ago

    AltaMed Commerce, United States

    Under the direction of the Director, the Business Analyst, Cultural & Linguistic is responsible for managing and coordinating analysis projects that support AltaMed's Cultural & Linguistic Department strategic initiatives. · **Minimum Requirements** · - Bachelor's Degree in Publi ...

  • Infinity Technologies

    Master / Technician (m/f/d) Facility Management

    2 days ago

    Infinity Technologies Wheat Ridge, United States

    As a transmission network operator, we ensure the power supply for 11 million people - and ensure the success of the energy transition. Around 1,300 employees make our region ready for the future with a dynamic, intelligent network and make Baden-Württemberg an innovative hub for ...

  • Endocrinology Consultants, PC

    Part Time Receptionist/secretary

    3 weeks ago

    Endocrinology Consultants, PC Englewood, United States Part time

    Physician group seeking part time receptionist with some experience. We are a professional team seeking an intelligent, self motivated team player. We are looking for someone who prides him/herself in talk completion, prioritizing, organizational ability, as well as having excell ...

  • Endocrinology Consultants, PC

    Medical Receptionist/secretary

    2 weeks ago

    Endocrinology Consultants, PC Englewood, United States

    Physician Group seeks Full Time Secretary with some experience. We are a professional team seeking an intelligent, self motivated team player. We are looking for someone who prides him/herself in task completion, prioritizing, organizational ability, as well has having excellent ...

  • DISH

    Wireless Voice of the Customer Insights Specialist

    1 week ago

    DISH Englewood, United States Full time

    Company Summary · DISH, an EchoStar Company, has been reimagining the future of connectivity for more than 40 years. Our business reach spans satellite television service, live-streaming and on-demand programming, smart home installation services, mobile plans and products, and n ...

  • DISH

    Voice of the Customer Insights Specialist

    4 days ago

    DISH Englewood, United States Full time

    Company Summary · DISH, an EchoStar Company, has been reimagining the future of connectivity for more than 40 years. Our business reach spans satellite television service, live-streaming and on-demand programming, smart home installation services, mobile plans and products, and n ...

  • DISH

    Senior Financial Analyst

    1 week ago

    DISH Englewood, United States Full time

    Company Summary · DISH, an EchoStar Company, has been reimagining the future of connectivity for more than 40 years. Our business reach spans satellite television service, live-streaming and on-demand programming, smart home installation services, mobile plans and products, and n ...

  • MSD

    Director Estimating, Global Engineering Solutions

    2 weeks ago

    MSD West Point, United States

    The Global Engineering Solutions (GES) Director of Estimating is a key position in the Project Business & Solutions (PBS) team whose function is to provide effective and innovative cost solutions to our business partners to maximize their value and for our teams to ensure success ...

  • BluePath Labs

    Data Scientist

    1 week ago

    BluePath Labs West Point, United States

    Data Scientist (DS) and Machine Learning (ML) Researcher - ONSITE · **Location: Army Cyber Institute, West Point, NY 10996** · **Responsibilities**: · - Assist in the writing of scholarly manuscripts, research projects, white papers, and proposals. · - Make positive scholarly con ...

  • Aurora Technologies

    Technical caretaker

    3 weeks ago

    Aurora Technologies Englewood, United States

    TECHNICAL CARETAKER (M/F/D) WELCOME TO CAVERION · Are you passionate about intelligent and sustainable building technology and ensuring it for the leading engine manufacturer MTU Aero Engines? Do you want to pioneer and create a healthy working environment in the first Immune Off ...

  • RadNet

    Patient Service Representative

    2 weeks ago

    RadNet Westminster, United States

    Overview: · Artificial Intelligence; Advanced Technology; The very best in patient care. With decades of expertise, we are _Leading Radiology Forward_. With dynamic cross-training and advancement opportunities in a team-focused environment, the core of our success is its people w ...

  • Englewood ENT

    Medical Receptionist/medical Assistant

    3 days ago

    Englewood ENT Englewood, United States

    **Medical Receptionist/Medical Assistant** · **We are hiring immediately** · We are seeking Full Time/ Part Time Medical Receptionist with a minimum of 2 years experience. We are a professional practice seeking an intelligent, self-motivated, team player who can multi-task · Duti ...

  • Annie Kinsley - State Farm Agent

    Life/health Insurance Position

    3 weeks ago

    Annie Kinsley - State Farm Agent Aurora, United States

    **ROLE DESCRIPTION**: · Annie Kinsley - State Farm Agent is seeking a qualified and empathetic professional for the role of Life/Health Insurance Position - State Farm Agent Team Member. As a customer-oriented expert, you will market the best Life/Health insurance services and pr ...

  • ATMI PRECAST

    Project Manager

    2 weeks ago

    ATMI PRECAST Aurora, United States

    : · **ATMI Precast,** a leading Midwest manufacturer and builder of major precast concrete structures, is seeking a Project Manager to manage and expedite projects ensuring that technical, quality, cost, schedule and customer requirements are met or exceeded. · **The ATMI Project ...