Main Sail, LLC · 6 hours ago
Data Analyst
Columbus, OH
Full-time
Onsite
Senior LevelMain Sail, LLC is seeking a Senior Data Analyst to support the Franklin County Auditor’s Office with reporting, analytics, and data warehouse efforts. The role involves refining data definitions, developing reports, and acting as a business analyst to ensure accurate data understanding across teams.
ConsultingCRMInformation TechnologySoftware
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
Qualification
Required
Senior level Data Analyst experience
Experience supporting reporting, analytics, and data warehouse efforts
Hands-on and delivery focused approach
Experience refining existing data definitions
Ability to develop reports
Experience supporting application migration efforts
Ability to function as a business analyst when needed
Experience working directly with business SMEs
Ability to elicit, clarify, and confirm data definitions, calculations, and business rules
Experience partnering with business analysts, developers, and IT Project Manager
Experience leading refinement, validation, and ongoing documentation of the existing enterprise data dictionary
Experience validating data logic and ensuring consistency across requirements, reports, and applications
Experience designing, developing, and maintaining reports using Power BI and SSRS
Experience assisting with conversion and redevelopment of reports impacted by application migrations
Advanced SQL Server expertise including complex queries, functions, and stored procedures
Experience supporting data warehouse development and optimization including indexing strategies
Ability to query system tables and analyze performance and data behavior
Ability to translate business logic into clear, actionable technical specifications for reporting and analytics
Ability to identify data quality issues and partner with technical teams to define and implement resolutions
Experience documenting data lineage, transformations, and report logic clearly and consistently
Ability to communicate progress, risks, and data related issues to the IT Project Manager
Company
Main Sail, LLC
Main Sail is an information technology company specializing in business process management services.
Founded in 2001
51-200 employees
Funding
Current Stage
Growth StageRecent News
2024-11-05
Company data provided by crunchbase