Data Analyst

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 data analyst who is passionate about turning complex data into actionable insights that improve public systems and services. This role supports a major digital modernization initiative focused on workforce development infrastructure across Puerto Rico. If you thrive in a collaborative environment, enjoy working independently to solve real-world challenges through data, and are committed to human-centered design, 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. This role supports a modular, cloud-native platform that spans multiple local development areas and helps deliver services more effectively across Puerto Rico.

Job Location: This position is based in Puerto Rico.

What you'll be doing:

• Participate in client and stakeholder interviews to gather requirements on business process, existing systems/reports, and pain points
  
• Identify data source systems and perform extensive system analysis and data profiling on these systems.
  
• Design end-to-end BI/Reporting solutions, from data extraction to presentation, to address the clients' needs.
  
• Provide detailed technical requirements to (1) the Extract, transform, and load(ETL) to processing routines and data feeds (2) Data Modelling team to create necessary data structures or data models (3) Data Visualization team for detailed BI/reporting requirements.
  
• Perform data validation/QA on the BI solution to ensure that it meets the technical requirements.
  
• 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 (e.g., Computer Science, Engineering, or related discipline)
  
• 2+ years of experience leading client conversations and conducting requirement/user interview sessions
  
• 2+ years of experience performing data analysis, including writing SQL queries (or similar) against source and target system databases.
  
• 2+ years of experience in providing detailed technical requirements to the ETL, Data Modelling and Data Visualization team by creating BI report mockups, source-to-target data mapping, data dictionaries, data flow diagrams etc.
  
• 2+ years of experience working with BI tools such as Tableau, PowerBI
  
• 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:

• Proficient with data warehouse design that includes data modeling, ETL and BI reporting development for big data systems
  
• Demonstrated knowledge of data analysis and modeling approaches and scripting software (e.g., R, Python)
  
• Comprehensive knowledge and experience in MS Office products, such as Excel, Visio, Teams and PowerPoint
  
• Experience with agile development process
  
• Experience working in bilingual (English/Spanish) environments or supporting Spanish-speaking stakeholders
  

Professional Skills

• Demonstrated experience showing strong critical thinking and problem-solving skills paired with a desire to take initiative
  
• Very strong analytical skills and a demonstrated ability to work independently and to apply a variety of technical skills and innovative thinking to solve problems
  
• Strong written and oral communication skills
  
• Effective time management skills and the ability to balance and prioritize multiple projects to meet goals, deliverables, and deadlines
  

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 workplacediscriminationrigh t s 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 :
$66,701.00 - $113,391.00

Puerto Rico Remote Office (PR99)