Senior Data Analyst - Columbus Ohio Onsite - Need only "Ohio" based candidates.
Hi, please review the job description below, if interested for the below position, revert me with your updated resume
Job Details:
Position: Senior Level Data Analyst
Location: 373 S High St 9th floor, Columbus, OH 43215 (Onsite 5 days per week)
Duration: Long-Term
Mode of Interview: Video call
Job Description:
Full Time ONSITE.
Contract with Possible Extension or Hire.
The Franklin County Auditor's Office is seeking a 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.
Essential Duties and Responsibilities:
?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.
?Support data warehouse development and optimization including indexing strategies.
?Query system tables and analyze performance and data behavior to support reporting and application needs.
?Translate business logic into clear, actionable technical specifications for reporting and analytics.
?Identify data quality issues and partner with technical teams to define and implement resolutions.
?Document data lineage, transformations, and report logic clearly and consistently.
?Communicate progress, risks, and data related issues to the IT Project Manager.
?Perform other related duties as assigned.
Required/Desired Skills:
| Skill | Required /Desired | Amount | Years of Experience |
| Professional data analysis or business intelligence experience | Required | 7 | |
| Demonstrated experience working in existing production environments under time constraints | Required | 0 | |
| Advanced SQL Server knowledge performance tuning and table partitioning | Required | 0 | |
| Demonstrated experience with Power BI and or SSRS | Required | 0 | |
| Strong experience working with data warehouses | Required | 0 | |
| Demonstrated experience eliciting and documenting requirements directly from business stakeholders | Required | 0 | |
| Ability to work directly with SMEs, business analysts, developers, and project managers | Required | 0 | |
| High level of attention to detail and strong documentation skills | Nice to have | 0 | |
| Strong written and verbal communication skills | Desired | 0 | |
| Experience supporting financial, tax, or property related systems | Highly desired | 0 | |
| Experience assisting with system migrations or large scale report conversions | Highly desired | 0 | |
| Experience independently validating data logic and resolving ambiguity | Highly desired | 0 | |
| Experience working in public sector or highly visible environments | Highly desired | 0 | |
| Willing to work at onsite 5 days per week ? | Required (Yes/No) | | |
| Do you understand this position is onsite Monday through Friday at 373 S High St, Columbus, Ohio 43215? A hybrid schedule may be considered after several weeks based on performance and team needs, but candidates should expect this role to remain primarily onsite. | Required (Yes/No) | | |
| What is your earliest start date? | | | |
--
Regards,
Vijay
Sr. Resource Coordinator.
Never miss an opportunity! Create an alert based on the job you applied for.
