10 days old
2018-08-092018-09-06

Data Warehouse Manager

Gardena, CA 90247
  • Job Code
    638410
  • Payrate
    $150,000 To $155,000
job summary:

The Data Warehouse manager will manage daily activities and responsible for Design, Implementation, maintenance and support of Enterprise Data Warehouse system. Gather and analyze business requirements, Architect /Design Data Warehouse Infrastructure and solutions. Design process flow diagram and prototypes and effectively communicate design ideas. Engage with product, business and senior management to improve technical design aligned to business/operations tactical and strategic needs.

 
location: Gardena, California
job type: Permanent
salary: $150,000 - 155,000 per year
work hours: 9 to 5
education: Bachelors
 
responsibilities:

Responsibilities & Duties

  • Lead a small team of engineers to design, and deliver high-quality 24x7 production level Data Warehouse system.
  • Establish SDLC, and engineering processes within the team and department through collaboration with Scrum Master, and leadership.
  • Improve architecture and reduce technical debts through active leadership in design, and project planning.
  • Create application architecture diagrams and support technical development in designing, testing and implementing application changes.
  • Lead team to build custom data-driven frameworks and solutions, and leverage off-the-shelf data products and tools.
  • Enforces established documentation guidelines and best practices.
  • Maintains a high degree of business functional knowledge and current automated technologies and tools.
  • Adheres to all policies and procedures concerning all confidential information including but not limited to internal use and restricted information.
 
qualifications:

Job Qualifications/Requirements

  • 10+ years working experience with Data Integration, ETL, Data Warehouse, BI, and Data Management.
  • 5+ years in DWH/Bi experience with fluency in modeling and designing Relational DBs, Star Schemas, and cubes (Kimball), SQL, Schema development, Stored procedures, Triggers and related database programming technologies
  • Experience with Data Vault methodologies is a huge plus.
  • Must have experience building data warehouse in cloud specifically in AZURE Cloud.
  • Experience with enterprise level relational database like Oracle, DB2, MySQL, MS-SQL, PostgeSQL etc.
  • Solid experience with logical and physical database schema design.
  • Ability to communicate and translate technical strategy to non-technical business leaders and senior management.
  • Hands-on experience with both relational and dimensional databases
  • Experience in managing project timelines and prioritize work.
  • Strong customer service focus.
  • Experience in both Agile and Waterfall methodology.
  • Experience with tools like JIRA, ServiceNow.
  • Minimum Education Level: Bachelor's Degree
  • Combination of Experience and Education can meet the job requirements: Yes
 
skills: Job Qualifications/Requirements

  • 10+ years working experience with Data Integration, ETL, Data Warehouse, BI, and Data Management.
  • 5+ years in DWH/Bi experience with fluency in modeling and designing Relational DBs, Star Schemas, and cubes (Kimball), SQL, Schema development, Stored procedures, Triggers and related database programming technologies
  • Experience with Data Vault methodologies is a huge plus.
  • Must have experience building data warehouse in cloud specifically in AZURE Cloud.
  • Experience with enterprise level relational database like Oracle, DB2, MySQL, MS-SQL, PostgeSQL etc.
  • Solid experience with logical and physical database schema design.
  • Ability to communicate and translate technical strategy to non-technical business leaders and senior management.
  • Hands-on experience with both relational and dimensional databases
  • Experience in managing project timelines and prioritize work.
  • Strong customer service focus.
  • Experience in both Agile and Waterfall methodology.
  • Experience with tools like JIRA, ServiceNow.
  • Minimum Education Level: Bachelor's Degree
  • Combination of Experience and Education can meet the job requirements: Yes

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

Categories

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Warehouse Manager

Randstad Technologies
Gardena, CA 90247

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast