Tech Evaluation Login
Tech Evaluation Signup
PasswordReset
Unsubscribe
PasswordReset
PasswordReset
PasswordReset
Register for Webinar
Register for Event
Job Channels
Skill Score
About Us
Contact Us
Our Blog
Toggle navigation
Home
Skill Score
DemandIndex
Jobs
FETCH Jobs
Java J2EE
Dot Net, C#
DBA
SAP
Admin, Networking
Datawarehousing
QA
Demo
Candidate
Recruiter
Services
Job Posting & Resume Access
Integrated Talent Sourcing
Sub Contractor Supply Chain
Merger & Acquisition
Candidate
Post Resume
Login
Create Job Alert
Recruiter
Login
Free Trial
Signup
Pricing
| Pricing
Dashboard
My Resumes
Resume List
Add Resume
Edit / Update Resume
My Jobs
Fetch Jobs
Matched Jobs
Applied Jobs
Datawarehouse Manager
Tallahassee, FL
Tallahassee
FL
32399
Date
: Jul-07-23
2023-07-07
2024-07-07
Datawarehouse Manager
Tallahassee, FL
Jul-07-23
Work Authorization
US Citizen
GC
H1B
GC EAD
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
1099-Contract
Contract to Hire
Job Details
Experience
:
Junior
Rate/Salary ($)
:
BASED ON EXPERIENCE
Duration
:
3 Months
Sp. Area
:
Data Warehousing/ETL
Sp. Skills
:
Data Modeler
Consulting / Contract
CONTRACTOR
Required Skills
:
Data Warehousing, Business Intelligence, ETL, Security, SQL, Artificial Intelligence, DB2, Data Modeling, SQL Server, Windows Azure, ACTIVE DIRECTORY,
Preferred Skills
:
Domain
:
Work Authorization
US Citizen
GC
GC EAD
H1B
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
1099-Contract
Contract to Hire
Job Details
Experience
:
Junior
Rate/Salary ($)
:
BASED ON EXPERIENCE
Duration
:
3 Months
Sp. Area
:
Data Warehousing/ETL
Sp. Skills
:
Data Modeler
Consulting / Contract
CONTRACTOR
Required Skills
:
Data Warehousing, Business Intelligence, ETL, Security, SQL, Artificial Intelligence, DB2, Data Modeling, SQL Server, Windows Azure, ACTIVE DIRECTORY,
Preferred Skills
:
Domain
:
Omega Solutions, Inc
Santa Clara, CA
Post Resume to
View Contact Details &
Apply for Job
Job Description
:
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 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.
Preferred Qualifications:
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.
Location
Tallahassee, Florida
Client :
Omega Solutions
Turn OFF keyword highlights