Data Analyst: Insights & Strategy Integrator

CapTech; Charlotte (NC); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Generous PTO

Health coverage

Disability insurance

Paid family leave

Tuition assistance

Mentorship program

401(k) Matching

Job summary

CapTech is an award-winning consulting firm delivering data-driven solutions. CapTech’s Data Analysts translate business needs into data models, governance, and actionable insights across client environments.

You’ll collaborate with data engineers, architects, scientists, and product owners to define requirements and deliver value. In this role you’ll use SQL, Python, and R to build data collections, design analytics, and create visuals with PowerBI and Tableau, while communicating complex

Qualifications

• Experience in an Agile development environment definition and testing
• Knowledge of statistics and using statistical tools for large datasets
• Design of data models, database design development, data profiling and analysis tools
• Experience with ETL/ELT, data ingestion and data wrangling
• Ability to communicate concepts to business and technical audiences
• Excellent interpersonal, collaboration, communication, and leadership skills

Responsibilities

• Quantify ambiguous business problems by analyzing processes, data, and systems and gathering data requirements from clients
• Implement data governance by capturing definitions, identifying data stewards, and mappings
• Develop data collection systems, implement databases and analytics to optimize efficiency
• Conduct data quality analysis and recommend QA processes to improve data health
• Interpret data with statistical techniques to provide insights for decision making
• Develop reports using data visualization tools to surface insights to end users
• Communicate with executives, data modelers, developers, business users, and customers

Skills

Agile development

Data storytelling

Communication

Leadership

Tools

Hive

Snowflake

SQL Server

Oracle

Teradata

Aurora

DynamoDB

Cosmos

MongoDB

Cassandra

dbt

Spark

FiveTran

Databricks

PowerBI

Tableau

Git

Job description

CapTech is an award-winning consulting firm delivering data-driven solutions. CapTech’s Data Analysts translate business needs into data models, governance, and actionable insights across client environments.

You’ll collaborate with data engineers, architects, scientists, and product owners to define requirements and deliver value. In this role you’ll use SQL, Python, and R to build data collections, design analytics, and create visuals with PowerBI and Tableau, while communicating complex