Data Analytics and Visualization Consultant

metaphaseconsulting; Washington (District of Columbia); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Generous PTO

Federal holidays

Comprehensive health coverage

401(k) with company match

Commuter benefits

Job summary

MetaPhase is seeking a Data Analytics and Visualization Consultant to support ICE, OCIO, ITaCS, translating complex questions into actionable insights. You will collaborate across data analytics, visualization, reporting, and data preparation while building scalable analytics infrastructure. The role emphasizes data modeling, ETL, and dashboard development using Power BI, Databricks, and Palantir Foundry.

U.S. Citizenship and a polygraph/ICE suitability process are required.

Qualifications

• U.S. Citizenship.
• Bachelor’s degree.
• Five (5) years of relevant experience – College Internships count!
• Experience developing data visualizations, dashboards, and reports.
• Proficiency with Microsoft Excel and at least one business intelligence tool, such as Power BI or Tableau.
• Knowledge of SQL, Python, or other data preparation and analytics technologies.
• Experience working with Databricks or a comparable cloud-based data and analytics platform.
• Advanced understanding of data modeling concepts and practices.
• Experience supporting ETL processes, data integration, or data management infrastructure.
• Strong problem-solving skills, attention to detail, communication skills, and ability to work effectively on a team.
• Executive presence and the ability to engage directly with executive clients.
• Ability to obtain and maintain ICE Public Trust (High Risk) suitability – Team members cannot begin billing until ICE clearance and access are approved.

Responsibilities

• Automate extract, transform, and load (ETL) processes to streamline data preparation and enable efficient front-end reporting.
• Apply advanced data modeling concepts to develop efficient, maintainable, and reporting-ready data structures.
• Develop data visualizations, dashboards, and reports that turn complex information into clear, actionable insights.
• Partner with business, operational, and technical stakeholders to define requirements and deliver fit-for-purpose analytics solutions.
• Conduct data validation and quality checks to ensure accuracy, consistency, and confidence in reporting outputs.
• Document data sources, transformation logic, reporting processes, and technical solutions to support transparency and knowledge sharing.
• Identify opportunities to improve reporting efficiency, reduce manual effort, and expand data-driven decision-making across the organization.

Skills

Data analytics

Power BI

Excel

SQL

Python

Databricks

Data modeling

ETL

Communication

Education

Bachelor's degree

Tools

Power BI

Databricks

Palantir Foundry

Tableau

Excel

Job description

At MetaPhase, we believe Quirky is Cool and being authentic is the only way to be! We take the work we do very seriously and do important, mission-focused work for our clients. We are individuals with different passions and strengths who take as much joy in the work we do as from those we work with. Our team is invested in creating new solutions that lean forward, challenge the status quo, and reflect our intimate knowledge of our customers’ business. We are united by shared values: passion, solidarity, generosity, curiosity, and boldness.

Together, we know our people are our difference, for our clients and our colleagues.

Are you ready to:

• Work alongside a dedicated and diverse team to offer honest advice and practical guidance to our clients?
• Learn and grow by taking advantage of every opportunity available to you?
• Join a company that prides itself on shared values and an inclusive culture?
• Be the difference and make it happen?

Role Summary

MetaPhase is seeking a motivated and talented Data Analytics and Visualization Consultant to support the U.S. Department of Homeland Security, Immigration and Customs Enforcement (ICE), Office of the Chief Information Officer (OCIO), through the IT Training and Communications Services (ITaCS) initiative. This role will translate complex business questions into clear, actionable insights that improve internal operations and support Executive Branch stakeholders.

The consultant will work across data analytics, visualization, reporting, data preparation, and quality assurance using tools such as Power BI, Excel, Databricks, and Palantir Foundry. The ideal candidate will help build reliable, scalable, and repeatable analytics infrastructure while partnering with business, operational, and technical stakeholders in a collaborative environment.

What You Will Be Doing

• Automate extract, transform, and load (ETL) processes to streamline data preparation and enable efficient front-end reporting.
• Apply advanced data modeling concepts to develop efficient, maintainable, and reporting-ready data structures.
• Develop data visualizations, dashboards, and reports that turn complex information into clear, actionable insights.
• Partner with business, operational, and technical stakeholders to define requirements and deliver fit-for-purpose analytics solutions.
• Conduct data validation and quality checks to ensure accuracy, consistency, and confidence in reporting outputs.
• Document data sources, transformation logic, reporting processes, and technical solutions to support transparency and knowledge sharing.
• Identify opportunities to improve reporting efficiency, reduce manual effort, and expand data-driven decision-making across the organization.

What We Need From You (Required)

• U.S. Citizenship.
• Bachelor’s degree.
• Five (5) years of relevant experience – College Internships count!
• Experience developing data visualizations, dashboards, and reports.
• Proficiency with Microsoft Excel and at least one business intelligence tool, such as Power BI or Tableau.
• Knowledge of SQL, Python, or other data preparation and analytics technologies.
• Experience working with Databricks or a comparable cloud-based data and analytics platform.
• Advanced understanding of data modeling concepts and practices.
• Experience supporting ETL processes, data integration, or data management infrastructure.
• Strong problem-solving skills, attention to detail, communication skills, and ability to work effectively on a team.
• Executive presence and the ability to engage directly with executive clients.
• Ability to obtain and maintain ICE Public Trust (High Risk) suitability – Team members cannot begin billing until ICE clearance and access are approved.

Bonus Points (Desired)

• Hands-on experience with Power BI, Databricks, or Palantir Foundry.
• Experience supporting Executive Branch stakeholders or a federal client environment.
• Demonstrated interest in learning new technologies and continuously improving existing analytics capabilities.

Work Location

Washington, DC. This role requires approximately 75% onsite co-location with the client team.

Travel

N/A

Benefits & Perks

At MetaPhase, we care about your well-being and success. Our benefits include generous PTO, federal holidays, parental leave, comprehensive health coverage (medical, dental, vision, life, and disability), 401(k) with company match, FSA/HSA options, commuter benefits, and more.

About MetaPhase

MetaPhase is different with a purpose, demonstrating a new approach to the industry that puts employees and culture first. We continue to be recognized by industry as one of the fastest-growing and most impactful consultancies in the nation.

MetaPhase is an equal opportunity employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, national origin, disability or veteran status, or any other factors protected by applicable law.