SQL Developer - Public Trust required

Initiate Government Solutions, Llc. - Washington, DC

Full-time - Mid Level

Remote - Washington, DC

Professional, Scientific, and Technical Services

About the position

Founded in 2007, Initiate Government Solutions (IGS) is a Woman Owned Small Business that operates as a fully remote IT services provider. We specialize in delivering innovative Enterprise IT and Health Services solutions across the federal sector, focusing on data analytics, health informatics, cloud migration, and the modernization of federal information systems. Our commitment to quality is reflected in our adherence to ISO 9001:2015, 20000-1:2018, 27001:2013, 28001:2007, CMMI/SVC3, and CMMI/DEV3 best practices, as well as PMBOK® methods. We tailor our range of IT services and delivery methodologies to meet the unique needs of our customers, ensuring they achieve maximum value from our solutions. Currently, we are seeking a remote SQL Developer to support our work with the Department of Veterans Affairs (VA). This position involves remote access to VA systems, utilizing approved VA communication systems. While travel is not a requirement, the candidate may need to attend onsite client meetings as requested. The SQL Developer will be responsible for various tasks including ETL (Extract, Transform, Load) processes to format data into various target formats, modeling data tables, designing logical and physical schemas for enterprise dimensional models, and evaluating commercial modeling tools. The role also includes writing SQL queries, developing data models, and ensuring compliance with VA security regulations. The SQL Developer will work closely with InterSystems HealthConnect and HealthShare tools, enhancing performance and scalability of data architectures as needed.

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 and documentation for that code, ensuring compliance with all VA security regulations.

Requirements

• Bachelor's degree in computer science, electronics engineering, or other engineering or technical discipline.
• Minimum 3 years of experience; additional relevant experience may be substituted for education.
• Hands-on expertise using Microsoft SQL Server, including daily use of T-SQL scripts.
• Experience with SQL Server Integration Services (SSIS), ERWIN or similar tools for automation, monitoring, design, or data mapping functions.
• Programming languages experience in C#, .NET libraries, ASP.NET, JavaScript with Libraries, Angular, jQuery, React, and Cache Object Script (COS).
• Excellent oral and written communication skills.
• Excellent analytical and organizational skills.
• Ability to obtain and maintain a VA Public Trust.
• Must be eligible to work in the United States without sponsorship due to clearance.

Nice-to-haves

• Active VA Public Trust.
• Experience with PowerShell or bash scripts and Azure Databricks.
• Experience with Microsoft Power Platform, especially Power BI.
• Prior successful experience working in a remote environment.

Benefits

• Profit sharing
• Paid training
• Disability insurance
• Health insurance
• Dental insurance
• Flexible spending account
• Tuition reimbursement
• Paid time off
• Vision insurance
• 401(k) matching
• Life insurance