Data Architect / Data Analyst

TRA'BIAN ENTERPRISES
Columbus, OH, United States
2 months ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source

Tech stack

Data Analysis Data Architecture Data Warehousing Database Queries Performance Tuning Power BI SQL Stored Procedures SQL Server Reporting Services

Job description

Senior level Data Analyst to support reporting, analytics, and data warehouse efforts following a recent tax accounting system migration. This role is hands on and delivery focused, with responsibility for refining existing data definitions, developing reports, and supporting application migration efforts.

In addition to technical responsibilities, this role will function as a business analyst when needed, working directly with business SMEs to uncover, validate, and clarify data definitions, rules, and logic.

The Senior Data Analyst will partner closely with business analysts, developers, and the IT Project Manager to ensure shared and accurate understanding of data across reporting and application teams.

  • Lead refinement, validation, and ongoing documentation of the existing enterprise data dictionary.
  • Work directly with business SMEs to elicit, clarify, and confirm data definitions, calculations, and business rules.
  • Function as a business analyst when needed to bridge gaps between business understanding and technical implementation.
  • Support and collaborate with business analysts by validating data logic and ensuring consistency across requirements, reports, and applications.
  • Design, develop, and maintain reports using Power BI and SSRS.
  • Assist with conversion and redevelopment of reports impacted by application migrations. *

  • Provide advanced SQL Server expertise including complex queries, functions, and stored procedures.

Requirements

Do you have experience in Technical documentation?, Professional data analysis or business intelligence experience Required 7 Years • Demonstrated experience working in existing production environments under time constraints Required - - Advanced SQL Server knowledge performance tuning and table partitioning Required - - Demonstrated experience with Power BI and or SSRS Required - - Strong experience working with data warehouses Required - - Demonstrated experience eliciting and documenting requirements directly from business stakeholders Required - - Ability to work directly with SMEs, business analysts, developers, and project managers Required - - High level of attention to detail and strong documentation skills Nice to have - - Strong written and verbal communication skills

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

3:22 min

Embracing polyglot persistence versus strictly relational databases

Stefan Priebsch · WWC 2021

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · WWC 2023

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

2:57 min

Core technical practices for robust data engineering

Sandhya Menon Sandhya Menon · WWC Europe 2026

Videos

See all

Related articles

See all