SanDiegoRecruiter Since 2001
the smart solution for San Diego jobs

BI Data Warehouse Architect

Location: Carlsbad
Posted on: January 14, 2021

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


Software Engineer - C++
Description: Major technology company is seeking a Software Engineer with 5 plus years of experience to design and develop C applications on Linux for sensor management and
Company: Volt
Location: San Diego
Posted on: 01/25/2021

Principal Software Engineer
Description: The Principal Software Engineer will work as a member of a large multi-functional hardware, software, electrical, mechanical R D team in our Respiratory Interventions business, in the software design (more...)
Company: Planet Pharma
Location: Carlsbad
Posted on: 01/25/2021

Principal Cloud Software DevSecOps Engineer
Description: LI POSTAS NGLinkedAS NGFeaturedJobsBasic Qualifications:Bachelor''s Degree in STEM and 5 years of related experience, or a Master''s in STEM and 3 years of experience, or a PhD in STEM with no experienceAt (more...)
Company: Northrop Grumman
Location: San Diego
Posted on: 01/25/2021


Developer
Description: Infosys is seeking an Apigee Developer. As an Apigee Developer, you will be a key player in the consulting team that helps discover and define the problem statement, evaluates the solution options and (more...)
Company: Infosys
Location: Long Beach
Posted on: 01/25/2021

Software Engineer - active TS/SCI clearance
Description: If you are a Software Engineer with TS/SCI clearance and 3 years experience, please read on HIRING FOR OUR PASADENA, CA LOCATION. We are a software engineering
Company: CyberCoders
Location: San Diego
Posted on: 01/25/2021

Cable Sales Agent
Description: POSITION OVERVIEW SALES AGENT The sales job of the year is now hiring We are looking for sales agent to support a national cable service provider. The calls are inbound, which means customers call you. (more...)
Company: MCI
Location: Imperial Beach
Posted on: 01/25/2021

Python/Selenium/Robot QA automation Engineer
Description: RESPONSIBILITIES: Kforce has a client that is seeking a Python/Selenium/Robot QA automation Engineer in San Diego, CA. Summary: The IT QA Automation Engineer is primarily responsible, under intermittent (more...)
Company: Kforce Technology
Location: San Diego
Posted on: 01/25/2021

Lead Youth Support Partner-849320
Description: Welcome to Pathways of California's career website If you are passionate about helping others and enthusiastic about your future, we want you to join our team Our company is known for an unwavering commitment (more...)
Company: Pathways
Location: San Diego
Posted on: 01/25/2021

Embedded Software Engineer
Description: Location: San Diego, CASalary: Excellent Description: Contractor - Embedded Engineer onsite in San Diego, CA. The length of this assignment
Company: The Judge Group
Location: San Diego
Posted on: 01/25/2021

Senior Software Engineer
Description: It's our mission to empower every person to improve their life through DNA. We believe DNA will be digitally accessible to each person so that it can be used-at any time-to improve health outcomes and (more...)
Company: Helix
Location: San Diego
Posted on: 01/25/2021

Log In or Create An Account

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

San Diego RSS job feeds