CapTech Consulting
Posted 1w ago

Data Analyst

CapTech Consulting
Columbus, Ohio, United States
OnsiteFull Time
Responsibilities
  • analyzing data
  • designing models
  • communicating insights
Requirements
  • Experience with Agile development
  • Requirements definition
  • Testing
  • Statistics
  • Data modeling
  • Databases
  • ETL/ELT
  • Data ingestion
  • Data wrangling, and stakeholder communication
Technical tools mentioned
SQLPythonRHiveSnowflakeSQL ServerOracleTeradataAuroraDynamoDBCosmosMongoDBCassandradbtSparkFiveTranDatabricksPower BITableauGit

Job description

Company 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’s Data 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 in capturing requirements, designing business processes and data models, and delivering actionable data to stakeholders. Data Analysts are passionate about interpreting data to help our clients make informed decisions and they are driven by a desire to solve our clients’ most complex business problems. Data Analysts work alongside like-minded peers who share their commitment to excellence and with visionary leaders who are invested in their success.  

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

  • 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  

Qualifications:

Typical experience for successful candidates includes:  

  • 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 munging/wrangling  

  • Experience in communicating concepts to both 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  

  • Database: Hive, Snowflake, SQL Server, Oracle, Teradata, Aurora, DynamoDB, Cosmos, MongoDB, Cassandra  

  • 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 for care
  • 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-led committees that embrace and incorporate diversity and inclusion into our day-to-day operations
  • 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. For more information about our Diversity, Inclusion and Belonging efforts, click HERE.  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 [email protected]. 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 

 

 

About CapTech Consulting

Technology and management consulting firm.

Similar jobs

Data Analyst roles near Columbus, Ohio
4w
Save
Mark Applied
Hide
Strategy Data Analyst
Columbus, Ohio, United States
$45k-$120k/yr OnsiteFull Time
Peak Retirement Planning
Peak Retirement Planning: Private Christian retirement-planning firm helping Midwestern retirees with $1M+ savings through tax, investment, and income planning.
Collect, analyze, and interpret internal and external data; build dashboards and reports; forecasting, modeling, and scenario analysis; translate business questions into analytical solutions.
1mo
Save
Mark Applied
Hide
Data Analyst - Cardio Partners - Dublin, OH
Dublin, Ohio, United States
HybridFull Time
Cardio Partners
Cardio Partners: Private U.S. emergency-preparedness provider supplying AEDs, CPR training, program management, repairs, and bleeding-control products.
4+ YOEBachelor's degree required, 4+ years data analysis experience, advanced SQL, Power BI and DAX experience, web platform configuration, data migration and implementation experience.
SQL, Power BI, DAX, Azure, AWS, APIs
1mo
Save
Mark Applied
Hide
Junior Data Analyst
Detroit or Toledo or Columbus
HybridFull Time
Hart
Hart: Independent, privately owned brand transformation agency providing marketing, advertising, public relations, digital, and creative services to businesses.
1–2 years relevant experience, strong Excel and PowerPoint skills, familiarity with performance marketing metrics, basic SQL/Python exposure, data visualization experience, and clear communication.
Microsoft Excel, Microsoft PowerPoint, Tableau, Power BI, Looker Studio, SQL, Python
1mo
Save
Mark Applied
Hide
Enterprise Risk Management (ERM) Senior Data Analyst
Phoenix or Dallas or Columbus
OnsiteFull Time
Western Alliance Bancorporation
Western Alliance BancorporationNYSE: WAL: A national bank holding providing diverse commercial financial services.
2+ YOE4+ years related risk management experience (or 4+ years equivalent); 2+ years data/BI experience; knowledge of risk frameworks (COBIT,NIST,ITIL,DCAM,DMBOK,FFIEC); Power BI skills; bachelor's degree or 4+ years direct experience.
Power BI, COBIT, NIST, ITIL, DCAM, DMBOK, FFIEC
1mo
Save
Mark Applied
Hide
Data Analyst, Investment Professional
Columbus, Ohio, United States
$127k-$213k/yr HybridFull Time
Nationwide
Nationwide: A large insurance and financial services organization.
8+ YOE8+ years building analytical data models for reporting and investment analytics; strong SQL, Snowflake, Databricks, Python (pandas/PySpark), BI tooling experience; bachelor’s preferred; must live within 35 miles of Columbus One Nationwide Plaza.
Snowflake, Databricks, Aladdin, SQL, Python, pandas, PySpark, Power BI, Tableau, Git
1mo
Save
Mark Applied
Hide
GME Data Analyst
Columbus, Ohio, United States
OnsiteFull Time
The Ohio State University
The Ohio State University: Public land-grant research university and academic medical center.
2+ YOEBachelor's degree or equivalent, 2+ years relevant experience, proficiency with Microsoft Office/Excel and data validation, strong analytical and communication skills, ability to handle confidential information.
Microsoft Office, Microsoft Excel, Workday, New Innovations, MedHub
2mo
Save
Mark Applied
Hide
Data Analyst, Home Lending HMDA
United States or Canada or San Mateo or Columbus or Austin or New York City
$92k-$126k/yr RemoteFull Time
Upstart
UpstartNasdaq: UPST: Public AI lending marketplace connecting consumers with banks and credit unions for personal, auto, and home-equity loans.
3+ YOE3+ years of HMDA/CRA data collection or compliance experience, strong mortgage lending knowledge, analytical and problem-solving skills, cross-functional collaboration, and proficiency with loan origination/compliance/data reporting systems.
2mo
Save
Mark Applied
Hide
Senior Data Analyst
Dublin, Ohio, United States
HybridFull Time
EASE Logistics Services
EASE Logistics Services: Privately held U.S. third-party logistics provider serving businesses with freight brokerage, transportation, warehousing, and supply-chain solutions.
4+ YOE4+ years BI/data analytics experience; expert Power BI and DAX, strong T-SQL against Azure SQL, experience with Microsoft Fabric preferred; ability to translate business questions and communicate findings to non-technical stakeholders.
Power BI, Power BI Premium, DAX, T-SQL, Azure SQL, Microsoft Fabric, Azure Synapse Analytics, OneLake, McLeod TMS, ADF, Python, R, Azure DevOps, Git