This site uses cookies. To find out more, see our Cookies Policy

SQL Database Developer in Troy, MI at VisionPRO

Date Posted: 5/24/2018

Job Snapshot

Job Description

SQL Lead Database Developer – Job 72506

Contract Details:

  • Direct Hire
  • Troy, MI (Local Candidates ONLY)
  • W2 ONLY (Corp-to-Corp/Sub-Contracting is Not Authorized)

Position Description:

  • The Lead Database Developer is responsible for designing and maintaining database solutions for new and existing applications. 
  • Additional responsibilities will include writing reports to extract, analyze, and create static and ad hoc reports for Managers and Senior Stakeholders, as well as developing SSIS packages for ETL and other miscellaneous purposes.
  • This is an enterprise role both maintaining and reporting on a variety of data, primarily Healthcare; however, it may include HR, Finance, etc.
  • Being a Lead, the Database Developer has expert knowledge of many of the systems and procedures used throughout the business. Moreover, the lead developer is good at mentoring his or her peers; particularly. those in a Regular or Junior Development positions, as well as establishing rules, standards, specifications, and nomenclature for the rest of the Junior, Mid-Level, and Senior Developers.
  • In addition, the Developer is highly proficient in creating and optimizing queries, creating complex SSIS projects, and writing comprehensive SSRS reports.
  • The Lead Database Developer has a vast background in the company’s databases, schemas, tables, stored procedures, and other objects contained within, and can quickly and easily locate the data elements as needed.
  • The Lead Database Developer is a well-rounded, motivated professional and solid team player, with solid relational and object-oriented database management experience and analytical ability. 
  • The Developer will have to periodically work directly with Executives and other Superiors, and be comfortable and confident in delegating tasks, as needed to the rest of the team.

Essential Duties and Responsibilities:

  • Provisions databases.
  • Designs and maintains database solutions for new and existing projects, by understanding the business requirements.
  • Develops and maintains database structures that utilize database architectural standards (normalized tables, primary keys, foreign keys, events, triggers, etc.).
  • Writes scripts to create, optimize, and maintain databases, tables, constraints, functions, stored procedures, indexes, and triggers.
  • Provides primary support for the organizations data repositories, and will be responsible for requested SQL reports.
  • Works with managers of each functional area, to identify and prioritize data information needs and requirements.
  • Creates clinical and financial reports to user specifications, using commonly available report writing tools and queries for SQL databases.
  • Identifies reporting requirements, and writes and optimizes complex SQL queries, stored procedures, and views to extract the information, trends, or patterns contained in the data.
  • Validates the results of SQL queries with end users, and presents the data in an intuitive and visually appealing way, which may include tables, pie charts, bar graphs, or other diagrams.
  • Assists with the import and export of data from third parties.
  • Supports and troubleshoots issues.
  • Mentors and supports Developers, at all levels of the Database Development team.

Required Knowledge, Skills, and Experience:

  • Strong SQL Database Development plus SSIS and SSRS skills are REQUIRED. (No DBA experience is required).
  • College Degree (or equivalent experience) in applicable technology.
  • 5+ years of experience using SQL Server (Development role), SSRS, and SSIS.
  • Analytic ability.
  • Working knowledge of SVN.
  • Strong communication skills.
  • Motivated and positive attitude.

Preferred Knowledge, Skills, and Experience:

  • Healthcare data and regulations.
  • GIT source code repository.
  • Jira.
  • Health Catalyst EDW.
  • QlikView.

VisionPRO relentlessly delivers top talent to help our clients excel. We have been trusted for 20 years to align the right talent to the right opportunity, expertly solving unique business challenges. From small businesses to the Fortune 500, our clients appreciate our consultative approach, resourcefulness, and fast response to their individual needs. Our prospective candidates and existing consultants can count on VisionPRO to passionately help them maximize their career choices, while also supporting their growth opportunities. We serve our customers from around the world, helping them with their most critical hiring decisions and project needs.