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!
Other IT / Software / Systems JobsSoftware 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 |