Lead Data Architect

MS SQL Server
Full Time
Depends on Experience

Job Description

Location: Dallas, Texas

Job Summary:
The Lead Data Architect is responsible for applying skills in a dynamic work environment while developing well-rounded competencies in our client's products and services. The Lead Data Architect is a data expert who helps establish database design, development, and maintenance standards as well as data systems governance. As a member of the Product Development team, the Lead Data Architect will serve as a hands-on data architect and help Scrum teams with the design and development of our client's databases and data storage. The position exposes individuals to the complete Secure Software Development Life Cycle.
1.0 Primary Duties & Responsibilities
Specific duties and responsibilities include:

  • Work with teams to gather and analyze technical requirements
  • Architect efficient and modern data storage solutions for all OLTP and OLAP systems
  • Review existing data structures and objects, and provide Azure-based solutions for modernizing applications
  • Work with software architects, senior developers, and DBAs to implement modern, best in class solutions
  • Develop detailed specifications and documentation for proposed solutions
  • Train and coach team members on Data Architecture Standards and guidelines
  • Hands-on development and design database objects, such as tables, stored procedures, functions, proof of concepts, etc.
  • Visit and engage clients (end users) in order to gather requirements and gain an understanding of development requests and communicate proposed solutions
  • Research and develop new ways and modern technologies to improve existing functionality
  • Proactively analyze and bring forth ideas for continuous improvement
  • Mentor other team members and review their work as necessary
  • Model an environment of strong collaboration and teamwork
  • Support and participate in the organization’s Continual Improvement Program to conform to ISO 9001 and ISO 27001 requirements by complying with the Quality Policy procedures and meeting QMS and ISMS objectives
  • All employees have a professional duty to provide any information related to security issues, incidents, or situations that present a potential security risk to the ISO Team, Management, or their Supervisor
  • Other tasks and projects as directed by management

2.0 Requirements 2.1 Education and Training 

  • Bachelor’s degree in Computer Science or related field from an accredited university
  • 10+ years of hands-on experience in Microsoft SQL Server database development and administration roles, with 2 or more of these years in a data architecture role
  • Microsoft Azure data-related certifications are a plus

2.2 Knowledge and Skills 

  • 10+ years of hands-on experience in Microsoft SQL Server database development and administration roles, with 2+ years in a data architecture role
  • 10+ years extensive knowledge of entire SQL Server product
  • 10+ years extensive knowledge of T-SQL; writing complex queries, stored procedures, functions, performance tuning, and optimization of SQL code
  • 3+ years of experience using Microsoft SSIS and/or Azure Data Factory
  • 2+ years of experience designing and implementing ETL and ELT solutions
  • Extensive knowledge and experience with data tools such as SQL Profiler, Extended Events, and SQL Trace
  • Strong experience with SQL Replication and clustering
  • Expert knowledge of performance use and maintaining SQL Server Indexes
  • Extensive knowledge of database modeling and design
  • Extensive knowledge of data warehouse schema design 
  • Extensive knowledge of SQL Server Internals
  • Strong experience with data warehouse implementation and governance
  • Experience using Microsoft Azure PaaS services and functions
  • Strong experience with Microsoft SQL BI / Analysis Services
  • Strong experience with data warehouse technologies such as Azure Synapse
  • Strong experience with working with semi-structured data such as XML, JSON, etc.
  • Strong experience with NoSQL data storage such as Azure Cosmos DB (minimum 1+ years)
  • Strong experience with Microsoft Azure Cloud (minimum 3+ years)
  • Experience with Azure Data Lake and/or Azure Databricks is a plus
  • Knowledge of C# or other development language is a plus
  • Broad knowledge of Microsoft Development stack
  • Proven ability to lead projects, as well as be able to work in a team environment
  • Recognized quality work from previous projects
  • Demonstrated personal initiative and leadership skills
  • Solid analytical and problem-solving ability
  • Desire to assume increasing levels of leadership responsibility
  • Ability to work on multiple tasks simultaneously
  • Excellent verbal and written communication skills
  • Strong organizational skills and attention to detail
  • Ability to work well in a fast-paced environment


For more information on this job visit: https://vc5consulting.com/

VC5 Consulting has been named by business journals as one of the best places to work.
We offer benefits such as weekly pay, health insurance, 401k, and even profit sharing to our consultants.



Dice Id : 10480055
Position Id : 7185
Originally Posted : 2 months ago
Have a Job? Post it

Similar Positions

QA Architect
  • VC5 Consulting
  • Dallas, TX, USA
Big Data Architect
  • Judge Group, Inc.
  • Plano, TX, USA
Data Architect
  • GM Financial
  • Arlington, TX, USA
Lead Azure Data Engineer/Platform Architect
  • Kani Solutions
  • Plano, TX, USA
Data Architect Lead/ Manager
  • ConnectedX, Inc.
  • Plano, TX, USA
Data Lead / Architect - moving to Azure
  • RedRiver Systems L.L.C.
  • Fort Worth, TX, USA
Big Data Lead (Fulltime)
  • Judge Group, Inc.
  • Irving, TX, USA
Lead Data Scientist
  • Radiansys, Inc.
  • Irving, TX, USA
Remote: Lead Cloud Architect
  • Jobot
  • Dallas, TX, USA