Datawarehouse Manager

Job Title : Data Warehouse Manager

Job Location : Tallahassee, FL - Must work on site

Job Duration : Annual Contract

Job Overview :

The Data Warehouse Manager will serve as the principal line of communication for the project team. The duties and responsibilities of this position are as follows :

• Document the current state of the IBM DB2 databases, including but not limited to their structure, data dictionaries, data flow, interdependencies, and potential problem area.
• Design, develop, and implement a new Microsoft Structured Query Language (SQL) Server data warehouse, ensuring it meets the project requirements and aligns with the overall data strategy of the Department.
• The Department is under "cloud first" initiative so it is preferred that the new data warehouse reside in the Azure cloud.
• Develop and maintain Extract, Transform, and load (ETL) processes to migrate data from the existing DB2 databases to the new SQL Server data warehouse.
• Implement data modeling and design techniques to build scalable and efficient data structures.
• Design and create data dashboards, visualizations, and reports using Power BI, providing critical insights to stakeholders.
• Troubleshoot any issues that arise in the data warehouse and implement solutions.
• Collaborate with other team members, stakeholders, and data users to ensure the new data warehouse meets the needs of the Department.
• Continuously monitor, refine, and report on the performance and capacity of the data warehouse.
• Configure and administer data warehouse security settings. Work closely with the Information
• Security team to ensure the best practices are in place.
• Stay up to date on new data warehousing technologies and approaches.
• Train and mentor less experienced team members.
• Coordinate with other IT teams to ensure smooth data warehouse operations.
• Handle incident management and problem resolution for data warehouse issues.
• Developing data mining models to identify trends and patterns within large datasets.
• Ensuring that data is accurate and clean, using statistical methods such as data profiling and data quality analysis to identify potential problems with data quality before using it in reports or analyses.
• Developing the processes and procedures for the warehouse's day-to-day operations, including creating backup plans for disaster recovery in case of equipment failure or data loss.
• Designing and implementing data warehouse solutions that meet client needs while ensuring compliance with industry regulations regarding security of sensitive data.
• Work collaboratively with stakeholders' teams to compile audience profiles, insights, and measurement plans.
• Create simple, easy-to-follow reports and dashboards that key department heads will utilize on a regular basis to make informed business decisions.
• Work with multiple Project Managers to deliver capabilities / projects / data sets / reports that have been prioritized by the Business Product Owners.
• Partners with the Manager of Research and other stakeholders to accurately integrate collected data into the data warehouse. Using descriptive analytics, researches and performs statistical analysis to identify actionable insights.
• Ensures that reporting and key institutional metrics are regularly updated, available, and accurate.
• Provides expertise to the Data Governance team.
• Create ad-hoc reports as needed.
• Stays current of technology and best practices. Regularly attends training and proactively conducts research when available.
• ssist in overseeing the work of several other individuals.
• Must be able to motivate team members, delegate tasks, perform knowledge transfer and mentor staff.
• Must be able to handle all duties and information in a confidential manner.
• Must have the ability to simplify information systems and make sound business decisions.
• Perform other job-related duties as assigned.

Required Experience :

Preferred Qualifications :

SCM Warehousing Certification.

Location

Tallahassee, Florida