ICF Consulting Group, Inc. DBA and Data Integration Engineer (Remote) in Des Moines, Iowa
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.
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.
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#.
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 (https://www.icf.com/legal/equal-employment-opportunity) .
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 email@example.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 (https://www.eeoc.gov/sites/default/files/migrated_files/employers/poster_screen_reader_optimized.pdf) and Pay Transparency Statement (https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_English_unformattedESQA508c.pdf) .
Virginia Remote Office (VA99)Need help? We're here:ICFCareerCenter@icf.com
ICF (NASDAQ:ICFI) is a global consulting services company with over 7,000 full and part-time employees, but we are not your typical consultants. At ICF, business analysts and policy specialists work together with digital strategists, data scientists and creatives. We combine unmatched industry expertise with cutting-edge engagement capabilities to help organizations solve their most complex challenges. Since 1969, public and private sector clients have worked with ICF to navigate change and shape the future. Learn more at icf.com.
ICF Consulting Group, Inc.
- ICF Consulting Group, Inc. Jobs