FountainValleyRecruiter Since 2001
the smart solution for Fountain Valley jobs

Data Warehouse Architect No C2C

Company: Mantek Solutions Inc
Location: Fountain Valley
Posted on: May 4, 2020

Job Description:

6194 No Remote No Corp to Corp No Sponsorship No third party candidates considered for this position Our Client in the Fountain Valley, CA area is seeking a Data Warehouse Architect for a Full Time position. As part of the Business IntelligenceData Warehouse team, the Enterprise Data Warehouse (EDW) Architect is responsible for guiding the overall building and maturing of the EDW, with special focus on understanding business reporting and data analysis needs and creating flexible, scalable and efficient data models to support them. Working collaboratively with IS management and business partners, the EDW Architect will understand internal business processes and obtain detailed knowledge of the underlying data subject areas and data structures, working to create an environment where data is integrated, harmonized and easy to use and understand. Responsibilities Capture and analyze business requirements for the EDW. Design and develop data warehouse architecture, data models and integrations. Document relationships between entities. Architect physical data models, including normalized 3NF integration layers and denormalized dimensional presentation layers. Identify enhancements to existing models. Design and develop complex ETL processes. Refine and create Agile stories in support of the data architecture and development. Create and maintain procedures and supporting documentation in support of the DW environment and policies. Qualifications Minimum Bachelor's degree in a business or technical field (information systems, business administration, computer science.) 8 or more years of experience in a traditional data or analytics corporate environment. 8 or more years and proven understanding of Data Warehouse, BI, and Business Analysis techniques. Expertise in SQL and in data modelling, including dimensional data models. Expertise in ETL and data integration concepts and tools (Informatica and SSIS preferred.) Experience in hybrid architectures leveraging traditional RDBMS (Teradata preferred) and Hadoop (Cloudera preferred.) Understanding of reporting tools (Tableau, Business Objects.) Understanding of ScrumAgile methodology. Able to rapidly learn new processessubject areas. Experience in Cloud environments is a plus. Knowledge of Snowflake an additional plus. Property and Casualty Insurance experience preferred. Strong communication, presentation and relationship management skills. Benefits Health Coverage for Medical, Dental, Vision Paid time off including Vacation, Illness and Holidays Life Insurance Disability Coverage Pension 401k Savings Plan Employee Discounts If qualified and interested in this opportunity, please reply to JO6194 with current resume and salary rate requirements.

Keywords: Mantek Solutions Inc, Fountain Valley , Data Warehouse Architect No C2C, Other , Fountain Valley, California

Click here to apply!

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

I'm looking for
in category
within


Other Other Jobs


Assistant Salon Manager - Santee Village Square
Description: Assistant Salon Manager Got shears and a winning attitude Have a yearning to earn and a desire to support other stylists Then let s talk Maybe you re a stylist who wants
Company: Great Clips
Location: Santee
Posted on: 05/29/2020

IS Training Lead
Description: Purpose Statement / Position Summary br br MemorialCare's IS trainers are responsible for developing the knowledge and skills of our workforce. They ensure that our workforce can meet its current (more...)
Company: MemorialCare Health System
Location: Fountain Valley
Posted on: 05/29/2020

Registration Representative, Full Time OP Breast Center
Description: Essential Functions and Responsibilities of the Job br br ul br li Ability to communicate effectively in written and verbal form li Adheres to department policy of using two patient identifiers. (more...)
Company: Orange Coast Memorial Medical Center
Location: Fountain Valley
Posted on: 05/29/2020


Assistant Salon Manager - Balboa Mesa Shopping Center
Description: Assistant Salon Manager Got shears and a winning attitude Have a yearning to earn and a desire to support other stylists Then let s talk Maybe you re a stylist who wants
Company: Great Clips
Location: Poway
Posted on: 05/29/2020

Assistant Salon Manager - Encinitas Village
Description: Assistant Salon Manager Got shears and a winning attitude Have a yearning to earn and a desire to support other stylists Then let s talk Maybe you re a stylist who wants
Company: Great Clips
Location: Encinitas
Posted on: 05/29/2020

Assistant Salon Manager - Plaza De Las Flores
Description: Assistant Salon Manager Got shears and a winning attitude Have a yearning to earn and a desire to support other stylists Then let s talk Maybe you re a stylist who wants
Company: Great Clips
Location: Lake Forest
Posted on: 05/29/2020

Portfolio Associate - Multi-Asset
Description: About Us: We are PIMCO, a leading global asset management firm. We manage investments and develop solutions across the full spectrum of asset classes, strategies and vehicles: fixed income, equities, (more...)
Company: PIMCO
Location: Newport Beach
Posted on: 05/29/2020

Work From Home
Description: Growing 26 year old National Discount Health Benefits provider of healthcare access in the US is seeking bright, motivated people enjoy helping
Company: Living Healthy
Location: Palm Springs
Posted on: 05/29/2020

Food Store Delivery (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: Santee
Posted on: 05/29/2020

Assistant Salon Manager - Plaza De Las Flores
Description: Assistant Salon Manager Got shears and a winning attitude Have a yearning to earn and a desire to support other stylists Then let s talk Maybe you re a stylist who wants
Company: Great Clips
Location: Rancho Santa Margarita
Posted on: 05/29/2020

Log In or Create An Account

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

Fountain Valley RSS job feeds