ICF Consulting Group, Inc. O365 & Data Integration Developer in Lansing, Michigan
This position will manage data integration activities between systems across the ICF enterprise and with external service providers. A successful candidate will provide technical expertise in developing integration solutions that efficiently transfer and transform data as necessary to meet business objectives. 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.
To be successful in this role, the candidate will need extensive knowledge of the Microsoft SQL Server environment and O365/SharePoint solutions.
Development and Implementation of solutions for Collaboration portals, Enterprise Content Management, Workflows and Enterprise Search.
Provide thought leadership on best practices for solution design with an understanding of Information Architecture functionality including site mapping, application integration, enterprise search, taxonomy, content classification and portal interaction on mobile platforms.
Exhibit an understanding of SharePoint hybrid architecture and have the ability to design, deploy and support solutions in a shared services hybrid architecture.
Elicit and analyze business processes and requirements from technical and non-technical teams and convert business requirements into system functionality within the O365 & .NET framework.
Utilize Service Oriented Architecture (SOA) design principles and common integration design patterns to gather requirements and design integrations between systems.
Develop integrations using T-SQL, SSIS packages, PowerShell, or other appropriate technologies. Responsible for SQL development and troubleshooting (stored procedures, functions, views, access, etc.).
Collaborate with team and gain consensus on standards and design integration strategies.
Manage interfaces and automated jobs to ensure efficiency and lead effort to migrate interfaces to current technologies.
Produce well-structured integration documentation to include narrative discussion on business process, data flow diagrams, data elements table, code with summary of main functions and control flow.
Design, develop, and implement comprehensive test and evaluation plans to ensure integrations perform efficiently and meet full requirements.
Lead requirements gathering, design, validation, configuration, implementation, testing, and debugging of solutions.
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.
B.S. in Computer Science or equivalent technical field required.
5+ years hands-on experience developing and implementing integration solutions.
5+ years hands-on experience in SharePoint Development and 2+ years of experience developing and implementing Office 365 based solutions.
Extensive experience working with SQL, Stored Procedures, data extraction, data transformation, and data loading.
Experience with Power platform and PowerShell.
Experience in Agile environment - Must be able to learn and apply new technologies quickly and work within a dynamic work environment.
Proficiency in developing search-driven solutions integrating Taxonomy Term Stores, custom content types with the ability to create custom result sources, refiners, and display templates.
Ability to adapt to new technologies.
Data integration experience with business systems such as Costpoint, Workday, Dynamics.
Experience implementing database security controls to properly manage access to the data.
Working knowledge of other related database technologies such as: Oracle, Azure SQL, Big Data, and with other programming languages like Python.
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.
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 firstname.lastname@example.org 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.