- 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.
- 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 Databricks 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 Client 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.
-
Warehouse Manager
1 week ago
Legends International Tallahassee, United States** Warehouse Manager** · **Job Category****:** Food & Beverage · **Requisition Number****:** PURCH005512 · Showing 1 location · **Job Details** · **Description** · **LEGENDS** · Founded in 2008 as a hospitality management company, Legends has transformed into a holistic experi ...
-
Data warehouse manager
16 hours ago
Resource Informatics Group Tallahassee, United StatesThe 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 Warehouse Director/Manager
3 weeks ago
Crescens Tallahassee, United StatesJob Title: Data Warehouse Director/Manager · Location: Tallahassee, FL · Duration: 3 Years · Job Description · : · Bachelor's or Master's degree in Data Science, Computer Science, Information Systems, or other related field. · Equivalent work experience, including qualified ...
-
Data warehouse manager
3 weeks ago
Resource Informatics Group Tallahassee, United StatesThe 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 dictionari ...
-
Warehouse Department Manager 2
3 weeks ago
Essendant Tallahassee, United States** Warehouse Department Manager 2 (1pm-10pm)** · **Job Category****:** Manager · **Requisition Number****:** WAREH012061 · Showing 1 location · **Job Details** · **Description** · *Proudly, as a team, we have swiftly exercised preventative COVID disciplines within our work env ...
-
Quality Assurance Lead
6 days ago
Compunnel Inc. Tallahassee, United StatesScope of Work: · The Florida Department of Transportation, Office of Information Technology (OIT) - Application Services is in search of an Advanced Quality Assurance Analyst in assisting the Office of Information Technology with infrastructure support for remediations required f ...
-
Quality Assurance Analyst
6 days ago
ISC - IT Staffing & Consulting Tallahassee, United StatesIT Staffing and Consulting, Inc. (ISC) is currently seeking one (1) or more Quality Assurance Analyst(s) Scope Variant Intermediate, and/or Advanced),for our Florida Government client located in Tallahassee, FL. · Please send your resume to: for consideration. · This opportunity ...
-
Operations/Warehouse HR Business Partner
3 weeks ago
PCS Wireless Tallahassee, United States**PCS Wireless** · **Operations/Warehouse HR Business Partner** · **warehouse - Miami Lakes, FL - Full Time** · He or she is responsible for administrating the human resources policies, procedures, and programs that are applied in an organization. Some of the responsibilities inc ...
-
Supply Chain Manager
2 weeks ago
HD Supply Tallahassee, United StatesMust reside in the state(s) specified above. This position is only open to residents in the state(s) specified above. · Preferred Qualifications · At least 5 years of experience using an advanced warehouse management system (WMS) (preferably SAP EWM) · Minimum 2 end to end lif ...
-
Warehouse II
1 week ago
American Tire Tallahassee, United States· Schedule an interview in 5 minutes Text ATD to 25000 or click here: · Position Description: · The primary focus of the Warehouse II role is movement of product within the warehouse. In addition, this role will serve as back-up delivery driver for non-CDL trucks. This is a ge ...
-
Warehouse II
2 days ago
American Tire Tallahassee, United States· Schedule an interview in 5 minutes Text ATD to 25000 or click here: · Position Description: · The primary focus of the Warehouse II role is movement of product within the warehouse. In addition, this role will serve as back-up delivery driver for non-CDL trucks. This is a g ...
-
Warehouse II
1 week ago
American Tire Tallahassee, United StatesJob Description · Schedule an interview in 5 minutes Text "ATD" to 25000 or click here: · Position Description: · The primary focus of the Warehouse II role is movement of product within the warehouse. In addition, this role will serve as back-up delivery driver for non-CDL tr ...
-
BI Analytics Consultant
4 weeks ago
Oracle Tallahassee, United StatesJob Description · Job Description: · Do you want to advance your career with the world's first cloud company? Since 1998, Oracle NetSuite has been on a mission to deliver an agile, unified application suite that gives leaders a complete view into their business. Our team is gro ...
-
SAP Functional Consultant
2 days ago
Saxon Global Tallahassee, United StatesMust-have skills : EDU : Bach/eqiv exp · 3+ with SAP CRM - current main skill · Business Intelligence (BI), Business Warehouse (BW) · PREFERRED : · CAMS (Child support), ALM, ABAP, ECC, SAP S4. · H1B : Yes · Requirements: · Availability to work 100% on Client's site in Tal ...
-
Golf Sales Associate, Part-Time
2 days ago
Worldwide Golf Shops Tallahassee, United States Part timeJob Details · Job Location · Edwin Watts - Tallahassee - Tallahassee, FL · Position Type · Part Time · Description · What We Offer: Our Golf Sales Associates receive base pay plus commission · We offer flexible scheduling, 401(k) matching, and a strong employee discount for ...
-
Golf Sales Associate
2 days ago
Worldwide Golf Shops Tallahassee, United StatesJob Details · Job Location · Edwin Watts - Tallahassee - Tallahassee, FL · Position Type · Full Time · Description · What We Offer: Our Golf Sales Associates receive base pay plus commission · We offer paid vacation, 401(k) matching, and health benefits with company contribu ...
-
Comprehensive Resources Inc Tallahassee, United StatesRole:Project Lead with Data Analyticts with Informatica Experience · Exp:10+years · Loc:Tallahassee,FL(Onsite) · Responsibilities: · • Data Discovery and Inventory: Identify, catalog, and classify data assets, including datasets, databases, and metadata. · • Catalog Metadata Mana ...
-
Senior Project Manager
3 weeks ago
SDI Element Logic Tallahassee, United StatesMain objective: · Lead a team of professionals in completing projects by a set deadline to uphold SDI Element Logic's business initiatives. Ensure projects assigned are completed in a timely fashion and within budget, monitor progress, and keep stakeholders informed the entire wa ...
-
Facilities Support Manager
2 weeks ago
Avant Healthcare Tallahassee, United StatesDo you want to change lives? Are you interested in helping international healthcare professionals achieve their American Dream? If so, join us at Avant · Avant Healthcare Professionals is the premier recruiting and staffing specialist for internationally educated healthcare profe ...
-
Facilities Support Manager
2 weeks ago
Avant Healthcare Tallahassee, United StatesDo you want to change lives? Are you interested in helping international healthcare professionals achieve their American Dream? If so, join us at Avant · Avant Healthcare Professionals is the premier recruiting and staffing specialist for internationally educated healthcare prof ...
Data warehouse manager - Tallahassee, United States - Resource Informatics Group
Description
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: