ICF Consulting Group, Inc. Data Engineer- Remote in Topeka, Kansas
Preference for candidates in MST or CST
About ICF International
The ICF International (NASDAQ:ICFI) Commercial Energy Division partners with commercial energy clients to deliver professional services and technology solutions related to energy management and energy efficiency programs. The firm combines passion for its work with industry expertise and innovative analytics to produce compelling results throughout the entire program life cycle, from research and analysis through implementation and improvement. Since 1969, ICF has been serving government at all levels, major corporations, and multilateral institutions. More than 3,500 employees serve these clients worldwide. ICF's Web site is www.icfi.com.
Job Description:This is a cross functional position with significant responsibility and opportunity to shape the future direction of our team. The selected candidate will work to design, monitor and optimize SQL servers on daily basis. In addition to that, candidate will be required to focus on data development tasks like coding in T-SQL to collect, store, validate and process large datasets.
This position will be part of a small analytical team working on quantitative software products and services so experience working in a product development environment is desired. Successful candidates will be very analytical with a high attention to detail in a quantitative environment to ensure a stable, repeatable, and accurate production data stream. Successful candidates will also enjoy an independent work environment where they can take a high level of ownership of their accomplishments.
Develop reports as well as perform ad hoc data reporting as needed
Work with team leads to prioritize business and information needs.
Develop and execute T-SQL code to facilitate data movements and ETL processing with a focus on consistency, reliability, and accuracy.
Design and code workflows, create database releases, and optimize production data pipelines to ensure data accuracy Perform hands on data research to provide insights and uncover potential data issues
Map data feeds and combine them with third party content ensuring consistency
Develop and code operational processes to automatically report on data conditions and KPIs during processing
Be a part of fast-moving development teams using agile methodologies
5+ years of professional database solution development with Microsoft SQL Server
Proven ability within the database performance and query optimization arena.
Strong Analytical and reasoning skills that result in clear, robust, and accurate solutions
Strong data debugging skills
Expertise in Data Analysis, Data Profiling, and SQL Tuning
Has deep understanding of data architecture & data modeling best practices, and guidelines for different data and analytic platforms including scrum and agile procedures.
Experience developing SQL scripts, data processing processes, and performance tuning quantitative queries
Superior organizational and end to end delivery skills in an Agile environment
Ability to manage multiple tasks and shifting priorities with proactive communication in mind
Ability to maintain strong working relationships with development and business teams based on a proactive communication style
5+ years of experience working within the full lifecycle SDLC as part of a software product and operations team environment
Experience with PowerShell scripting
Ability to work in a distributed team environment
Experience working on quantitative software products
An outstanding academic record with a focused on Energy, Science, Math, and Engineering or similar.
Excellent listening, interpersonal, written, oral, and phone communication skills
Highly self-motivated and self-directed to solve complex technical problems
Ability to exercise independent judgment
Builds and maintains relationships with stakeholders to ensure buy-in and adoption of technology solutions
Self-motivated to continuously improve technical and professional skills
Ability to effectively prioritize and execute tasks
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 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) .
Illinois Remote Office (IL99)