BEAR Data Solutions, Inc.  a global IT services provider with 11 offices throughout the U.S. and around the globe, helps enterprise clients design, optimize, maintain and support mission-critical IT infrastructures. By combining expert engineering resources, best-of-breed technologies, and superior customer service, BEAR Data delivers high-performance IT solutions and services including cloud, virtualization, unified communications, networking, storage, database, security, managed services, wireless, staffing, and support contract management

Title: Data Warehouse Developer

Job Location: El Segundo, CA

Job Description:

Our customer is seeking a Data Warehouse Developer with 5 years of experience in data warehousing (Star Schemas and Relational databases) in an Oracle environment


  • Perform Systems Analyst role for Data Warehousing projects including oversight for all technical activities
  • Provide thought leadership in data management strategies, governance, and design
  • Maintain, develop, and refine existing Data Architecture principles, policies and procedures based on future business needs
  • Support enterprise Data Integration competency and participate in defining and refining Informatica standards, data integration, data quality, ETL architecture, processes and tools
  • Assess the current state data warehouse environment and identify areas for improvement
  • Lead the design and implementation of the data warehouse improvement and growth projects
  • Plan and implement capacity and resource expansion to ensure data warehouse scalability
  • Ensure data warehouse designs support High Availability and Disaster Recovery capabilities
  • Develop and implement standard operating procedures for supporting the data warehouse
  • Conduct Performance tuning and optimization activities for the data warehouse environment
  • Develop and maintain EDW data models
  • Create Logical and Physical database design using Sybase PowerDesigner v12
  • Perform Unit Testing, Integration Testing and System Testing
  • Utilize UC4 Centralized Scheduling Tool for Job Schedule creation and/or modification
  • Adhere to Change Management Procedures and Policies
  • Attend Production Support meetings and contribute to the Support Knowledge Base


  • An associates or bachelor’s degree or equivalent experience/formal training program (Bachelor’s degree in IT or CS is preferred)
  • 6+ years of IT experience
  • 5+ years of experience in data warehousing (Star Schemas and Relational databases) in an Oracle environment
  • 5+Experience in using the Informatica Suite with Oracle
  • 5+ years of experience in data extraction design and development from a variety of sources, including AS/400, NT and UNIX
  • Experience in Data Modeling (preferably using Power Designer)
  • Experience in working in a shared architecture (shared memory/shared disk)
  • Experience in translating business requirements into technical specifications
  • Experience in emerging data warehouse appliances (IBM Netezza), real time, predictive analytics, data visualization, and Big Data solutions


  • Follows structured methodologies, modeling and governance principles
  • Advanced analytical and problem solving skills
  • Effective project management skills
  • Advanced written and verbal communication skills, including the ability to effectively communicate complex technical issues to a non-technical audience
  • Strong collaboration and mentoring skill
  • The ability to manage multiple priorities
  • Demonstrate advanced skills in the concepts and methods of ETL architectural analysis and design
  • 24X7 high availability environment

For more information, please visit us at

Please send resume to

Contact Us

Wounded Warrior Salute 2014

Date: Friday, October 17th, 2014 (9am - 7pm)
Location: 1757 Golf Club - Dulles, VA

More Information

CCISDA Fall Conference

Date: October 19th - 22nd, 2014
Location: Monterey Hyatt - Monterey, CA

More Information

The IT Summit Los Angeles

Date: October 22, 2014
Location: Hyatt Regency -Long Beach, CA

More Information

Webinar: Managed WiFi for Erate
with BEAR Data & Meraki

Date: Thursday, October 23, 2014 @ 1:00 pm Pacific
Location: Online

Meeting number: 629 512 549
Meeting password: erate

More Information

California Educational Technology Professionals Association Annual Conference

Date: November 18th - November 21st , 2014
Location: Sacramento Convention Center - Sacramento, CA

More Information