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 a “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.
- Assist 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:
- Master’s or bachelor’s degree, from an accredited college/university, in Computer Science, Information Systems, or other related field, or four (4) years of equivalent work experience.
- Seven (7) or more years’ experience in a Business Intelligence (BI), Data Engineer, or an ETL role.
- Proven experience working with IBM DB2 databases and Microsoft SQL Server.
- Proven track record of successful data warehouse implementations.
- Strong background in data warehouse design and development.
- Proficient in ETL tools and processes, with experience in data migration projects.
- Proficient understanding of data warehousing methodologies.
- Experience with Microsoft Power BI for creating dashboards and reports.
- Excellent understanding of data modeling, data architecture, and data quality concepts.
- Proficiency in SQL and other data languages.
- Excellent troubleshooting and problem-solving abilities.
- Strong communication skills, capable of explaining complex concepts to non-technical stakeholders.
- Must be able to clearly convey information and ideas in both written and verbal forms to share information and ideas and resolve issues.
- Strong written and verbal communication skills required.
- Ability to communicate/interact professionally and tactfully with people of different levels of education, cultural backgrounds, and life experiences, and to exhibit respect to others.
- Organizational skills with strong attention to detail including the ability to adequately establish time frames and deadlines, to meet deadlines, and to follow through on tasks and assignments.
- Experience working in the corrections or public safety sector.
- Previous involvement in public sector IT projects.
- Experience working with large datasets and data lakes.
- Experience with other data visualization tools.
- Familiarity with Data bricks SQL.
- Experience with Big Data technologies
- Familiarity with Machine Learning (MI) and Artificial Intelligence (AI) concepts and their application in data analysis.
- Experience in implementing ML and AI solutions in data warehouse environments.
- Experience with security technologies around cloud solutions, preferably Azure; and
- Experience managing projects using Scrum and Kanban.
- Preferred Licensing or Certifications, such as:
- ASCM Warehousing Certification.
- Data Warehousing and BI Certification Training.
- Data Warehousing for Business Intelligence Specialization.
- BI Foundations with SQL, ETL and Data Warehousing Specialization.
- Enterprise Data Management.
Department: Preferred Vendors
This is a contract position