ICF Consulting Group, Inc. Data Architect - Remote in Topeka, Kansas
We are open to supporting 100% remote work anywhere within the US.
ICF’s Digital Modernization Division is a rapidly growing, entrepreneurial, technology-driven department. Our team is a leading provider of Digital Transformation services for Federal agencies. Our services focus on enabling agency mission and business transformation using industry-leading low-code platforms, mobile applications, robotics process automation and data analytics platforms. We are partnered with some of the world’s leading and most innovative companies like Salesforce, ServiceNow, Microsoft and UiPath. We focus on offering a full range of architecture and planning, system implementation, integration, analytics and O&M for our customers.
We are seeking a Data Architect with hands-on Data Modeling and Database Design experience to work on a large, long-term IT modernization project supporting the USDA Forest Service.
What you’ll be doing:
Work with engineering teams across the technology organization, deliver the strategy through clear leadership/direction, influence and integration with agile development processes.
Responsible for designing, creating, documenting, deploying and managing the organization's data architecture
Responsible for developing strategies for database implementation and data storage, acquisition and recovery
Responsible for proposing and leading the implementation of data security solutions
Responsible for proposing and evaluating multiple design alternatives and recommending the most efficient and cost-effective solution
Must have hands-on skills in logical and physical data modeling, database management, data replication, data warehousing and ETL
Must have hands-on experience in relational databases, including Oracle and preferably PostgreSQL, and light mobile databases, such as SQLite
Must have experience in database optimization and SQL query tuning
Must have experience in 3-tier software architecture implementation, REST architectural style, SOAP protocol and HTTP, JSON and XML standards
Must have experience in NoSQL databases and document stores, such as ElasticSearch and MongoDB
What you must have:
7+ years experience developing data management solutions and strategy across a range of industry, client and technologies
2+ years experience working with AWS Aurora, RDS,PostGres, Oracle databases.
1+ year experience in database migration from Oracle to PostGres.
Must be able to obtain a Public Trust per federal contract requirement
What we’d like you to have:
Experience with PostGres, Oracle and SQL Light databases.
Experience with Cloud implementation or migration.
Expertise in MuleSoft (Any Point Studio development and troubleshooting)
Experience working with AWS connector to MuleSoft.
Experience in writing Feature Manipulation Engine (FME) workflows for large and complex geospatial and tabular datasets.
Experience in supporting mobile applications with AWS backend.
Deep knowledge in Data Integration, Data Quality, Metadata Management and understanding objectives.
Strong SQL knowledge for PostgreSQL and Oracle Databases.
Expertise in implementing transactional, Geospatial and dimensional model design patterns
Ability to prioritize and manage a complex & changing data infrastructure.
Experience developing data management strategies, policies, processes, and best practices.
Strong communication skills with excellent track record of working with agile teams.
Hands on experience with decomposing tightly coupled databases in to separate databases.
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.
We can only solve the world's toughest challenges by building an inclusive workplace that allows everyone to thrive. We are an equal opportunity employer, committed to hiring regardless of any protected characteristic, such as race, ethnicity, national origin, color, sex, gender identity/expression, sexual orientation, religion, age, disability status, or military/veteran status. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO & AA policy (https://www.icf.com/legal/equal-employment-opportunity) .
COVID-19 Policy: New or prospective U.S. employees must provide proof of complete vaccination on the date of their commencement of employment. If selected for employment, you will provide proof of your full vaccination status, defined as vaccinated two weeks after receiving the requisite number of doses of a COVID-19 vaccine approved or authorized for emergency use by the FDA.
Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, 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)