BI ETL Architect Solution Consulting Cnslt/Spec

We are seeking an energetic and accomplished individual for our Business Intelligence (BI) ETL Architect position with a strong technology and solution delivery acumen who will be accountable for the successful design, development, and delivery of business intelligence solutions within Kaiser Colorado BI Team. This position will be responsible for driving the overall design and determining the ETL architecture necessary for the BI team to develop and implement large complex projects. This position will consult with development teams and works closely with business, developers, architects, project management, business analysts, and QA areas across all of BI to deliver on KPCO strategies, capabilities, and processes. The scope of the BI ETL Architect role involves all aspects of the project life cycle from inception to implementation and support. This role takes a lead in the department's vision and implementation of the KP Colorado BI program. The BI ETL Architect will drive the development of best practices for KP and mentor developers, analysts and other members of the BI team.
Essential Functions:
Works with business partners, product development teams and senior designers to capture requirements, determine a solution that will integrate with existing BI assets, review prototypes and develop iterative revisions. Responsible for leading the design of prototypes and determining final design to ensure client satisfaction with product.
Conduct impact assessment with business in order and determine high level design and size of effort based on requirements.
Lead and guide an Informatica based ETL architecture to handle complex business rules while balancing the fulfillment of stringent performance requirements.
Drive design and determine the ETL requirements for BI projects.
Partners with ETL Lead and supports ETL Lead and ETL developers through the development of complex ETL routines to load a dimensional star schema (and supporting layers) and develops error handling processes
Perform an active, leading role in shaping and enhancing overall ETL Informatica architecture, including ETL standards, patterns and best practices. Work with team to ensure standards and patterns are followed.
Determines organizational strategies for data integrity validation processes. Establishes policies and best practices for optimizing ETL data throughput/accessibility
Identifies opportunities for new architectural initiatives; makes recommendations on the increasing scalability and robustness of ETL platforms and solutions.
Partner with the Data architect to drive improvements and enhancements to the current data landscape and future strategy
Partner with Leadership team to ensure the successful delivery of projects
Remain current on new ETL techniques and methodologies and communicate trends and opportunities to management and other developers as needed. Identify opportunities for uses of those technologies to enhance current or anticipated information systems and business goals needs
Support ETL developers by providing technical assistance, troubleshooting and alternative development solutions.
Playing a key role in mentoring other staff members and a proven track record in knowledge transfer to other team members and departments
Evaluates existing applications that could address client requirements & makes recommendations from complex projects.
Identifies alternative uses of technologies that will enhance current or anticipated information systems & that support overall corporate & business goals that are appropriately aligned with the enterprise architecture.
Identifies necessary changes to current business process.
Identifies opportunities for solution sharing & reuse.
Assists in the development of ETL-related Service Level Agreements.
Communicates risks & ensures understanding of these risks.
This job description is not all encompassing.
Basic Qualifications:
Minimum of ten (10) years of related experience required.
Bachelor's degree.
Licenses, Certifications, Registrations
Additional Requirements:
10 years experience in modeling and business system designs
8 years hands on experience in Informatica ETL development
5 years of Oracle (or comparable database) experience with BI/DW deployments
Must have proven experience with STAR and SNOWFLAKE schema techniques
Proven track record as an ETL Architect, leading development teams to deliver successful business intelligence solutions with complex data sources.
Strong analytical skills and enjoys solving complex technical problems
Ability to manage and make decisions about competing priorities and resources.
Ability to delegate where appropriate.
Candidate must be a strong team player/leader
Strong oral written and interpersonal skills for interacting and throughout all levels of the organization; ability to clearly communicate complex business problems and technical solutions.
Preferred Qualifications:
Master's degree preferred.
Healthcare experience
Agile development methodology background

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.