Principal Database Engineer
Mitchell International – Greater San Diego Area
Job Description
Our Principal Database Engineer will be focused on multiple data sources within our Auto Physical Damage Division. You will serve in a lead role in consolidating the data and then design a new warehouse using Microsoft. You will also serve as a lead on a small team in delivering Business Intelligence as well as provide your expertise in redesigning /reengineering warehouse.
Summary:
- As a Principal Database Engineer you will act as a Senior Data warehouse Architect and hands-on development lead, mainly responsible for:
- Leading and managing ateam of offshore team members.
- Strategically design andimplement data warehouses, data marts, and data stores, while ensuring high levels of data availability.
- Enhance, develop, and promote standards and good practices around data, reporting, and BI
- Define policies,procedures, and governance for the data warehouse that is aligned with theoverall IT strategy.
- Perform role of counselor and coach; provide mentoring, input and guidance to the team.
- To conceptualize, designand assist in the implementation of new and existing DW and BI systems,middleware and production architectures
- Identify and promote best practices and patterns for data modeling, and provide oversight for allactivities related to data cleansing, data quality and data consolidation using standard data modeling methodologies and processes
- Provide technical recommendations for optimized data access and retention for the data warehouse
Desired Skills & Experience
Qualifications (knowledge, skills, abilities):
- 8+ years’ experience using SQL Server 2005/2008. Highly desirable – Microsoft Certified Technology Specialists (MCTS) on SQL Server 2005/2008 certification.
- Must possess a strong understanding of Microsoft SQL Reporting Services, SQL Server Analytic Services, SQL Server Integration Services, MDX and performance point server. Must know how to create, deploy and manage reports
- 5+ year’s hands-on experience in Business Intelligence and Decision Support systems.
- 6+ years’ expertise in building data warehouse using top-down or bottom-up approach using snow-flake or star schemas as well as extensive knowledge of OLTP/OLAP technologies.
- Experience in defining and analyzing SQL Server replication strategies
- Expertise in stored procedure programming, data modeling, replication, performance monitoring and optimization.
- Expert-level knowledge of SQL and ETL tools like Informatica and Ab-Initio is nice to have
- Experience in Insurance Services is a plus.
Personal Attributes:
- Exceptional analytical, conceptual, and problem-solving abilities.
- Strong written, presentation and oral communication skills
- Strong ability to gather and analyze report requirements and translate into technical solutions
- Strong project management skills and track record of meeting project deadlines
- Ability to conduct research into database issues, standards and products as required. .
- Ability to effectively prioritize, multi-task and execute tasks in a high-pressure environment.
- Experience working in a team-oriented, collaborative environment and willingness to mentor the team.
- Be willing to work off hours and weekends, and make available for deployments or emergency during non-business hours.
Experience:Typically requires a minimum of 9+ years of related experience. At this level, post-graduate coursework may be expected.
Education: 4-year degree in Computer Science, Information Systems or related technical discipline. Certification in Oracle and MS-SQL Server is a big plus
Written Abilities: Must have excellent verbal and written communication skills and the ability to work independently.
Company Description
Mitchell International, Inc. is a leading provider of information and workflow solutions to the Property & Casualty Claims and Automotive Collision Repair industries. Founded in 1946, Mitchell has delivered advanced information and technology solutions to over 100,000 customers throughout North America, helping them to improve their business process performance. The company’s comprehensive solution portfolio streamlines the entire auto physical damage, bodily injury and workers’ compensation claims processes. Mitchell was recently named by the San Diego Business Journal as the No. 1 Software Company in San Diego, based on the number of full-time employees, which is approaching the 2,000 milestone. The company offers a competitive compensation and benefits package including outstanding career growth opportunities and has been recognized as one of the Fastest Growing Companies in San Diego. Mitchell International, an equal opportunity employer, values the diversity of our work force and the knowledge of our people.
Mitchell International
Additional Information
- Posted:
- July 16, 2012
- Type:
- Full-time
- Experience:
- Mid-Senior level
- Functions:
- Information Technology
- Industries:
- Computer Software
- Employer Job ID:
- 12-0135
- Job ID:
- 3047858