Data Warehouse Manager at Tallahassee, Florida, USA |
Email: [email protected] |
From: Sanjeev Kumar Singh, Tek Inspirations LLC [email protected] Reply to: [email protected] Job Description - Data Warehouse Manager Terms: 12-month Contract Location: Tallahassee FL Work schedule details: 100% onsite on day 1 Interview Process: 2round Interview Process 1st round with State of Florida, 2nd round with State of Florida Required Experience: see skills matrix above Education Requirements - Masters 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 Required Qualifications Seven (7) or more years experience in a Business Intelligence (BI), Data Engineer, or an ETL role; Proven experience working with SQL databases and Microsoft SQL Server; Proven track record of successful data warehouse implementations; Proven experience in data warehouse design and development; Proven experience in ETL tools, processes, and in data migration projects; Proficient understanding of data warehousing methodologies; Proven proficiency with Microsoft Power BI for creating dashboards and reports; Proven experience with data modeling, data architecture, and data quality concepts; Proven proficiency in SQL and other data languages; Excellent troubleshooting and problem-solving abilities 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, share ideas, and resolve issues; Ability to communicate and interact professionally and tactfully with people of different levels of education, cultural backgrounds, and life experiences and to exhibit respect to others Strong organizational skills and attention to detail, including the ability to adequately establish time frames and deadlines, meet deadlines, and follow through on tasks and assignments 4.3. Preferred Qualifications The Department prefers the Candidate to have the following experience, skills, and/or knowledge for this position: Experience working in the corrections or public safety sector; Experience working with financial systems 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 ML and AI solutions in data warehouse environments; Experience with security technologies around cloud solutions, preferably Azure; Experience managing projects using Scrum and Kanban. Preferred Licensing or Certifications, such as Association for Supply Chain Management (ASCM) Warehousing Certification; Data Warehousing and BI Certification Training; Data Warehousing for Business Intelligence Specialization; BI Foundations with SQL, ETL, and Data Warehousing Specialization, and Enterprise Data Management. 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. Purpose The Florida Department (Department) Office of Information Technology (OIT) is issuing this Request for Quotes (RFQ) to define the scope and requirements of this Task Order pursuant to the State Term Contract (STC) for IT Staff Augmentation Services, 80101507-21-STC-ITSA and/or 80101507-22-STC-ITSA. The responsive Vendor shall provide the Department with a Candidate for the position delineated in Section 1.2, as identified in STC 80101507-21-STC-ITSA and/or 80101507-22-STC-ITSA. The Department reserves the right to secure multiple positions from this job advertisement as needed. Number of positions currently being procured with this RFQ-23-102 for Job # 3410: one (1). General Experience Expectations: Works with the Florida Department Department) Office of Information Technologys (OIT) business and senior IT leadership to identify and establish information requirements and develop and implement data warehouse strategies that utilize data marts and/or data warehouse systems to enhance business processes and manage business intelligence; Leads the activities of data warehouse project teams in the design, development and implementation of data warehouses and the configuration and auditing of data warehouses to ensure quality control of data. Responsible for overseeing the development, operations, and maintenance of the data warehouse environment, including organizational balance and system coherency between front-end desktop/client environment and data warehouse back-end processing functions. Provides guidance regarding the use of data warehouse systems, capability of systems to deliver information, and subject matter expertise regarding current systems and emerging technology. Needed knowledge includes process and data modeling, data architectural development methodology, project management, and extensive knowledge of data warehouses and data marts. . Scope of Work/Job Characteristics 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 Departments Budget and Accounting Information System (BARS) application databases and the current data feeds from the States accounting system, Florida Accounting Information Resource (FLAIR), including but not limited to their structure, data dictionaries, data flow, interdependencies, and potential problem areas; 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, and the new data warehouse is preferred to reside in the Azure cloud); Develop and maintain Extract, Transform, and Load (ETL) processes to migrate data from the new States accounting system, Florida Planning, Accounting, and Ledger Management (PALM), to the new SQL Server data warehouse; Implement data modeling and design techniques to build scalable and efficient data structures to meet the Department's accounting and budgeting reporting needs; Design and create data dashboards, visualizations, and reports using Power Business Intelligence (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, working 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; Develop data mining models to identify trends and patterns within large datasets; Ensure 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; Develop and thoroughly documenting the processes and procedures for the warehouses day-to-day operations, including creating backup plans for disaster recovery in case of equipment failure or data loss; Design and implementing data warehouse solutions that meet the Departments needs while ensuring compliance with industry regulations regarding the security of sensitive data; Work collaboratively with stakeholder 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; Work with the Manager of the Departments Research & Data Team and other stakeholders to accurately integrate collected data into the data warehouse, using descriptive analytics to research and perform statistical analysis to identify actionable insights; Ensure that reporting and key institutional metrics are regularly updated, available, and accurate; Provide expertise to the Data Governance team; Create ad-hoc reports as needed; Stay current of technology and best practices; Regularly attend training and proactively conducts research when available; Oversee the work of several other individuals and must be able to motivate team members, delegate tasks, perform knowledge transfers, 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; and Perform other job-related duties as assigned. Keywords: artificial intelligence machine learning business intelligence active directory information technology Florida Michigan |
[email protected] View all |
Fri Dec 15 05:34:00 UTC 2023 |