What are the responsibilities and job description for the Data Warehouse with Business Intelligence - Hybrid (Columbus, Ohio) position at Edi Matrix LLC?
Job Description
Job Description:
The Office of Procurement Services (OPS) is seeking staff augmentation services for a technical specialist for fiscal year 2024. This resource is required to support the re-platforming of the OPS Data Analytics warehouse onto the Innovate Ohio Platform (IOP). This resource will perform the following functions:
-Working closely with business leadership team to gather requirements and understanding the dependencies.
-Analyze user and software requirements to determine design feasibility within time and cost constraints.
-Monitoring the existing data collection process to create efficient data warehouse models.
-Observing existing analytical methods to build robust and decision-making visualizations.
-Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
-Design and develop data tables, views, and procedures to store and process the data.
-Develop standard query language (SQL) Server Integration Services packages, coding T-SQL and stored procedures for data conversion, data cleansing and addressing data accuracy and quality.
-Building Extract, Transform, Load (i.e., ETL) jobs and stored procedures to transform data from variety of sources into several data marts within a centralized data warehouse system.
-Migrate legacy databases to data warehousing systems model.
-Develop integration rules to improve the performance of data reading and data writing of data marts.
-Performing ad-hoc data import and export jobs for ad-hoc requirements.
-Design analytical friendly database table and column structure along with user specific calculation or indicators.
-Creating email notifications for data processing performance and exception handlings.
-Developing data driven interactive dashboards and insights using Tableau Desktop/Prep/Server.
-Migrating legacy MS excel, MS access-based reports to Tableau based visualizations and use data warehouse live connections.
-Working with business stakeholders and development team to improve the outcome of implementations.
-Monitor and support incremental data importing jobs and execution errors, as well as working with administrative team to debug environment and security problems.
-Provide training to internal teams and assist with expert knowledge on best practices for creating data flow and decision-making visualizations.
-Generating reports for data collection, changes, and quality positions to management team.
-Balancing the data load based on variety of data and volume.
-Writing unit and user test cases to identify data changes and data integrity.
-Debugging the data problems for ongoing data issues.
-Creating data dictionary, data mapping, and work process flow documents.
-Collect and document user requirements and develop logical and physical specifications.
-Provide technical design documents for all reports created.
REQUIRED:
- Conveying technical and functional concepts for a specific technical specialty - 10 years.
- Supporting and designing industry specific applications that require integration with statewide systems or applications - 10 years.
- Interacting with executive level business users or technical experts - 10 years.
- Advanced experience in database administration, SQL, Tableau Desktop/Prep/Server, and procurement and finance - 10 years.
- Designing and implementing an architecture to provide data ingestion, curation, and presentation - 10 years.
Salary : $80 - $90
Business Intelligence Analyst
Revel IT -
Columbus, OH
Business Intelligence Analyst
NFI -
Columbus, OH
Manager, Business Intelligence & Analytics
FlightSafety International -
Columbus, OH