What are the responsibilities and job description for the ETL Developer / Data Engineer position at ICF?
Description
Data Engineer
Location: Reston, VA - must be able to go into the Reston based office a minimum of 1 time per week
Ready to make a difference?
We’re looking for an ETL / SSIS Developer who enjoys collaborating with coworkers and wants to help automate data delivery to various systems and their users. You'll support a team delivering data solutions across a diverse portfolio of utility and energy clients. You'll have opportunities to work on a variety of projects while continuing to build your technical expertise.
You can leverage the teams’ existing best practices and development framework to streamline and guide your development efforts. The application of this knowledge will ensure we can both meet our client requirements and develop/deploy our solutions efficiently and at scale.
Why You Will Love Working Here
Our business analysts, senior developers, and architects will share requirements and solution designs, and you'll collaborate with the team to help build and support data integration solutions. Your daily tasks will be highly varied and could include developing solutions, monitoring their executions for anomalies, and troubleshooting problems that might arise from bad data.
Initial ramp up will require travel to our Reston HQ approximately 2 - 3 days a week. After that, candidates will be required to go into the office approximately 1 time per week. Rarely, there could be a need for travel for a conference or to another ICF location for collaboration. You may be required to participate in periodic drug testing and background checks.
Qualifications
What we need you to have (minimum qualifications):
ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future.
We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. 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 policy.
We will consider for employment qualified applicants with arrest and conviction records.
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 Candidateaccommodation@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 workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act.
Candidate AI Usage Policy
At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.
However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at candidateaccommodation@icf.com. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.
Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position.
The pay range for this position based on full-time employment is:
$81,147.00 - $137,949.00
Reston, VA (VA30)
Data Engineer
Location: Reston, VA - must be able to go into the Reston based office a minimum of 1 time per week
Ready to make a difference?
We’re looking for an ETL / SSIS Developer who enjoys collaborating with coworkers and wants to help automate data delivery to various systems and their users. You'll support a team delivering data solutions across a diverse portfolio of utility and energy clients. You'll have opportunities to work on a variety of projects while continuing to build your technical expertise.
You can leverage the teams’ existing best practices and development framework to streamline and guide your development efforts. The application of this knowledge will ensure we can both meet our client requirements and develop/deploy our solutions efficiently and at scale.
Why You Will Love Working Here
- Quality of life: Flexible workplace arrangements, work-life balance
- Investment of the community: Donation matching, volunteer opportunities
- Investment in you: Tuition reimbursement, access to professional development resources, 401k matching, Employee Stock Purchase Plan
- And many, many more (Ask your recruiter for more details!)
Our business analysts, senior developers, and architects will share requirements and solution designs, and you'll collaborate with the team to help build and support data integration solutions. Your daily tasks will be highly varied and could include developing solutions, monitoring their executions for anomalies, and troubleshooting problems that might arise from bad data.
Initial ramp up will require travel to our Reston HQ approximately 2 - 3 days a week. After that, candidates will be required to go into the office approximately 1 time per week. Rarely, there could be a need for travel for a conference or to another ICF location for collaboration. You may be required to participate in periodic drug testing and background checks.
Qualifications
What we need you to have (minimum qualifications):
- Bachelor's degree in Computer Science or similar field
- 2 years experience working with SQL (e.g., query tuning, writing procedures/functions, building views)
- 1 year(s) experience developing/optimizing SSIS packages with design to maximize flexibility and standardization
- Experience with working with SSIS parameterized packages in a project solution using standard SDLC.
- Critical thinking skills / questioning why the requirements are what they are
- Experience consuming APIs as data sources/destinations
- Exposure to the utility, energy, and/or energy efficiency sectors
ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future.
We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. 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 policy.
We will consider for employment qualified applicants with arrest and conviction records.
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 Candidateaccommodation@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 workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act.
Candidate AI Usage Policy
At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.
However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at candidateaccommodation@icf.com. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.
Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position.
The pay range for this position based on full-time employment is:
$81,147.00 - $137,949.00
Reston, VA (VA30)
Salary : $81,147 - $137,949