Database/Information Engineering Lead - Customer Value Partners, Inc

CVP seeks a Database/Information Engineering Lead to be responsible for all aspects of the design, development, and delivery of all data and database solutions. The professional in this role will support and maintain data and database systems to meet business delivery specifications and needs, be instrumental in designing, updating, and maintaining mission-critical systems, and provide guidance and support to all technical positions including system architects, developers, and database administrators. 

• Design, implement, and maintain complex databases, access methods, access time, device allocation, validation checks, protection and security, documentation, and statistical methods. 
• Design, create, maintain, and upgrade database architectures based on system requirements in a client/server environment, including data structures/architectures, database programming to support processes and data access methods. 
• Perform data cleaning and comparison analysis while maintaining detailed version histories of the data. 
• Complete statistical analysis of data, especially distribution. 
• Create and execute backup integrity checks and disaster recovery plans. 
• Enforce change management processes in each application environment. 
• Mask and replicate large data sets (for privacy and testing purposes) using enterprise tools. 
• Provide all activities related to the administration of computerized databases. 
• Project long-range database administration and design requirements with other managers in the information systems function. 
• Conduct quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data. 
• Apply knowledge and experience with database technologies, development methodologies, and front-end/back-end programming languages. 
• Maintain database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design. 
• Capture functional requirements and troubleshoot issues in cooperation with application developers. 
• Collaborate, guide, and mentor other DB engineers and team members. 
• Create and maintain database models for sophisticated development projects. 
• Create, modify, and maintain SQL code to create Extract, Transform, and Load (ETL) scripts. 
• Integrate information from existing and legacy, acquisition, and workforce databases, and spreadsheets into custom applications. 
• Provide technical direction and engineering support for projects and infrastructure, including data architecture, modeling, design, data management, data security, and system integration. 
• Support the development of an Enterprise Data Architecture for non-scientific data. 
• Utilize data modeling tools such as ER/Studio, Oracle SQL Developer Data Modeler, Erwin, or similar products. 

• Must be eligible to obtain a Public Trust clearance. 
• Bachelor's degree in computer science, Information Sciences, Cybersecurity, or related IT discipline.  
• Minimum of 10 years of professional experience in database development, day-to-day operational maintenance, and support. 
• Minimum of 10 years of professional experience working with SQL Server. Expert-level knowledge of relational databases and concepts. 
• Subject Matter Expert with SQL Server Database Administration; must be proficient with SQL Server technology. 
• Expertise with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), high-speed data transfers. Strong experience with DTS. 
• Extensive experience using XML within SQL procedures and functions. 
• Experience working in a web development environment. 
• Ability to translate business needs into long-term architecture solutions. 
• Proficiency in creating necessary technical documentation, configuration guides, and SOPs. 
• Ability to document database architectures for technical teams (detailed level), IT managers (architectural level), and customers (conceptual level). 
• Expertise in creating, updating, and maintaining stored procedures, performance analysis, and tuning of database code, SQL queries, and stored procedures. 
• Ability to create, update, and modify ERDs with appropriate PK and FK and their relationships to obtain a normalized database. 
• Skills in optimizing and redesigning databases. 

Desired Skills: 

• Experience with data modeling tools such as ER/Studio, Oracle SQL Developer Data Modeler, or Erwin. 
• Familiarity with Enterprise Data Architecture development. 
• Experience working with federal agencies or in government consulting environments. 

About CVP

CVP is an award-winning healthcare and next-gen technology and consulting services firm solving critical problems for healthcare, national security, and public sector clients. We help organizations achieve lasting transformation and build a healthy, safe, and equitable world—a future we call What’s Next. 

What do we do? We do work that matters like advancing mental and behavioral health, streamlining immigration, and improving access and outcomes for underserved populations including Veterans, people experiencing homelessness, and rural American residents.  

How do we do it? Our team of industry experts deliver integrated, innovative solutions in Healthcare Research & Technology, Digital Transformation, Data Science, Cybersecurity, Marketing Communications & Change Management, and Strategy & Transformation. 

Why do we do it? Our core values define the CVP culture, guide our decisions, and enable our client-focused mission. We’re relentlessly focused on making a difference and building What’s Next for our clients and their customers. 

We believe diversity, equity, and inclusion are essential components of our individual and collective success, and our commitment to hiring and supporting Veterans has earned us three HIRE Vets gold medallions. Join us to start or advance your career with a mission-focused firm transforming healthcare, enhancing security, and making government work better. 

Customer Value Partners, LLC is a VEVRAA Federal Contractor and an Affirmative Action and Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability. Customer Value Partners seeks to provide employment opportunities for protected veterans and individuals with disabilities.