Data Warehouse Developer, Business Intelligence Team
3 weeks ago
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
-
Business Intelligence Analyst
4 days ago
Denver, United States ZOLL Full timeData, ZOLLMED.com ZOLL Data Systems, a division of ZOLL Medical Corporation, is a healthcare software solutions provider that empowers hospital, EMS and Fire, and billing/accounts receivable (AR) teams to deliver more-from better patient outcomes to operational efficiencies and greater revenue capture. Our business exists to help save more lives through...
-
Business Intelligence Developer
2 weeks ago
Denver, United States Pursuit Collection Full timeWhat will be your daily pursuit? The Business Intelligence (BI) Developer performs analysis, design, development, and maintenance of BI solutions across multiple business lines and technical platforms. This role is essential in fostering data-driven decision-making across the organization by translating complex data into actionable insights. The ideal...
-
Business Intelligence Developer
1 week ago
Denver, United States Pursuit Collection Full timeWhat will be your daily pursuit? The Business Intelligence (BI) Developer performs analysis, design, development, and maintenance of BI solutions across multiple business lines and technical platforms. This role is essential in fostering data-driven decision-making across the organization by translating complex data into actionable insights. The ideal...
-
Denver, Colorado, United States Tipico - North America Full timeCompany 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...
-
Denver, Colorado, United States Tipico - North America Full timeCompany 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
3 weeks ago
Denver, United States Appcast Full timeJob 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 Analyst
1 week ago
Denver, United States Appcast Full timeJob 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
4 weeks ago
Denver, United States ACL Digital Full timePosition: 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
4 weeks ago
Denver, United States ACL Digital Full timePosition: 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
6 days ago
Denver, United States ACL Digital Full timePosition: 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
4 weeks ago
Denver, United States ACL Digital Full timePosition: 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
1 week ago
Denver, United States ACL Digital Full timePosition: 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
3 weeks ago
Denver, United States Linbar Solutions Full timeIf 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 Data Warehouse Architect
4 days ago
Denver, United States Imagine Communications Full timeOverview Every day, Imagine Communications is delivering billions of media moments all over the world — anywhere, anytime and on any device. Imagine Communications delivers innovative, end-to-end media software and networking solutions to over 3,000 customers in more than 185 countries, including the top broadcast facilities and the most technologically...
-
Senior Business Intelligence Developer
4 weeks ago
Denver, United States Aimic Inc Full timeTitle: 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
4 weeks ago
Denver, United States Aimic Inc Full timeTitle: 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
4 weeks ago
Denver, United States Aimic Inc Full timeTitle: 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
1 month ago
Denver, United States Barr Engineering Company Full timeJob 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...
-
Data Architect
1 week ago
Denver, United States Barr Engineering Company Full timeJob 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
3 weeks ago
Denver, United States Sia Partners Full timeSia 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...