Columbus, Ohio
Job Duties and Responsibilities:
- This position plays an important role in designing and constructing the agency’s data infrastructure using Microsoft Azure.
- This role will serve as the primary point of contact for the agency’s migration of its on-premises data warehouse and analysis workspace to Microsoft Azure.
- 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
Required Skills
- 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.
- Expert knowledge in SQL skills including stored procedure, trigger, index, etc.
- Microsoft Azure
Preferred Experience:
- 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