Senior Database Architect 1

The Responsibilities And Duties Include

Design and develop data infrastructure for the agency in Microsoft Azure

Recommend and implement solutions for data ingestion, ETL, data warehousing, and data analysis.

Manage access to data infrastructure datasets and analysis tools.

Develop budget for Microsoft Azure tools and provide recommendations on where to manage costs.

Build distributed computing analysis environment within Microsoft Azure in order to conduct more thorough analysis and integrate machine learning/AI tools to environment.

Design and develop database solutions using Microsoft SQL Server and Microsoft Azure tools (SSMS, SSRS, SSIS, Azure Data Factory, Azure Storage).

Manage data in variety of methods, to include SQL databases, NoSQL databases, file storage, and blob storage

Works with IT Architecture staff, CIO and/or IT Managers to design solutions that meet agency requirements

Design and implement high availability solutions

Data modeling to define and analyze data requirements for designing databases/data warehouses

Analyze on-premise database installations for Azure migration

Support data lake enterprise business initiatives

Support production and non-production environments incidents and requests

Code, test, debug, implement, and document data infrastructure design, construction, and remediation

Expert knowledge in SQL skills including stored procedure, trigger, index etc.

Experience with change management with respect to people, processes, and technologies

Develop, maintain, and support business applications (SQL/web-based apps)

Streamline and improve internal processes and reporting

Drive efficiency and operational improvement using data modeling techniques

Support and train users by providing directions, corrections, and enhancements; communicate with users to find solution to case

Analyze user requirements, procedures, and problems to provide coaching on system use, recommend changes and automation to improve efficiency

You'll Need The Following Qualifications And Experience

Bachelor's degree in an appropriate field of study like Computer Science, Data Science, or Information Technology

Minimum seven years of database administration, data science, data engineering, and/or cloud-based data solution engineering.

Previous relevant experience with Microsoft suite of data solutions

Experience conducting performance tuning and configuration, creating data models, and managing data warehouses.

It's a Strong Plus If You Have

Experience with Healthcare/Mental Health environment

Expertise in Python/R programming language

Familiar with reporting tools such as Power BI, Tableau, and Cognos

Collaborate with team leads to identify gaps and constraints associated with business requirements and processes and aid in providing solutions to resolve the process issues

Strong communication and interpersonal skills

Strong organization and time management skills

Ability to effectively handle multiple priorities

Ability to operate across the business and in different environments and cultures