Be on Alert – Fraudulent Employment Offers. Learn More

Fairfax, Virginia, United States of America
JOB #R2100590

DBA and Data Integration Engineer (Remote)

This position is responsible for working and maintaining databases, as well as developing and maintaining system integrations and components, including but not limited to application to application integrations, internal and external API, file transfer, etc. This is a position within the Corporate IT team and requires excellent organizational skills and the ability to collaborate effectively across all levels of the organization.

Duties and Responsibilities:

  • Design, implement, and manage database systems, and ensure their availability, stability, reliability, and performance.

  • Design and develop integrations using SSIS packages, PowerShell, T-SQL, PL/SQL, or other appropriate technologies.

  • Participate in requirements sessions with the stakeholders and convert functional requirements into technical solutions, along with supporting materials such as use cases, designs, flowcharts, models, specifications, and reports.

  • Ensure the data quality and integrity in databases, as well as compliance of standards and conventions in developing programs.

  • Troubleshoot and resolve complex issues, including root cause analysis along with recommending and implementing preventive techniques.

  • Manage interfaces and automated jobs to ensure efficiency and lead effort to migrate interfaces to current technologies.

  • Design, develop, and implement comprehensive test and evaluation plans to ensure integrations perform efficiently and meet full requirements.

  • Provide and maintain technical documentation for new system processes or enhancements.

  • Partner with business users to provide guidance and support as necessary to help drive best practices to meet their integration needs.

  • Confidently present possible solutions to audiences of various sizes and technical knowledge levels weighing pros and cons.

  • Work with the Information Security team to ensure security standards are included, applied and maintained across all product sets within the domain.

  • Be part of an on-call rotation to support mission-critical production database systems.

Required Qualifications:

  • B.S. in information technology/computer science.

  • 5+ years of experience with SQL Server administration and support.

  • 5+ years hands-on experience developing and implementing integration solutions.

  • Extensive experience working with SQL, Stored Procedures, data extraction, data transformation, and data loading.

  • Good experience with PowerShell and SSIS packages.

  • Experience in SQL Server database development and troubleshooting, including typical database installation and configuration, as well as implementing database security controls to properly manage access to the data.

  • Experience in Agile environment - Must be able to learn and apply new technologies quickly and work within a dynamic work environment.

Preferred Skills/Experience: 

  • Data integration experience with business systems such as Costpoint, Workday, Dynamics, OneStream, and Hyperion.

  • Experience with Azure DevOps, Visual Studio, TFS or VSO.

  • Working knowledge of other related database technologies such as: Oracle, Azure SQL, Big Data, Azure Data Factory, Azure Synapse, and with other programming languages like Python and/or C#.

Professional Skills: 

  • Excellent written and verbal communication skills.

  • Work well independently as well as part of a team.

  • Strong analytical and problem-solving skills.

  • Self-starter with ability to work efficiently with minimal direction or guidance.

  • Data, and with other programming languages like Python and/or C#.

Working at ICF

Working at ICF means applying a passion for meaningful work with intellectual rigor to help solve the leading issues of our day. Smart, compassionate, innovative, committed, ICF employees tackle unprecedented challenges to benefit people, businesses, and governments around the globe. We believe in collaboration, mutual respect, open communication, and opportunity for growth. If you’re seeking to make a difference in the world, visit www.icf.com/careers to find your next career. ICF—together for tomorrow.

ICF is an equal opportunity employer that values diversity at all levels. (EOE – Minorities/Females/ Protected Veterans Status/Disability Status/Sexual Orientation/Gender Identity). For more information, please read our EEO & AA policy.

Reasonable Accommodations are available for disabled veterans and applicants with disabilities in all phases of the application and employment process. To request an accommodation please email icfcareercenter@icf.com and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more about non-discrimination:  EEO is the law and  Pay Transparency Statement.

Virginia Remote Office (VA99)

Who is ICF?

A global consulting services company with +7,000 people across +70 countries, but we are not your typical consultants.
LEARN MORE ABOUT ICF

More jobs you might like

Mar 4, 2021
Fairfax, Virginia, United States of America
Jan 12, 2021
Washington, District of Columbia, United States of America
Dec 18, 2020
Trenton, New Jersey, United States of America
See All Jobs

Join our talent network

ICF is growing, and we add new open roles to our site regularly. If you're waiting for that perfect opportunity at ICF or want an inside look at what it's like to do world-changing work, join our talent network to stay updated.

Join our talent network

ICF is growing, and we add new open roles to our site regularly. If you're waiting for that perfect opportunity at ICF or want an inside look at what it's like to do world-changing work, join our talent network to stay updated.