SQL Developer (Remote Opportunity)

Vetsez - Charleston, SC

Full-time - Mid Level

Remote - Charleston, SC

About the position

VetsEZ is currently seeking a SQL Developer to join a team to support a project with the Department of Veterans Affairs. This position will play a crucial role in the Data Migration & Syndication effort within the Electronic Health Record Modernization Integration Office (EHRM-IO). The ideal candidate must reside within the continental United States and will be responsible for various tasks related to data management and integration. The SQL Developer will engage in ETL (Extract, Transform, Load) processes to convert data into various target formats, including text, SQL, Parquet, CSV, MDF, and IRIS. The role involves modeling data tables to ensure they are practical and usable within the evolving data syndication database architecture. The developer will design both logical and physical schemas necessary to support an enterprise dimensional model and evaluate commercial modeling tools against internal offerings to determine the best fit and capabilities. Additionally, the developer will assess commercial data cataloging platforms for potential implementation and support deployment and change management efforts. A significant part of the role includes writing SQL queries, optimizing their performance, and developing and updating data models that align with applicable VA enterprise data standards. The SQL Developer will also create or enhance database architectures and designs to meet emerging data integration needs. Compliance with VA security regulations is paramount, and the developer will be responsible for delivering all code and documentation related to their work. Furthermore, the role may involve assisting with tools like InterSystems HealthConnect and HealthShare, focusing on data input and output in various forms. Enhancements to performance or scaling of data and users may require architectural design changes, which must be approved by the government Project Manager.

Responsibilities

• ETL (Extract Transform and Load) to put data into a variety of target formats (text, SQL, Parquet, CSV, MDF, IRIS).
• Model data tables and make them practical and usable within the evolving data syndication database architecture.
• Design the logical and physical schemas needed to support an enterprise dimensional model.
• Evaluate commercial modeling tools against internal offerings to determine the best fit and capabilities.
• Evaluate commercial data cataloging platforms with possible implementation.
• Support deployment and change management efforts.
• Provide input on customer access security models.
• Write SQL queries and optimize their performance; develop and update data models that support applicable VA enterprise data standards.
• Create or enhance database architectures and designs to meet data integration needs as they arise.
• Deliver all code, documentation for that code, compliant code that conforms to all VA security regulations, and written artifacts about the techniques and tools used in the code's production.
• Assist with work using InterSystems HealthConnect, HealthShare or similar tools with potential use of Software Document Architecture (SDA) mapping, terminologies, and other features to allow data to be both input and output in various forms.
• Enhance performance or enlarge or enhance the scale of data and/or users, with architectural design changes requiring clearance from the government Project Manager.

Requirements

• Bachelor's degree in Computer Science, Electronics Engineering, or other Engineering or technical discipline.
• 5+ years of experience using Microsoft SQL Server, including daily use of T-SQL scripts.
• Experience with SQL Server Integration Services (SSIS), ERWIN or similar tools to automate, monitor, design, or data mapping functions.
• Create database and file structures to include definitions of file characteristics, file layouts, data dictionary entries, and file indices for each subsystem.
• Develop new logical and physical data models to accommodate data storage and analysis needs of various data warehousing and analysis projects.
• Knowledge of database architecture, administration, and security for on-premise and cloud-hosted database systems.
• Communicate and lead effectively detailed technical discussions and develop and present required briefing materials to ensure the customer's needs are met.

Nice-to-haves

• Experience with Microsoft SQL Server, Oracle, Mongo, Azure Data Bricks, Varigence BimlStudio, Azure Data Lake, Azure Data Factory, Spark, etc.
• Experience in the VA or other federal organizations desired.
• Experience with Data Migration and Data Syndication within the VA desired.
• Ability to obtain a Government clearance.

Benefits

• Medical/Dental/Vision
• 401k with Employer Match
• PTO + Federal Holidays
• Corporate Laptop
• Training opportunities
• Remote Opportunity