IT Data Analyst
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 the 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 reports and analytical solutions.
- Collaborate closely with departmental data analysts to understand business requirements and make governed enterprise data available for departmental use.
- Assist citiz