Data Analyst: Insights, Governance & Visualization

Captech-Consulting; Columbus (OH); Hybrid; USD 70,000 - 100,000; Full time

Benefits offered by this job

Learning & Development

Modern Health

Carrot Fertility

Fringe Stipend

Employee Resource Groups

Philanthropic Partnerships

401(k) Matching

Job summary

CapTech is seeking a Data Analyst to join our collaborative team. You will help define and deliver innovative data solutions by capturing requirements, designing data models, and delivering actionable insights to stakeholders.

You'll work across data governance, ETL/ELT, and analytics, using SQL, Python, R and modern tools like dbt, Spark, Databricks, PowerBI and Tableau. The role emphasizes communication, collaboration, and leadership within Agile environments.

Qualifications

• Experience working in an Agile 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 wrangling.
• Experience in communicating concepts toboth 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.
• Implement data governance best practices by capturing data definitions, identifying data stewards, and data transformations through source-to-target mappings.
• Develop data collection systems, implement databases and analytics to optimize efficiency.
• Conduct data quality analysis and provide recommendations for effective quality assurance processes that improve data health.
• Interpret data and analyze results using statistical techniques that provide valuable insights and guide decision making across the business.
• Develop reports using modern data visualization tools and best practices to surface valuable insights to end-users.
• Communicate with all levels of stakeholders as appropriate, including executives, data modelers, application developers, business users, and customers to build solutions and interpret results.
• Collaborate with other data workstreams (Data Engineers, Data Architects, Data Scientists, Product Owners) on specific projects.

Skills

SQL

Python

R

Tools

dbt

Spark

FiveTran

Databricks

PowerBI

Tableau

git

Job description

CapTech is seeking a Data Analyst to join our collaborative team. You will help define and deliver innovative data solutions by capturing requirements, designing data models, and delivering actionable insights to stakeholders.

You'll work across data governance, ETL/ELT, and analytics, using SQL, Python, R and modern tools like dbt, Spark, Databricks, PowerBI and Tableau. The role emphasizes communication, collaboration, and leadership within Agile environments.