Share this Job

BI Data Warehouse Architect

Date: Dec 1, 2014

Location: Carlsbad, CA, US

Company: 24 Hour Fitness

Auto req ID: 11479BR
Job Title: BI Data Warehouse Architect
Area of Interest: Information Technology
Location Name: 90065 IT Applications Management
Address: 1265 Laurel Tree Lane Suite 200
City: Carlsbad
State: CA
Zip Code: 92011
Job Description: GENERAL SUMMARY: The BI DW Architect will be responsible for the design, implementation, and maintenance of the Data Warehouse ecosystem. This includes ETL process’ using Informatica PowerCenter, Data Modeling Tools, Oracle Database and MicroStrategy as the reporting tool. An experienced architect with background in successfully implementing DW solutions. Very knowledgeable in how the different systems intercommunicate architecturally with each other to be able support and enhance the current BI systems. The person will ensure that risk related to data management are identified and managed to internal policies. Looking for a great team player that can collaborate with internal and external BI team members and with people in other IT departments
ESSENTIAL DUTIES & RESPONSIBILITIES:
Drive the design, development and implementation of all ETL activities. 40%Design the best ETL implementation from a business requirementWrite technical ETL documentsWork with ETL developers to oversee and validate the development codeDevelop mappings, sessions, workflows in InformaticaProvide solutions from design of overall load process to development of mappings.Monitor and Administer the Informatica batches during critical implementations and maintenance Windows to ensure the optimal operation of the system.Help in the on-call rotation to support the BI applications 24/7Ensure project adherence to company standards and best practicesAnalyze existing mappings and processes on a regular basis, to identify opportunities for performance improvementDatabase and data modeling (Data Marts and EDW) 30%Design changes, provide solutions and manage additions to the EDW and Data Marts using standard data modeling toolsPerform SQL optimization on existing database queries.Identifies database requirements by meeting with other IT teams; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed solutionsCollaboration and Organizational Relationships 20%Work closely with BI Manager to understand tasks and prioritiesRegularly work with DBAs to ensure new implementations meet standardsBe a team player working and collaborating with Business Analysts and Developers to choose the right approach for implementation. Work with team members and manager to estimate efforts and plan activities.Peer review and code validation for ETL and DB implementationsParticipate in team exercises on improving overall BI performance.Documentation and Standards 10%Adhere to IT BI development standards and ensure the team follows them.Leverage personal technical experience in software development lifecycle to manage task assignment and appropriation of work effortCommit to project quality and on-time delivery Document mappings and processes to share among team members.REQUIRED QUALIFICATIONS:
1) Knowledge, skills & abilities:
5 or more years of data modeling experience using industry standard tools (such as Erwin, ER/Studio, Visio or Enterprise Architect)7+ years of active senior practical experience in Business Intelligence and data management roles7+ year of data integration experienceExperience tuning large scale Oracle Database installations including partitioned tables, materialized views and multi-dimensional table structures.3+ years developing Oracle SQL and very experienced writing and tuning Oracle SQL3+ years of experience developing PowerCenter mappings, sessions and workflowsExperience integrating 3rd party applications (like Python, Pearl, MicroStrategy) with Informatica PowerCenterExperience implementing FTP processes to transfer and receive data files from 3rd party vendors.Experience with Linux OS to design, implement, maintain and administer Informatica and MicroStrategy applicationsMust demonstrate self-initiative, a sense of urgency and innovation/creativity. Must demonstrate an ability to work in a team and maintain effective working relationships. Must demonstrate strong verbal and written communication skills. Must demonstrate ability to prioritize and manage multiple assignments and meet tight deadlines. Strong debugging, analytical and problem solving skills"Self-starter" attitude and the ability to make decisions independently
2) Minimum certifications/educational level:
Bachelor degree in information systems, technical field or equivalent required
3) Minimum experience:
Minimum of 5 years of experience in software developmentFour years of experience with Oracle databases 10g and 11g, SQL, PL/SQL and SQL performance tuning Good understanding of external scripting languages such as Python or Perl, and integration of scripts with InformaticaMinimum of 5 years of Business Intelligence implementations with Dimensional Data Models, integrating data from various sources and providing analytical reporting to business users.
4) Physical Requirements:
May work at a computer for extended periods of timeMay be required to work outside of typical business hours


Nearest Major Market: San Diego
Job Segment: Data Warehouse, Data Architect, Database, Business Intelligence, Oracle, Technology, Data