Database Architect 4 in Lansing, MI at Fast Switch

Date Posted: 12/29/2019

Job Snapshot

Job Description

Job ID: 55442

Database Architect 4 - 55442

Job Overview:

  • The Department of Insurance and Financial Services’ (DIFS) is beginning its modernization efforts to replace its primary business application, OBase.  
  • This effort will require analysis of both the content and structure of the underlying Oracle database containing 600+ tables, modeling and design of a new Oracle or MS SQL Server database, and migration of existing data to the new database.
  • Candidate for this position must have excellent soft skills as this person will work closely with both the business and technical teams.

Job Description:

  • Support the modernization effort from a data perspective by working closely with both business and technical teams
  • Perform current state data model assessments/target data models and gap analysis
  • Analyze legacy database, including both data content and structure to derive necessary information
  • Define and analyze data requirements needed to support business processes
  • Counsel with Subject Matter Experts on specific topics in order to accurately capture existing business rules/principles
  • Establish data modeling naming standards, abbreviations, guidelines and best practices
  • Develop and maintain conceptual, physical and logical data models
  • Drive the data model review process and solicit user’s feedback
  • Propose new database architecture, support data migration from an existing Legacy system to a new structure

Skills Required:

  • Expert understanding of relational databases and proficiency in writing queries (SQL and PL/SQL)
  • Expert understanding of database design tradeoffs, impacts on user expectations and performance levels
  • Strong knowledge of data governance standards
  • Ability to develop data migration strategies for moving, duplicating, retiring data from legacy systems to new applications
  • Proven ability to establish a high level of trust and confidence in both the business and IT communities
  • Strong teamwork and interpersonal skills at all levels 
  • Proven influencing skills, strong collaboration, and mentoring capabilities
  • Ability to communicate effectively to all levels of the organization in a proactive, contextually appropriate manner
  • Strong organizational skills
  • Proven track record of achieving results in challenging environments

Experience Required:

  • 12+ years of experience in the Information Technology field as a developer, application architect, or database architect
  • 8+ years of experience with relational databases including Oracle and Microsoft SQL Server
  • 6+ years of experience with data analysis, modeling, and database design
  • 4+ years of experience in data modeling; including conceptual, logical and physical
  • Experience supporting a business from the data perspective with a strong business understanding
  • Experience building and validating data models
  • Experience in defining and enforcing data standards, procedures, and guidelines to ensure data integrity, dependability, quality and usability
  • Experience developing and publishing data architecture standards/guidelines governing data services, data security and privacy, and data integration

Experience Preferred:

  • 2+ years of experience in Agile/Scrum development environments
  • 2+ years of hands-on experience with data modelling tools

At Fast Switch, Our Purpose is Our People and Our Planet. We come to work each day and are reminded we are helping people find their success stories.  Isn’t that cool? Also, Doing the right thing is our mantra.  We act responsibly, give back to the communities we serve, and have a little fun along the way.

We at Fast Switch have been doing this for 22 years. We’re doing business in almost half the states in the union with offices in Detroit, MI, Columbus, OH, New York, Hartford, CT, Massachusetts, Minneapolis, MN, Los Angeles, CA, San Francisco, CA, and Tucson, AZ.

We're a financially strong, privately-held company that is 100% consultant and client focused.

We've differentiated ourselves by being fast, flexible, creative and honest. Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things, and we do them for Fortune 10 companies, Inc. 500 companies, and technology start-ups. We also have a strong belief in giving back to the communities we serve.

Our benefits are second to none and thanks to our flexible benefits options you can choose just the benefits that you need or want, options include:

• Medical and Dental (Fast Switch pays majority of the medical program)

• Vision

• Personal Time Off (PTO) Program

• Long Term Disability (100% paid)

• Life Insurance (100% paid)

• 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match

Plus, we have a lucrative employee referral program and an employee recognition culture.

In 2013, 2014, 2015, 2016, 2017 and 2018, Fast Switch was named one of the Top Work Places in Michigan by the Detroit Free Press and one of the Best Staffing Firms in 2016 and 2017. We have won the Columbus Business First “Fast 50” award 9 times in 12 years because of our strong growth which translates into more and better opportunities for our consulting staff members.

Ranked '#1' supplier by over 50% of our customers nationally.

Ranked 'Top 3' supplier by over 75% of our customers nationally.

 To view all of our open positions, please go to: www.fastswitch.com and at the bottom of the page click Job Portal, or get there directly at: https://www.jobs.net/jobs/fastswitch/en-us/all-jobs/

You can also follow us on Twitter at: www.twitter.com/fastswitch

And you can become a fan of Fast Switch on Facebook at: http://tinyurl.com/y9y3gdp