What are the responsibilities and job description for the Data Engineer position at ICF?
Data Engineer?
US Remote ??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, build and monitor database solutions and processes in SQL servers on daily basis. Candidate will be required to develop ETL processes in SQL Server (mostly in T-SQL) ???????to ???collect, store, validate and process large ??????datasets. ?? ????? ???This?? position will be part of a small analytical team working on multiple software products and services, so, experience in working in a product development environment is desired.? Successful candidates should 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.??? ?? Why you will love working here:
- Quality of life: Flexible workplace arrangements, Work-life balance
- Investment in 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!)
???What you will be doing:???? ???
- 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 client data feeds and load them in the data warehouse for the consumption by various ICF products
- Design and code operational processes to automatically report on data conditions and KPIs during processing????
- Work with team leads to prioritize business and information needs
- Be a part of fast-moving development teams using agile methodologies????
??????????????????????????????????????????????????????????????????????????????????? ??What we need you to have (minimum qualifications):
- Bachelor's Degree in (IT, Data Engineering, Computer Science or closely related field)
- 2 years of professional database solution development with Microsoft SQL Server ????
- 2 years of data debugging, data analysis, data profiling and SQL Tuning. Proven ability within the database performance and query optimization arena ??
- 2 years understanding of data architecture & data modeling best practices
- 2 years of experience working within the full lifecycle SDLC, as part of a software product and operations team environment??
- 2 years of working experience in SCRUM and Agile environment
?? ???What we would like you to have:
- Experience with Azure. Not a must but nice to have
- Experience in Jira, SVN, PowerShell scripting. Not a must but nice to have
???Professional Skills:?
- Excellent interpersonal, written, and oral communication skills????
- Ability to manage multiple tasks and shifting priorities with proactive communication in mind
- Highly self-motivated and self-directed to solve complex technical problems
- Strong Analytical and reasoning skills that result in clear, robust, and accurate solutions??????
- Builds and maintains relationships with stakeholders to ensure buy-in and adoption of technology solutions???
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) .
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 icfcareercenter@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 non-discrimination: Know Your Rights (https://www.eeoc.gov/sites/default/files/2022-10/EEOC\KnowYourRights\screen\reader\10\20.pdf) and Pay Transparency Statement (https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp\ English_formattedESQA508c.pdf) .
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 is :
$62,113.00 - $105,593.00
Nationwide Remote Office (US99)
Need help? We're here:ICFCareerCenter@icf.com
About ICF
ICF is a global consulting and technology services company with approximately 9,000 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 (https://c212.net/c/link/?t=0&l=en&o=3731098-1&h=2556622195&u=https://www.icf.com/&a=icf.com) .
US Remote ??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, build and monitor database solutions and processes in SQL servers on daily basis. Candidate will be required to develop ETL processes in SQL Server (mostly in T-SQL) ???????to ???collect, store, validate and process large ??????datasets. ?? ????? ???This?? position will be part of a small analytical team working on multiple software products and services, so, experience in working in a product development environment is desired.? Successful candidates should 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.??? ?? Why you will love working here:
- Quality of life: Flexible workplace arrangements, Work-life balance
- Investment in 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!)
???What you will be doing:???? ???
- 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 client data feeds and load them in the data warehouse for the consumption by various ICF products
- Design and code operational processes to automatically report on data conditions and KPIs during processing????
- Work with team leads to prioritize business and information needs
- Be a part of fast-moving development teams using agile methodologies????
??????????????????????????????????????????????????????????????????????????????????? ??What we need you to have (minimum qualifications):
- Bachelor's Degree in (IT, Data Engineering, Computer Science or closely related field)
- 2 years of professional database solution development with Microsoft SQL Server ????
- 2 years of data debugging, data analysis, data profiling and SQL Tuning. Proven ability within the database performance and query optimization arena ??
- 2 years understanding of data architecture & data modeling best practices
- 2 years of experience working within the full lifecycle SDLC, as part of a software product and operations team environment??
- 2 years of working experience in SCRUM and Agile environment
?? ???What we would like you to have:
- Experience with Azure. Not a must but nice to have
- Experience in Jira, SVN, PowerShell scripting. Not a must but nice to have
???Professional Skills:?
- Excellent interpersonal, written, and oral communication skills????
- Ability to manage multiple tasks and shifting priorities with proactive communication in mind
- Highly self-motivated and self-directed to solve complex technical problems
- Strong Analytical and reasoning skills that result in clear, robust, and accurate solutions??????
- Builds and maintains relationships with stakeholders to ensure buy-in and adoption of technology solutions???
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) .
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 icfcareercenter@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 non-discrimination: Know Your Rights (https://www.eeoc.gov/sites/default/files/2022-10/EEOC\KnowYourRights\screen\reader\10\20.pdf) and Pay Transparency Statement (https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp\ English_formattedESQA508c.pdf) .
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 is :
$62,113.00 - $105,593.00
Nationwide Remote Office (US99)
Need help? We're here:ICFCareerCenter@icf.com
About ICF
ICF is a global consulting and technology services company with approximately 9,000 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 (https://c212.net/c/link/?t=0&l=en&o=3731098-1&h=2556622195&u=https://www.icf.com/&a=icf.com) .
Claims Processor
NTT DATA -
Decatur, IL
TEMP BPO Senior Associate
NTT DATA North America -
Decatur, IL
Telecommunications Network Provisioning Specialist
NTT Global Data Centers Americas, Inc. -
Springfield, IL
