Veterans EZ Info Inc
SQL Developer (Remote Opportunity)
Veterans EZ Info Inc, Washington, District of Columbia, us, 20022
VetsEZ is currently seeking a SQL Developer to join a team to support a project with the Department of Veterans Affairs. The position will support the Data Migration & Syndication effort within the Electronic Health Record Modernization Integration Office (EHRM-IO).
The candidate must reside within the continental US.
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 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 the performance of queries; develop and update data models that support applicable VA enterprise data standards and the ability for VA to adopt emerging industry 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 codes production.
Shall 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 to enlarge or enhance the scale of data and/or users, architectural design changes may be required but must be cleared with 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, monitoring, 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.
Additional Qualifications:
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.
Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, or protected veteran status.
Sorry, we are unable to offer sponsorship at this time.
#J-18808-Ljbffr
The candidate must reside within the continental US.
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 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 the performance of queries; develop and update data models that support applicable VA enterprise data standards and the ability for VA to adopt emerging industry 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 codes production.
Shall 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 to enlarge or enhance the scale of data and/or users, architectural design changes may be required but must be cleared with 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, monitoring, 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.
Additional Qualifications:
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.
Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, or protected veteran status.
Sorry, we are unable to offer sponsorship at this time.
#J-18808-Ljbffr