SanDiegoRecruiter
the smart solution for San Diego jobs

BI Data Warehouse Architect

Location: Carlsbad
Posted on: March 18, 2019

Job Description:

SUMMARY
This Business Intelligence Data Warehouse Architect will be responsible for the design, implementation, and maintenance of the Data Warehouse ecosystem. This includes Extract Transform Load process’ using Data Modeling Tools, Oracle Database and MicroStrategy as the reporting tool.  Requires an experienced architect with a background in successfully implementing Data Warehouse solutions. Very knowledgeable in how the different systems intercommunicate architecturally with each other to be able support and enhance the current Business Intelligence systems.  The person will ensure that risks related to data management are identified and managed to internal policies. Looking for a great team player that can collaborate with internal and external Business Intelligence team members and with people in other Information Technology departments.
RESPONSIBILITIES
• Write technical Extract Transform Load documents.
 
• Monitor and Administer the Data Warehouse batches during critical implementations and maintenance windows to ensure the optimal operation of the system.
 
• Help in the on-call rotation to support the Business Intelligence applications 24/7.
 
• Ensure adherence to company standards and best practices for development activities.
 
• Design changes, provide solutions and manage additions to the Enterprise Data Warehouse and Data Marts using standard data modeling tools.
 
• Perform Oracle Structured Query Language (SQL) optimization on existing database queries.
 
• Identify database requirements by meeting with other Information Technology teams; analyze department applications, programming, and operations; evaluate existing systems and design proposed solutions.
 
QUALIFICATIONS
• 5-7 years of active senior practical experience in Business Intelligence and data management roles
 
• 7+ years of data integration experience
 
• 5+years of data modeling experience using industry standard tools (such as Erwin, ER/Studio, Visio or Enterprise Architect)
 
• 5+ years of experience in software development.
 
• 4+ years of experience with Oracle databases 10g and 11g,  SQL, PL/SQL and SQL for data manipulation and performance tuning
 
• 5+ years of experience with large, complex integrated data warehouse environments
 
• 3+ years developing and tuning Oracle SQL
 
• 5+ years of Business Intelligence implementations with Dimensional Data Models, integrating data from various sources and providing analytical reporting to business users using MicroStrategy or other BI tools
 

Keywords: , San Diego , BI Data Warehouse Architect, IT / Software / Systems , Carlsbad, California

Click here to apply!

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

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Senior Technical Program Manager
Description: BUSINESS UNIT: br br Cubic Transportation Systems br br COMPANY DETAILS: br br Cubic Transportation Systems: Cubic offers an opportunity to provide innovative technology for government and (more...)
Company: Cubic Corporation
Location: San Diego
Posted on: 03/25/2019

Web Applications Software Developer
Description: Imagine New Horizons... br br BIOVIA, a wholly owned subsidiary and brand of Dassault Syst mes is the leading scientific product lifecycle management software and services company. br Our customer (more...)
Company: Dassault Systemes
Location: San Diego
Posted on: 03/25/2019

Java/Oracle developer
Description: Description: Java Developer Java and Oracle DB Our Client is looking for a highly-experienced Java/J2EE and Oracle database developer with extensive hands-on experience designing and developing enterprise (more...)
Company: NewTelWire
Location: Pasadena
Posted on: 03/25/2019


Earn 800- 1000 Weekly. Will NEEDS PHONE and PC to START NOW
Description: We are a fast paced, highly motivated team working for a company that is ready to produce leaders. We have
Company: Jumpstart consult
Location: Moreno Valley
Posted on: 03/25/2019

Technical Support
Description: Ledgent Technology has an exciting opportunity for a service-focused Technical Support Analyst Ideal candidates will be comfortable providing phone support to non-technical end-users in a Windows-based (more...)
Company: Ledgent Technology
Location: Poway
Posted on: 03/25/2019

Principal Programmer
Description: Job Description: COMPANY SUMMARY: At Intercept, our mission is to build a healthier tomorrow for patients with progressive non-viral liver diseases. Intercept's lead product, Obeticholic Acid OCA , is (more...)
Company: Intercept Pharmaceuticals
Location: San Diego
Posted on: 03/25/2019

Need : Salesforce Technical Architect
Description: Salesforce Technical Architect California Initial 1 Year Contract Starting ASAP Job Information Minimum 5 years'' experience as a Salesforce
Company: JPC Techno Inc
Location: San Diego
Posted on: 03/25/2019

.Net Developer - TCI - San Diego
Description: Tax Compliance, Inc. develops market-leading state and local tax software solutions for corporations. PTMS property tax software helps minimize property taxes and expenses. LicenseHQ helps minimize the (more...)
Company: Corptax
Location: San Diego
Posted on: 03/24/2019

Entry Level Software Engineer (No Coding Experience Required
Description: Employer is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers.Our Software Engineers design, analyze and build next-gen (more...)
Company: Revature
Location: San Diego
Posted on: 03/25/2019

Senior Software Engineer - San Diego
Description: Responsibilities li Designs, develops, and tests innovative full-stack software and integration solutions using practices such as Continuous Integration, Continuous Delivery, TDD, and SOLID principles. (more...)
Company: USE Credit Union
Location: San Diego
Posted on: 03/25/2019

Log In or Create An Account

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

San Diego RSS job feeds