The Senior Data Analyst role within the Franklin County Auditor's Office focuses on supporting reporting, analytics, and data warehouse efforts following a tax accounting system migration. This hands-on position involves refining data definitions, developing reports, and supporting application migrations. The analyst will also act as a business analyst, working with subject matter experts to clarify data definitions and rules.
Location:Ohio, United States
Responsibilities:
- Lead refinement, validation, and documentation of the enterprise data dictionary.
- Work with business SMEs to elicit and confirm data definitions, calculations, and business rules.
- Function as a business analyst to bridge gaps between business understanding and technical implementation.
- Support 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 Skills & Certifications:
- 7 years of professional data analysis or business intelligence experience.
- Demonstrated experience working in existing production environments under time constraints.
- Advanced SQL Server knowledge, performance tuning, and table partitioning.
- Demonstrated experience with Power BI and/or SSRS.
- Strong experience working with data warehouses.
- Demonstrated experience eliciting and documenting requirements directly from business stakeholders.
- Ability to work directly with SMEs, business analysts, developers, and project managers.
Preferred Skills & Certifications:
- High level of attention to detail and strong documentation skills.
- Strong written and verbal communication skills.
- Experience supporting financial, tax, or property-related systems.
- Experience assisting with system migrations or large-scale report conversions.
- Experience independently validating data logic and resolving ambiguity.
- Experience working in the public sector or highly visible environments.
Special Considerations:
Scheduling:
...Job Title: Histology Assistant Location:Community Medical Center Department:Lab CMC Req#:193792 Status: Per Diem Shift: Evening Pay Range: $22.50 - $22.50per hour Pay Transparency: The above pay range reflects the anticipated per hour range for...
...Job Description We are actively seeking a skilled and experienced Roofer to join our team. Our companys Roofers repair the customers existing roofing systems and install new roofing systems where required. Additional duties involve clearing hazards from the nearby...
...Toonen Properties is seeking a full-time Leasing Agent to join our team in Green Bay. Toonen Properties is a family-owned and independent company dedicated to delivering exceptional living experiences for our residents. We value our employees and foster a collaborative...
Senior Associate, Product Manager - Bank Moderinzation Product Management at Capital One is a booming, vibrant craft that requires reimagining the status quo, finding value creation opportunities, and driving innovative and sustainable customer experiences through...
We are seeking a dedicated Travel Nurse for the ICU in Bellflower, CA, offering $2,699/week. Provide critical care nursing to ICU patients, monitoring vital signs, administering medications, and supporting life-saving procedures. Assess patient conditions, develop...