What are the responsibilities and job description for the SQL Developer - Public Trust required position at Initiate Government Solutions?
Founded in 2007, Initiate Government Solutions (IGS) a Woman Owned Small Business. We are a fully remote IT services provider that delivers innovative Enterprise IT and Health Services solutions across the federal sector. Our focus is on data analytics, health informatics, cloud migration, and the modernization of federal information systems.
IGS uses ISO 9001 : 2015, 20000-1 : 2018, 27001 : 2013, 28001 : 2007, CMMI / SVC3, CMMI / DEV3 best practices, and PMBOK® methods to provide clients with a strategy to build solid foundations to grow capabilities and revenue. Our range of IT services and delivery methodologies are tailored to our customers' unique needs to achieve maximum value.
IGS is currently recruiting for a remote SQL Developer to support our work with the Department of Veterans Affairs (VA).
Assignment of Work and Travel :
This is a remote access assignment. Candidate will work remotely daily and will remotely access VA systems and therein use approved VA provided communications systems. Travel is not required; however, the candidate may be required to attend onsite client meetings as requested.
Responsibilities and Duties (Included but not limited to) :
- 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
Preferred Qualifications and Core Competencies :
Successful IGS employees embody the following Core Values :
Compensation : There are a host of factors that can influence final salary, including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications.
Initiate Government Solutions offers competitive compensation and a robust benefits package, including comprehensive medical, dental, and vision care, matching 401K and profit sharing, paid time off, training time for personal development, flexible spending accounts, employer-paid life insurance, employer-paid short and long term disability coverage, an education assistance program with potential merit increases for obtaining a work-related certification, employee recognition, and referral programs, spot bonuses, and other benefits that help provide financial protection for the employee and their family.
Initiate Government Solutions participates in the Electronic Employment Verification Program.
Initiate Government Solutions is an equal opportunity employer. Our company policy is to provide equal opportunity in all areas of employment practice without regard to race, color, religion, sex, sexual orientation, national origin, age, marital status, veteran status, citizenship, or disability.