Mitchell International, Inc.

  • Data Warehouse Engineer 3-4

    Job Location US-CA-San Diego
    Job ID
    18-8625
    Type
    Regular Hire
  • Company Overview

    Mitchell International, Inc. is a leading provider of information and workflow solutions to the Property & Casualty Claims Industry and their supply chain partners. We solve interesting and complex problems that directly affect the customers our clients serve. We are constantly adapting to stay on the forefront of emerging technologies and we work diligently to maintain our position as a thought leader within our industry.

     

    Job Description

    The Data Warehouse Engineer 3-4 will have a shared responsibility for the successful implementation and integration of data warehouse and business intelligence solutions at Mitchell International.  Our ideal candidate is a talented individual who is a compulsive problem solver and who knows how to align business strategy with software development best practices.  Specifically, this position will work with the business owner, data scientists and report developers to deliver comprehensive data analytics solutions.  In this capacity you will be an expert in ETL practices and implementation. You will provide technical leadership and best practices in the design, development and deployment of the ETL solutions using Microsoft BI technology.

     

    Responsibilities:

    • Perform, and lead others in hands-on coding of data extraction, transformation and loading (ETL) according to BI/DW Industry best-practices.
    • Full life cycle development including analysis, design, development, testing and documentation including version control practices and technologies.
    • Responsible for implementing new data extracts, transformations, and load routines.
    • Work with external and internal customers to identify requirements for ETL processes, and designs and builds ETL tools for various data structures including data marts, data warehouses, flat files, and OLTP sources.
    • Design and build efficient SQL queries, analyzes query time comparison, and uses indexes efficiently.
    • Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.
    • Translate functional specifications into testing plans that capture detailed actions and automated scripts that test the application effectively.

    Qualifications

    • 5-8+ years experience in the software engineering field, with exposure to Data Warehouse Architecture.
    • Must have hands-on experience in Microsoft BI stack – MS SQL, SSIS, SSAS and SSRS.
    • 2+ years experience of software development in C# and testing experience in Microsoft technologies.
    • Deep knowledge and experience in dimensional and relational database structures, data representation, data cleaning techniques, data governance, and research database design.
    • College degree in computer science or related field. Masters is preferred.
    • Experience conducting research and design within agile development processes a plus.
    • A lifelong love of collaboration and learning.
    • A fearless and positive attitude.
    • Strong written and oral communication skills.

    Mitchell International, an equal opportunity employer, values the diversity of our workforce and the knowledge of our people.  Mitchell will not discriminate against an applicant or employee on the basis of race, color, religion, national origin, ancestry, sex/gender, age, physical or mental disability, military or veteran status, genetic information, sexual orientation, gender identity, gender expression, marital status, or any other characteristic protected by applicable federal, state or local law.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With Us!

    Not ready to apply? Connect with us via our Talent Pools.