United States onlyPlease 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 theirexpertiseand collaborate with others to achieve personal and professional goals. For more information, please read our EEOpolicy.
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 withsincerely heldreligious beliefs, in all phases of the application and employment process. To requestan accommodation,please email Candidateaccommodation@icf.com and we will be happy toassist. All information you provide will be kept confidential and will be used only to the extentrequiredto provide needed reasonable accommodations.
Read more about workplace discrimination rightsor our benefit offerings which are included in the Transparency in (Benefits) CoverageAct.
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 orassistwith responses during interviews (whether in-person or virtual) is notpermitted. This policy is in place tomaintainthe integrity and authenticity of the interview process.
However, we understand that some candidates may require accommodation that involves the use of AI. Ifsuch anaccommodation is needed, candidates are instructed to contact us in advance at candidateaccommodation@icf.com. Weare dedicated to providingthe 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.00Nationwide Remote Office (US99)
