Data Warehouse Admin....
Data Warehouse Administrator
Posted on :
09-05-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Req ID : 2824961
Client: State of Florida
Job Title: Data Warehouse Administrator
Duration: 12 Months
Start Date: ASAP
Location: Remote
Job Title: Data Warehouse Administrator
Duration: 12 Months
Start Date: ASAP
Location: Remote
Position Type: Contract
Interview Type: WebCam
Ceipal ID: SFLDATAP01AJ
Job ID: RFQ0P01
Interview Type: WebCam
Ceipal ID: SFLDATAP01AJ
Job ID: RFQ0P01
Department: Florida Virtual School
Description:
The Data Warehouse Administrator participates in the design implementation and ongoing modification of a modern architecture solution in Azure. The Data Warehouse Administrator works with internal team members and contractors to develop new and support existing data warehouse and data reporting environmentsincluding Azure Data Lake SQL Data Warehouse Synapse SSRS SSAS and Power BI. The Data Warehouse Administrator works alongside other Data Services team members using DevOps to provide and support continuous delivery and implementation on the development lifecycle. The Data Warehouse Administrator is responsible for data loading and manipulation to ensure that the data sources are efficiently and efficiently loaded into the data warehouse.
The Data Warehouse Administrator participates in the design implementation and ongoing modification of a modern architecture solution in Azure. The Data Warehouse Administrator works with internal team members and contractors to develop new and support existing data warehouse and data reporting environmentsincluding Azure Data Lake SQL Data Warehouse Synapse SSRS SSAS and Power BI. The Data Warehouse Administrator works alongside other Data Services team members using DevOps to provide and support continuous delivery and implementation on the development lifecycle. The Data Warehouse Administrator is responsible for data loading and manipulation to ensure that the data sources are efficiently and efficiently loaded into the data warehouse.
Responsibilities:
- Develop and manage effective working relationships with other departments groups and personnel with whom work must be coordinated or interfaced.
- Establish and enforce data warehousing standards to meet requirements and business needs.
- Evaluate our current backend processes. Create and improve the underlying data design and flow of information.
- Utilize Azure stick modules such as Data Factories Data Lake SQL DW and Synapse in support of ongoing data warehouse and reporting needs.
- Assist in the overall architecture of the Azure Data Vault utilizing Data Vault 2.0 best practices.
- Interpret business requirements and actively provide input from a data perspective.
- Build simple to complex pipelines and dataflows.
- Build reliable scalable distributed systems for data analytics and reporting.
- Coach guide and mentor team members on Azure development best practices.
- Implement and maintain security and authorization framework modules.
- Integrate and maintain the RowLevel Security (RLS) methodology.
- Conduct root cause analysis and resolve performance and production problems and data issues.
- Provide ongoing maintenance and support of Azure data environment.
- Document technical designs and architecture workflow dataflow and processes.
- Validate the accuracy and consistency of the data in the database and test the developed routines.
- Meet professional obligations through efficient work habits such as meeting deadlines honoring schedules coordinating resources and meetings in an effective and timely manner and demonstrating respect for others.
- All work responsibilities are subject to having performance goals and/or targets established.
- Provide a minimum of weekly status report updates for current projects.
Required:
- Bachelors Degree in Computer Science or Information systems or equivalent combination of education and relevant experience.
- Minimum 2 years experience with MS Azure SQL Server and Azure Data warehouse environment.
- Minimum 2 years experience with building deploying troubleshooting Data Extraction and loading jobs using Azure data factory.
- Minimum 5 years experience with Agile methodology and Scrum Framework.
- Minimum 2 years DevOps experience and CI/CD methodology.
- Minimum 5 years experience in authoring and troubleshooting SQL Queries Stored Procedures and ETL Processes.
- Proficiency in Python or Powershell.
V Group Inc. is an IT Services company which supplies IT staffing project management and delivery services in software network help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: AR CA DE FL GA IL KY MD ME MI NC NJ NY OH OR PA SC TX VA and WA. If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Please share my contact information with others working in Information Technology.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
