A statement on social injustice. Click to read more.
Fairfax, Virginia, United States of America
JOB #R2001790

SQL Server ETL Developer

SQL Server ETL Developer

Fairfax, VA 

Job Description: We’re looking for a SQL Server Integration Services (SSIS) Developer, someone who thrives not just developing, but owning the full development lifecycle to create and maintain solutions which work with a wide variety of data sources to create robust ETL solutions for ingesting, processing, archiving, and sending large quantities of data using reusable and scalable data solutions, both on premise and in the cloud.

You may be required to participate in periodic drug testing and background checks. 

What you’ll be doing:

• • Design, develop, and test a wide variety of custom SSIS packages, with maximum focus on reusability and scalability.

• Provide technical assistance to Business Analysts and Project Managers by reviewing their requirements to ensure they can be translated into ETL solutions.

• Provide quick turnaround technical and analytic support, including managing multiple tasks, to a wide variety of business owners who have rapidly evolving client demands.

• Maintain data integrity across a wide variety of Energy Efficiency programs, including troubleshooting data quality issues and communicating their impacts.

• Help the larger team define and implement best practices to improve processes and outputs.

Basic Qualifications:

• Bachelor's degree in a technical field (e.g., Computer Science, Engineering or related discipline)

• 5+ years of experience working with databases  (e.g., Tables, Procedures, Views, Functions), with 2+ years of experience specifically in SQL Server (2005 or higher)

• 5+ years of experience working with data warehouses, and ETL tools such as Microsoft SQL Server Integration Services (2005 or higher)

• 2+ years of experience working with SQL Server Integration Services (2014 or higher)

• Strong demonstrated analytic techniques, including demonstrated ability to perform query tuning  

Preferred Skills/Experience:

• Exposure to the utility, energy, and/or energy efficiency sectors a plus

• Experience with SSRS and SSAS Tabular/Cubes

• Experience with Power BI

• Experience with working in SQL Server in Azure

• Experience with working in .NET

Professional Skills:

• Excellent listening, written, and oral communication skills paired with an excellent sense of humor

• Ability to exercise independent judgment while effectively prioritizing and executing tasks while under pressure

• Team player with the ability to work in a fast-paced environment 

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.

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 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:  EEO is the law and  Pay Transparency Statement.

Fairfax, VA (VA01)

Who is ICF?

A consulting services company of over 5,000 experts across 67 countries, but not your typical consultants
LEARN MORE ABOUT ICF

More jobs you might like

Jul 6, 2020
Fairfax, Virginia, United States of America
Apr 13, 2020
Washington, District of Columbia, United States of America
See All Jobs

Join our talent network

ICF is growing, and we add new open roles to our site regularly. If you're waiting for that perfect opportunity at ICF or want an inside look at what it's like to do world-changing work, join our talent network to stay updated.

Join our talent network

ICF is growing, and we add new open roles to our site regularly. If you're waiting for that perfect opportunity at ICF or want an inside look at what it's like to do world-changing work, join our talent network to stay updated.