Data Analyst

CapTech Consulting; Philadelphia (Philadelphia County); Hybrid; USD 70,000 - 100,000; Full time

Benefits offered by this job

Generous PTO

Health coverage

Disability insurance

Paid family leave

Flexible work environment with remote

Learning & Development

401(k) Matching

Job summary

CapTech Consulting is seeking a data professional to partner with clients and stakeholders, turning business needs into actionable data outcomes. You’ll work through requirements, data modeling, governance, quality analysis, and deliver insights using modern analytics and visualization.

You’ll collaborate with Data Engineers, Data Architects, Data Scientists, and Product Owners on project work in an Agile environment, with hybrid/remote options and strong learning opportunities.

Qualifications

• Experience in Agile development with requirements definition and testing.
• Statistics knowledge and experience using statistical languages and packages for analyzing large datasets.
• Demonstrable experience designing data models and supporting database development, including data profiling and data analysis tools.
• Demonstrable experience with ETL/ELT, data ingestion, and data munging or wrangling.
• Ability to explain concepts to both business and technical audiences.
• Excellent interpersonal, collaboration, communication, and leadership skills.

Responsibilities

• Quantify ambiguous business problems by analyzing business processes, data, and systems, and gathering data requirements from clients.
• Apply data governance best practices by capturing data definitions, identifying data stewards, and mapping transformations from source to target.
• Build data collection systems by implementing databases and analytics that optimize efficiency.
• Perform data quality analysis and recommend quality assurance processes to improve data health.
• Interpret results using statistical techniques to produce insights that guide business decision making.
• Create reports with modern data visualization tools and best practices to help end-users access meaningful findings.
• Communicate clearly with executives, data modelers, application developers, business users, and customers to build solutions and interpret results.
• Collaborate with other data workstreams including Data Engineers, Data Architects, Data Scientists, and Product Owners on project work.

Skills

Agile

Statistics

Data models

ETL/ELT

Business communication

Interpersonal skills

Tools

SQL

Python

R

Hive

Snowflake

SQL Server

Oracle

Teradata

Aurora

DynamoDB

Cosmos

MongoDB

Cassandra

dbt

Spark

Fivetran

Databricks

PowerBI

Tableau

git

Job description

CapTech Consulting is a technology and consulting organization that supports data professionals with generous PTO, health coverage, disability insurance, and paid family leave. The team also benefits from a flexible work environment with the ability to work remotely when compatible with CapTech and client needs, plus access to learning and well-being programs, employee resource groups, and community-focused philanthropic partnerships.

This role partners with clients and stakeholders to turn business needs into actionable data outcomes. You’ll work through requirements, process design, data modeling, governance, and quality analysis, then deliver insights using modern analytics and visualization practices.

What you’ll do

• Quantify ambiguous business problems by analyzing business processes, data, and systems, and gathering data requirements from clients.
• Apply data governance best practices by capturing data definitions, identifying data stewards, and mapping transformations from source to target.
• Build data collection systems by implementing databases and analytics that optimize efficiency.
• Perform data quality analysis and recommend quality assurance processes to improve data health.
• Interpret results using statistical techniques to produce insights that guide business decision making.
• Create reports with modern data visualization tools and best practices to help end-users access meaningful findings.
• Communicate clearly with executives, data modelers, application developers, business users, and customers to build solutions and interpret results.
• Collaborate with other data workstreams including Data Engineers, Data Architects, Data Scientists, and Product Owners on project work.

What you’ll bring

• Experience working in an Agile development environment, including requirements definition and testing.
• Statistics knowledge and experience using statistical languages and packages for analyzing large datasets.
• Demonstrable experience designing data models and supporting database development, including data profiling and data analysis tools.
• Demonstrable experience with ETL/ELT, data ingestion, and data munging or wrangling.
• Ability to explain concepts to both business and technical audiences.
• Excellent interpersonal, collaboration, communication, and leadership skills.

Tools and technologies

SQL, Python, R, Hive, Snowflake, SQL Server, Oracle, Teradata, Aurora, DynamoDB, Cosmos, MongoDB, Cassandra, dbt, Spark, FiveTran, Databricks, PowerBI, Tableau, git.

Benefits

• Generous PTO
• Health coverage
• Disability insurance
• Paid family leave
• Flexible work environment with remote work when compatible with CapTech and client needs
• Learning & Development with programs offering certification and tuition support, digital on-demand learning, mentorship, and skill development paths
• Modern Health mental health and well-being platform with 1:1 care, group support sessions, and self-serve resources
• Carrot Fertility coverage for inclusive family-forming paths, including adoption, surrogacy, fertility treatments, pregnancy, and more, plus opportunities for employer-sponsored funds
• Fringe stipend program for personalized lifestyle benefits including vendor options and services such as student loan repayment, travel, and fitness
• Employee Resource Groups led by employees and focused on diversity and inclusion in day-to-day operations
• Philanthropic Partnerships supporting communities through partnerships and pro-bono projects
• 401(k) Matching with generous matching and no vesting period

Location: Philadelphia, PA (hybrid).

Additional information: Employees must be available to work onsite in a client location or a CapTech office as requested. CapTech cannot transfer nor sponsor a work visa for this position. Applicants must be authorized to work directly for any employer in the United States without visa sponsorship. CapTech is an equal opportunity employer committed to fostering a culture of equality, inclusion and fairness. If you need a reasonable accommodation for the job application or interview process, or to perform essential job functions, please contact Laura Massa at [e-mail].