Match score not available

Integration Engineer- Public Trust Required

extra holidays - fully flexible
Remote: 
Full Remote
Contract: 
Experience: 
Mid-level (2-5 years)
Work from: 
District of Columbia (USA), United States

Offer summary

Qualifications:

BS Degree in computer science or related field, Minimum 3 years experience in relevant field, Hands-on expertise in Microsoft SQL Server and T-SQL, Experience with SSIS, ERWIN or similar tools, Ability to obtain VA Public Trust.

Key responsabilities:

  • Perform ETL processes for data transformations
  • Model data tables within data architecture
  • Design logical and physical schemas for enterprise
  • Write and optimize SQL queries
  • Create and enhance database architectures as needed
Initiate Government Solutions, LLC. logo
Initiate Government Solutions, LLC. SME https://www.initiatesolutions.com
51 - 200 Employees
See more Initiate Government Solutions, LLC. offers

Job description

Description

Founded in 2007, Initiate Government Solutions (IGS) a Woman Owned Small Business. We are an 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 customer's unique needs to achieve maximum value.


IGS is currently recruiting for a remote Integration Engineer 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 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
  • Create code with Microsoft Visual Studio, SQL Server Integration Services (SSIS), ERWIN or similar tools to automate, monitoring, design or data mapping functions
  • ETL, ELT processing to populate and test the new data models
  • Perform IRIS SQL commands to check system status
  • Monitor and perform tuning, optimize for performance
  • Load SQL tables (Historical Pulls) in all regions/districts for classes in all environments, making code adjustments as needed
Requirements
  • BS Degree: 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 to automate, monitoring, design or data mapping functions
  • Excellent oral and written communication skills
  • Excellent analytical and organization skills
  • Ability to obtain and maintain a VA Public Trust
  • Must be eligible to work in the United States without sponsorship due to clearance requirement

Preferred Qualifications and Core Competencies:

  • Active VA Public Trust
  • Experience with PowerShell or bash scripts and Azure Databricks
  • Prior, successful experience working in a remote environment

Successful IGS employees embody the following Core Values:

  • Integrity, Honesty and Ethics: We conduct our business with the highest level of ethics. Doing things like being accountable for mistakes, accepting helpful criticism, and following through on commitments to ourselves, each other, and our customers.
  • Empathy, Emotional Intelligence: How we interact with others including peers, colleagues, stakeholders, and customers matters. We take collective responsibility to create an environment where colleagues and customers feel valued, included, and respected. We work within a diverse, integrated, and collaborative team to drive towards accomplishing the larger mission. We conscientiously and meticulously learn about our customers’ and end-users’ business drivers and challenges to ensure solutions meet not only technical needs but also supports their mission.
  • Strong Work Ethic (Reliability, Dedication, Productivity): We are driven by a strong, self-motivated, and results-driven work ethic. We are reliable, accountable, proactive, and tenacious and will do what it takes to get the job done.
  • Life-Long Learner (Curious, Perspective, Goal Orientated): We challenge ourselves to continually learn and improve ourselves. We strive to be an expert in our field, continuously honing our craft, and finding solutions where others see problems.

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.

Required profile

Experience

Level of experience: Mid-level (2-5 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Analytical Skills
  • Adaptability
  • Problem Solving
  • Verbal Communication Skills
  • Detail Oriented
  • Organizational Skills

Integration Engineer Related jobs