Offer summary

Qualifications:

Bachelor's degree in Computer Science, IT, Data Science, Math, or related fields, or equivalent experience., 5+ years of experience working with SQL, including query tuning and writing procedures/functions., Advanced knowledge of SSRS tools and functionalities, including report design and parameterization., Strong understanding of database structures, normalization, and data modeling..

Key responsabilities:

Collaborate with data analysts to gather requirements and provide feedback on report designs.

Develop and deliver custom data analytic and reporting solutions within specified timeframes.

Maintain data integrity across various energy efficiency programs and troubleshoot data quality issues.

Create and update custom reports, scorecards, and self-service tools as needed.

Job description

Senior SSRS Developer

Growth, Engagements and Insight; IT and Product Development

Location: Nationwide US (Remote – Home Office)

Ready to make a difference?

We’re seeking an experienced and dynamic SQL (SSRS) Developer with a passion for collaboration and creating impactful data reporting solutions. In this role, you’ll work closely with a diverse range of business owners to support their fast-evolving needs, delivering timely and insightful analytics while expertly juggling multiple priorities.

You’ll have the opportunity to tap into our team’s established best practices and proven development methodologies to streamline your efforts and ensure high-quality results. Additionally, your expertise will be invaluable in advancing our team’s capabilities, as you provide architectural guidance for SSRS solutions using industry-leading development and security practices. By applying your knowledge, you’ll help us efficiently design and deploy scalable analytics solutions that meet client demands and drive meaningful outcomes.

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!)

What you will be doing:

Data analysts will share requirements and documentation so the SSRS Developer can provide feedback, suggesting alternate report designs, prior to building your custom data analytic and reporting solutions (e.g., invoices, data validations, custom extracts).
Your work will be delivered on client specified timeframes (e.g., weekly, monthly, quarterly) but there will also be quick turnaround support, especially for ad hoc analytics.
You may also be developing scorecards, subscriptions, custom self-service tools, etc.
Your daily tasks will be highly varied and could include helping to maintain data integrity across a wide variety of energy efficiency programs, troubleshooting data quality issues and communicating their impacts, updating and maintaining custom reports, etc.

What we need you to have (minimum qualifications):

Bachelor's degree in (Computer Science, IT, Data, Science, Math or related fields)(or applicants can substitute one year of related experience for one year of education)
5+ years of experience working with SQL (e.g., query tuning, writing procedures/functions, building views)
5+ years of experience in SQL querying and scripting, with experience optimizing complex queries for performance and scalability.
Must be able to pass a Motor Vehicle Record (MVR) check and Background Check including a Drug Screening

What we would like you to have:

Experience in maintaining and rapidly producing regular reporting deliverables for a variety of audiences
Exposure to the utility, energy, and/or energy efficiency sectors
Advanced knowledge of SSRS tools and functionalities, including report design and parameterization.
Proficiency in SQL Server and T-SQL programming.
Strong understanding of database structures, normalization, and data modeling.
Experience with integrating SSRS reports into applications or other platforms.
Familiarity with version control and development best practices.

Working at ICF

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.

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:

$73,722.00 - $125,327.00

Nationwide Remote Office (US99)

Required profile