Description

Please note: This role is contingent upon a contract award. While it is not an immediate opening, we are actively conducting interviews and extending offers in anticipation of the award.

We are seeking a Senior Data Analyst to lead a complex, fast-paced digital modernization effort, transforming legacy reporting systems into a modern, scalable, and AI-augmented data ecosystem. In this role, you’ll guide a cross-functional team in migrating thousands of fragmented legacy reports and data into a unified, cloud-native architecture built on modular frameworks.

This role supports a major digital modernization initiative focused on strengthening regulatory insight, enhancing program effectiveness, and improving public safety outcomes through high-impact analytics. You’ll play a pivotal role in re-architecting data logic, enabling modular reporting design, ensuring end-to-end data accuracy, and laying the groundwork for advanced insights powered by AI/ML.

If you are passionate about driving clarity from complexity, influencing enterprise data decisions, and designing sustainable analytics frameworks using modern cloud technologies, we want to hear from you.

This position requires strong analytical capabilities, technical curiosity, and a willingness to engage directly with clients and stakeholders. You will be central to gathering requirements, analyzing source systems, designing end-to-end BI solutions, and ensuring that decision-makers have access to accurate, timely, and meaningful information.

Job Location: This position is fully remote within the United States.

What you’ll be doing:

Lead the discovery and rationalization of thousands of legacy reports, identifying redundant logic, business-critical content, and opportunities for consolidation

Architect and validate semantic reporting layers and data models that support scalable, reusable, and user-driven analytics

Collaborate with solution architects and engineers to redesign reporting logic from static Oracle OBIEE reports to a cloud-native Databricks + Azure environment

Oversee the migration planning, including dependency mapping, technical specification, and data quality assurance

Work directly with stakeholders to uncover hidden logic in legacy reports and convert it into modular components that are easier to manage, validate, and scale

Design and guide the creation of BI/Reporting frameworks that enable AI-ready analytics and future automation

Translate high-level business needs into detailed technical requirements for ETL development, data modeling, dashboarding, and ML integration

Provide leadership in data validation, QA, and business rule traceability to ensure trust in every reporting output

Serve as the primary liaison for cross-team communication, aligning priorities across business, data, and engineering stakeholders

Work with Project Manager, Data/Solution Architect and Development team to plan and manage Agile Sprints for product delivery.

Technologies you’ll use:

SQL, Python, R, Talend, SAS

Cloud Native solutions such as AWS, Azure

BI tools like Tableau, PowerBI

MS Excel, MS Visio, MS PowerPoint

Mural/Miro/Whiteboard

Confluence/Jira/SharePoint

What you must have:

Bachelor’s degree in Data Analytics, Computer Science, Information Systems, or a related technical field

7+ years of experience in data analysis, BI solution design, and reporting system transformation

US Citizen or Permanent Lawful Resident (Green Card Holder) preferred.

Employment must be compliant with eligibility for Public Trust Clearance due to Government Contract.

What we’d like you to have:

Demonstrated experience leading or co-leading large-scale reporting modernization initiatives

Deep proficiency in SQL for complex joins, transformations, and validation at scale

Strong understanding of Azure Synapse, Data Factory, Databricks, or similar platforms

Experience with data profiling, source-to-target mapping, and modular report development frameworks

Expertise in developing semantic layers, reusable datasets, and standardized metrics across BI platforms

Proficiency with BI tools such as Power BI, Tableau, or Looker for analysis and dashboard validation

Experience modernizing complex legacy BI environments, including identifying report logic embedded in hard-coded systems

Familiarity with AI/ML integration points within analytics workflows, such as feature engineering, output validation, and explainability

Understanding of data lakehouse architectures, Delta Lake, and real-time streaming use cases

Experience creating automated validation frameworks and supporting ML-enabled QA pipelines

Proven ability to connect the dots between business value, data design, and visual storytelling

Familiarity with CI/CD practices and automation in modern SDLC for analytics deployment

Ability to coach others in data governance, semantic alignment, and documentation standards for reporting ecosystems

Professional Skills

Exceptional communication skills with experience managing client-facing discovery, requirements gathering, and delivery planning

Why you’ll love working here:

Generous vacation and retirement plans

Comprehensive health benefits

Flexible work environment

Ongoing training and development opportunities

Inclusive and collaborative culture

Meaningful work that impacts communities

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.

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:

$89,203.00 - $151,646.00

Nationwide Remote Office (US99)