Data Analyst / Scientist
Oak Harbor Freight Lines is seeking a skilled and highly analytical Data Analyst /Scientist to join our Information Technology team. This role will be responsible for transforming complex operational and business data into meaningful insights that support strategic decision-making, improve operational efficiency, and identify opportunities for continuous improvement.
The ideal candidate combines strong technical and analytical capabilities and the ability to communicate complex data in a clear, meaningful way. This individual will partner closely with departments throughout the company to understand business needs, analyze trends, develop data repository, and develop analytical solutions.
The position will also support the development of Oak Harbor's overall data and analytics capabilities including hub and spoke architecture, AI-ready data platform, data pipeline, quality data, and automation.
Duties and Responsibilities:
Analyze, profile, document, clean, validate, transform, and organize enterprise data.
Design, develop, support, and troubleshoot ETL/ELT processes that move data from operational systems into a centralized data hub.
Develop repeatable processes for acquiring, transforming, storing, and publishing enterprise data.
Create and maintain documentation covering data sources, definitions, transformations, dependencies, lineage, and integrations.
Identify and resolve data-quality, completeness, consistency, and integration issues.
Work with IT Developers, Infrastructure, Application Support, and outside vendors to make application and vendor data available to the enterprise data platform.
Support APIs, database connections, data extracts, files, and other approved methods for bringing data into the data hub.
Serve as a DataFi (data visualization application) administrator and platform subject-matter expert.
Administer the organization's certification process for departmental DataFi developers and citizen developers.
Establish and enforce DataFi development, testing, publishing, documentation, security, and governance standards
Platform administrator and subject-matter expert for enterprise data visualization platform DataFi and establish appropriate development, testing, deployment, documentation, and production-support standards.
Work with business stakeholders and departmental analysts to establish common data definitions, ownership, stewardship, and data-quality expectations
Serve as a technical owner and administrator of the enterprise data hub, monitoring nightly data loads, ETL processes, platform performance, data availability, capacity, usage, and security; Ensure production data assets are properly documented, supported, governed, and assigned appropriate ownership
Assist in developing reports, dashboards, analytics, and data visualizations using DataFi, Power BI, Teams, and SharePoint.
Assist departments in identifying appropriate sources of enterprise data for report