Mitchell International, Inc.

BI Developer – SQL Server

Job Location US-CA-San Diego
Job ID
17-7945
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

If you dream of being a full stack engineer, come practice the SOLID principals and learn to be a software craftsman!

 

What you’ll be doing:

 

The SQL Server Database/BI Developer will be responsible for the analysis, design, validation, and implementation of enterprise-wide SQL Server database development including data modeling, ETL, Performance tuning, SSIS, SSRS and SSAS development.

 

Duties and Responsibilities:

  • Follows policies and procedures for the definition, management, protection, and efficient utilization of data and databases.
  • Performs database development and management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.
  • Establishes database management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy.
  • Documents and communicates database design.
  • Evaluates and installs database management systems.
  • Codes complex programs and derives logical processes on technical platforms.
  • Builds windows, screens and reports.
  • Assists in the design of user interface and business application prototypes.
  • Participates in quality assurance and develops test application code in client server environment.
  • Provides expertise in devising, negotiating and defending the tables and fields provided in the database.
  • Adapts business requirements, developed by modeling/development staff and systems engineers, and develops the data, database specifications, and table and element attributes for an application.
  • At more experienced levels, helps to develop an understanding of client's original data and storage mechanisms.
  • Determines appropriateness of data for storage and optimum storage organization.
  • Determines how tables relate to each other and how fields interact within the tables for a relational model.
  • Stays apprised of changes and innovations in Microsoft SQL Server and/or Oracle’s information technology space, including new features, bug/fixes and compatibility concerns with operating systems and utilities.
  • Actively participates in the implementation of disaster recovery and fail-over capability, and maintains detailed technical support documentation.
  • Performs capacity monitoring; and short and long-term capacity planning in collaboration with development resources, system administrators and system architects.
  • Exploits RDMS software, database management tools and utilities, data warehouse and replication techniques to implement requirements to enhance our database solutions.
  • Maintains security commensurate with legal regulations, corporate policy, and best practices while implementing security solutions that balance auditor requirements with user requirements.
  • Participates in 24x7 on-call rotation

Qualifications

Qualifications:

  • Bachelor’s degree in Computer Science or Information Systems, or related equivalent experience and two plus year’s professional experience in database administration and software systems development.
  • A minimum of 5 years related I.T. experience.
  • Extensive technical knowledge and experience in database management techniques including physical database optimization, data distribution, database performance monitoring and data governance.
  • Comprehensive experience with MS SQL server, BI stack/methodologies and Dimensional modelling. 
  • Knowledge and awareness of networking issues pertaining to database design, optimization, and implementation within client server and web architecture.
  • Proficient in support duties such as performance tuning, monitoring, backup, recovery, and security.
  • Proficient with SQL, t-SQL (Microsoft).
  • Strong analytical and organizational skills, oral and written communications skills, problem solving and critical thinking skills.
  • Ability to meet deadlines and be flexible, work independently or as part of a team, and ability to self-motivate and be proactive.

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.