Data Analyst

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

Benefits offered by this job

Learning & Development

Modern Health

Carrot Fertility

Fringe

Employee Resource Groups

Philanthropic Partnerships

401(k) Matching

Job summary

CapTech is seeking a Data Analyst to join a collaborative team focused on turning data into actionable insights for clients across industries. You will define data requirements, design data models, and deliver governance and quality checks to ensure reliable analytics.

In this role you will work with Agile teams to build and optimize ETL pipelines, create visualizations in PowerBI/Tableau, and communicate findings to business stakeholders and executives.

Qualifications

• Experience working in an Agile development environment and with requirements definition.
• Knowledge of statistics and experience using statistical languages for large datasets.
• Design experience for data models, databases, data profiling and data analysis tools.
• Experience with ETL/ELT, data ingestion, and data wrangling.
• Ability to communicate concepts to both business and technical audiences.
• Strong interpersonal, collaboration, and leadership skills.

Responsibilities

• Quantify ambiguous business problems by analyzing business processes, data, and systems and gathering data requirements from clients.
• Implement data governance by capturing data definitions, data stewards, and transformations through mappings.
• Develop data collection systems, implement databases and analytics to optimize efficiency.
• Conduct data quality analysis and provide recommendations to improve data health and QA processes.
• Interpret data and analyze results using statistical techniques to guide decision making.
• Develop reports using modern data visualization tools to surface insights for end users.
• Communicate with executives, data modelers, developers, business users, and customers to build solutions and interpret results.
• Collaborate with other data workstreams on specific projects.

Skills

SQL

Python

R

Tools

dbt

Spark

FiveTran

Databricks

PowerBI

Tableau

git

Job description

CapTech is an award-winning consulting firm that collaborates with clients to achieve what’s possible through the power of technology. At CapTech, we’re passionate about the work we do and the results we achieve for our clients. From the outset, our founders shared a collective passion to create a consultancy centered on strong relationships that would stand the test of time. Today we work alongside clients that include Fortune 100 companies, mid-sized enterprises, and government agencies, a list that spans across the country.

Job Description

CapTech’sData Analysts work within a collaborative, team environment to help define and deliver innovative solutions to our clients.At the intersection of data and strategy, Data Analysts play a key role incapturingrequirements,designingbusiness processesand data models, and delivering actionable data to stakeholders.Data Analysts are passionate aboutinterpreting data to helpourclients make informeddecisionsandthey are driven by a desire to solve our clients’ most complex business problems. Data Analysts work alongside like-minded peerswho share their commitment to excellenceandwithvisionary leaders whoare invested in their success.

Specific job responsibilities will vary by project role, but may include:

Quantifyambiguous business problemsbyanalyzing business processes, data, and systems andgathering data requirements from clients

Implementdata governance best practices by capturing data definitions,identifyingdata stewards, anddata transformations through source-to-target mappings

Develop data collection systems, implement databases and analytics tooptimizeefficiency

Conduct data quality analysisandprovide recommendations for effective quality assurance processesthatimprovedata health

Interpret data and analyze results using statistical techniques that provide valuable insights and guide decision making across the business

Developreportsusingmodern data visualization tools and best practicesto surface valuable insights to end-users

Communicate with all levels of stakeholders asappropriate, including executives, data modelers, application developers, business users, and customerstobuildsolutionsand interpretresults

Collaborate with other data workstreams (Data Engineers, Data Architects, Data Scientists, Product Owners) on specific projects

Qualifications

Typical experience for successful candidates includes:

Experienceworking in anAgile development environment, including requirements definition and testing

Knowledge of statistics and experience using statistical languages and packages for analyzing large datasets

Demonstrable experience in the design of data models, database design development, data profiling, and various data analysis tools

Demonstrable experience with ETL/ELT, data ingestion, and data munging/wrangling

Experience incommunicating concepts toboth business and technical audiences

Excellent interpersonal, collaboration, communication, and leadership skills

Skills

Successful candidates usually have demonstrable experience with technologies in some of these categories:

Languages: SQL, Python, R

Additional Technologies:dbt, Spark,FiveTran,Databricks,PowerBI, Tableau, git

Additional Information

We want everyone at CapTech to be able to envision a lasting and rewarding career here, which is why we offer a variety of career paths based on your skills and passions. You decide where and how you want to develop, and we help get you there with customizable career progression and a comprehensive benefits package to support you along the way.Alongside our suite of traditional benefits encompassing generous PTO, health coverage, disability insurance, paid family leave and more, we’ve launched extended benefits to help meet our employees’ needs.

CapTech is committed to providing a flexible work environment and helping our employees achieve a work-life balance that suits their individual needs. Employees must be available to work onsite in a client location or a CapTech office as requested. We allow CapTech employees to work remotely when compatible with CapTech and client needs.

• Learning & Development – Programs offering certification and tuition support, digital on-demand learning courses, mentorship, and skill development paths
• Modern Health –A mental health and well-being platform that provides 1:1 care, group support sessions, and self-serve resources to support employees and their families through life’s ups and downs
• Carrot Fertility –Inclusive fertility and family-forming coverage for all paths to parenthood – including adoption, surrogacy, fertility treatments, pregnancy, and more – and opportunities for employer-sponsored funds to help pay forcare
• Fringe –A company paid stipend program for personalized lifestyle benefits, allowing employees to choose benefits that matter most to them – ranging from vendors like Netflix, Spotify, and GrubHub to services like student loan repayment, travel, fitness, and more
• Employee Resource Groups –Employee-ledcommitteesthatembrace and incorporate diversity and inclusion into ourday-to-dayoperations
• Philanthropic Partnerships –Opportunities to engage in partnerships and pro-bono projects that support our communities.
• 401(k)Matching – Generous matching and no vesting period to help you continue to build financial wellness

CapTech is an equal opportunity employer committed to fostering a culture of equality, inclusion and fairness — each foundational to our core values. We strive to create a diverse environment where each employee is encouraged to bring their unique ideas, backgrounds and experiences to the workplace. As part of this commitment, CapTech will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact Laura Massa directly via email [emailprotected] . At this time, 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.

#LI-LM1