RanchoCucamongaRecruiter Since 2001
the smart solution for Rancho Cucamonga jobs

ETL Architect

Company: Apex Systems
Location: Rancho Cucamonga
Posted on: March 28, 2020

Job Description:

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 departments 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. 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 throughputaccessibility 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 Experience Minimum of ten (10) years of related experience required. Education Bachelor's degree. Licenses, Certifications, Registrations NA. 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 BIDW 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 playerleader 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. EEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservicesapexsystemsinc.com or 844-463-6178.

Keywords: Apex Systems, Rancho Cucamonga , ETL Architect, Professions , Rancho Cucamonga, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Professions Jobs


Recent Grad CDL-A Truck Driver - Refrigerated, Safest in Trucking!
Description: Recent CDL-A Grads: Don't have enough experience to get the truck driving job you want No worries, come join us You will spend 165 hours behind the wheel with a C.R. England
Company: C.R. England
Location: Rowland Heights
Posted on: 04/6/2020

Refrigerated Truck Driver CDL-A Recent Grads - Deliver Food, Medicine,
Description: Recent CDL-A Grads: Don't have enough experience to get the truck driving job you want No worries, come join us You will spend 165 hours behind the wheel with a C.R. England
Company: C.R. England
Location: Glendora
Posted on: 04/6/2020

Production Supervisor
Description: br Who is Georgia-Pacific Watch to find out br br Eligible for a 5,000 Sign on Bonus br br Georgia-Pacific is currently hiring for a Converting Production Supervisor at La Mirada, CA Corrugated (more...)
Company: Georgia-Pacific
Location: La Mirada
Posted on: 04/6/2020


Refrigerated Truck Driver CDL-A Recent Grads - Deliver Food, Medicine,
Description: Recent CDL-A Grads: Don't have enough experience to get the truck driving job you want No worries, come join us You will spend 165 hours behind the wheel with a C.R. England
Company: C.R. England
Location: San Gabriel
Posted on: 04/6/2020

Grocery Delivery Service Driver
Description: FULL-SERVICE SHOPPERWhy shop and deliver with Instacart Instacart is the North American leader in grocery delivery. We strive to help make grocery delivery effortless, affordable, and accessible to everyone. (more...)
Company: Instacart
Location: Placentia
Posted on: 04/6/2020

Recent Grad CDL-A Truck Driver - Refrigerated, Safest in Trucking!
Description: Recent CDL-A Grads: Don't have enough experience to get the truck driving job you want No worries, come join us You will spend 165 hours behind the wheel with a C.R. England
Company: C.R. England
Location: La Mirada
Posted on: 04/6/2020

Drain Service Technician
Description: Drain Service Technician Roto-Rooter is hiring drain service technicians. People with good communication skills and a mechanical aptitude will thrive in this job. First year Roto-Rooter service technicians (more...)
Company: Roto Rooter
Location: Paramount
Posted on: 04/6/2020

Capital Assets Analyst
Description: Job Description br br Energy for whats ahead. br Are you looking to make a difference in your career Were working on smarter grids, cleaner energy and tools to help people manage energy more efficiently. (more...)
Company: Southern California Edison
Location: Rosemead
Posted on: 04/6/2020

Driving Post - Security Officer
Description: Job DescriptionJOB SNAPSHOT br br GardaWorld Security Services is currently hiring Security officers are considered to be a part of the essential services field keeping everything together during (more...)
Company: GardaWorld
Location: Rosemead
Posted on: 04/6/2020

Shopper - Delivery Driver (Car Required)
Description: FULL-SERVICE SHOPPERWhy shop and deliver with Instacart Instacart is the North American leader in grocery delivery. We strive to help make grocery delivery effortless, affordable, and accessible to everyone. (more...)
Company: Instacart
Location: Placentia
Posted on: 04/6/2020

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Rancho Cucamonga RSS job feeds