Lead SQL Data Modeling Software Engineer

Back to job search
  • Location:


  • Job type:


  • Job ref:


  • Published:

    21 days ago

  • Duration:

    12 months plus

  • Expiration date:


  • Start date:


Job Summary:

Signature Consultants is seeking a Lead SQL Data Modeling Software Engineer (Hybrid with 2 days a week in office) for an opportunity with a client located in Charlotte, NC.

Responsibilities, and Requirements:

  • 7+ years' experience with Microsoft SQL Server ( mandatory and no substitution of Oracle or other DBs)

  • 5+ years' experience with Data modeling and database design

  • 7+ years' experience in developing of DB objects like tables, views, complex stored procedures, and user defined functions

  • 5+ years' experience with performance tuning of SQL Queries

  • 3+ years' Agile development

  • Ability to troubleshoot data questions/discrepancies with little to no documentation

  • Design/analyze database schemas and optimize database design

  • Able to work independently

  • Strong T-SQL script creation, used in ad-hoc analysis and object creation

  • Design, develop, and test database objects (tables, views, stored procedures, indexes, functions, constraints) that are highly optimized

  • Ability to understand complex business processes and applications which read/write to various databases

  • Estimate development schedules and determine project scope

  • Create code that meets design specifications, follows standards, easy to maintain

  • Capable of identifying and proposing areas of improvement throughout the software development process

  • Use source control for the appropriate data objects

  • Work with other developers/business owners to achieve defined goals

  • Provide off-hours/flex support as needed

  • Provide guidance and mentoring in database marketing development best practices

  • Lead and participate in team planning, design, and review sessions

  • Mentor junior, mid, and senior level developers

Nice to have:

  • Experience with SQL Server Integration Services (SSIS)

  • Any ETL development or knowledge

About Signature Consultants

Signature Consultants, a Digital Intelligence Systems, LLC (DISYS) company, was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. Signature annually deploys thousands of consultants to support, run and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions and direct placement services. For more information on the company, please visit https://www.sigconsult.com.

EEO Employer

Signature Consultants is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Signature will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 888.838.1020.