Job Purpose:

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 environments including 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 development lifecycle. The Data Warehouse Administrator is responsible for data loading and manipulation to ensure that the data sources are efficiently and effectively loaded into the data warehouse.

Minimum Requirements:

Qualifications

Bachelor s Degree in Computer Science or Information systems or equivalent combination of education and relevant experience.

Experience

1. Minimum 2 years experience with MS Azure SQL Server and Azure Data warehouse environment.

2. Minimum 2 years experience with building, deploying, troubleshooting Data Extraction, and loading jobs using Azure data factory.

3. Minimum 5 years experience with Agile methodology and Scrum Framework.

4. Minimum 2 years DevOps experience and CI/CD methodology.

5. Minimum 5 years experience in authoring and troubleshooting SQL Queries, Stored Procedures and ETL Processes.

6. Proficiency in Python or Powershell.

Primary Job Duties/ Tasks

The submitted candidate must be able to perform the following duties and/or tasks:

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 back-end 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 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 Row-Level 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 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.

About ArnAmy, Inc.:

ArnAmy, Inc. is a leading information technology consulting and software development firm in Tallahassee, FL since 2007. ArnAmy has been providing high quality services to clients and prides itself in implementing dependable solutions to ensure client's success. ArnAmy is formed and led by principle centered leaders with Subject Matter Expertise in all disciplines of Information Technology. Company has proven record of 100% successful projects and 100% satisfied clients, and employees. We are inviting bright professionals with integrity and have passion to achieve higher goals to join our award winning (Tallahassee s BEST in IT Solutions 2017 &2016) excellent and talented team.

ArnAmy, Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability or marital status. Women and Minorities are encouraged to apply.

PLEASE SEND RESUMES AND SALARY EXPECTATIONS TO THANK YOU!