The Senior Data Infrastructure Engineer will help define and deploy enterprise data infrastructure, architecture, design, implementation and maintain for standardized access, analytics, and business intelligence. The Senior Data Infrastructure Engineer will be a central resource for architecture, design, implementation and maintaining on-premises and Azure Cloud enterprise data infrastructure for the county extract, transform, and load (ETL) environment. 

The Senior Data Infrastructure Engineer is an experienced professional reporting to the Chief Technology Officer, working closely with cross-functional teams from various departments to provide recommendations for optimized data infrastructure architecture based on the data storage and retrieval needs for Guilford County and within each department. The ideal candidate will have proven experience with Azure Cloud and on-premises data infrastructure architecture, design, implementation, dimensional modeling, Master Data Management (MDM), Business Intelligence (BI) and Extract, Transform, and Load (ETL). A key function of this position will be to implement best practice for Azure Cloud and on-premises data infrastructure architecture, design, and implementation. The Senior Data Infrastructure Engineer will be responsible for constantly monitoring our enterprise data infrastructure architecture and quickly addressing any issues.

DUTIES AND RESPONSIBILITIES

Essential duties and responsibilities include, but are not limited to:

• Provide architecture, design, implementation, and maintenance of data infrastructure environment in Azure and on-premises for distributed BI systems within the county.
• Design, build, support and maintain countywide BI database systems including Azure Cloud and Microsoft SQL Server, and other technologies. 
• Deploy, configure, and implement Azure resources, including virtual machines, storage accounts, networking components, and Azure Active Directory
• Build / maintain the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and other related technologies.
• Collaborate with stakeholders to design Azure and on-premises infrastructure solutions that meet business requirements, ensuring scalability, availability, and security.
• Identify, design, and implement internal process improvements for automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Analyze data infrastructure architecture implementation methods to make sure they are in line with county policies, external regulations, and adopted standards.
• Create data monitoring models for each product and work with our software and application development teams to create models ahead of new releases. 
• Ensure architecture integrity and security of county data assets. 
• Provide guidance, assistance and support for creation and maintenance of complex data sets that meet cross-functional requirements. 
• Work with cross functional stakeholders to assist with data-related technical issues and support their data infrastructure needs.
• Monitoring and performance optimization for system monitoring of Azure infrastructure performance, identify bottlenecks, and proactively optimize resource utilization.
• Design and implement backup and disaster recovery solutions for on-premises, Azure infrastructure, including backup policies, site recovery, and high availability configurations.
• Create and maintain database and architecture documentation, including infrastructure diagrams, configuration details, storage standards, backup and recovery, disaster recovery, cost analysis, and standard operating procedures.
• Implement and maintain robust security controls and best practices on-premises and Azure environments, ensuring compliance with relevant industry regulations (e.g., GDPR, HIPAA, CJIS).
• Collaborate with internal teams on design and implementation of backup and disaster recovery solutions for on-premises and Azure infrastructure including backup policies, site recovery, and high availability configurations.
• Other duties as assigned.

RECRUITMENT STANDARDS

Knowledge, Skills, and Abilities

• Architecture and implementation experience with data integration experience (Azure Data Factory, Databricks, Azure Synapse Analytics, SQL Server Integration Services, etc.) for an Ingest, Store, Process, Enrich, and Serve model for both on-premises and Azure Cloud Environment. 
• Strong understanding of implantation, design and maintain analytics end-to-end with Azure Synapse and experience with SQL Server, Power BI solution delivery experience with different sources (structured, semi-structured, unstructured, and streaming).
• Sound working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience with software tools such as Visual Studio, Microsoft SQL Server Reporting Services, Integration Services and Management Studio, Microsoft PowerBI, and Tableau 
• Data Visualization experience (Power BI, Tableau, QlikView, etc.)
• Programming experience (C#, Python, T-SQL, Scala, Java)
• Knowledge of Azure security features, including Azure Security Center, Azure Active Directory, and Azure RBAC.
• Familiarity with DevOps practices, continuous integration/continuous deployment (CI/CD), and automation tools such as Azure DevOps or GitHub Actions.
• Solid understanding of networking concepts, virtual private networks (VPNs), and firewall configurations in Azure.
• Solid understanding of Azure infrastructure best practices.
• Must possess exceptional analytical and troubleshooting abilities.
• Highly motivated, self-starter individual with strong sense of ownership
• Must be proactive with solid organizational and time management skills.
• Good written and verbal skills
• Strong analytic skills related to working with structured and unstructured data.
• Ability to build processes supporting data transformation, data structures, metadata, dependency and workload management.
• A successful history of manipulating, processing, and extracting value from large, disconnected datasets for both internal and external data infrastructure models.
• Experience in troubleshooting Azure infrastructure issues, conducting root cause analysis, and implementing corrective actions.
• Strong project management and organizational skills.
• Ability to solve complex data design problems. 
• Implement monitoring solutions, set up alerts, and conduct performance tuning for optimal efficiency

Bachelor’s degree in Computer Science, Statistics, Information Systems or another quantitative field with 3 years of experience in a Database Administration and/or Sr. Data Infrastructure Engineer role OR 

Associate Degree in Computer Science, Statistics, Information Systems or another quantitative field with 5 years of experience in Database Administration, Cloud Infrastructure Administration and/or Sr. Data Infrastructure Engineer role.

An employee in this position must be able to physically perform the basic life operational functions of walking, fingering, grasping, talking, hearing, and repetitive motions. The employee must be able to perform sedentary work exerting up to 10 pounds of force occasionally to lift, carry, push, pull or otherwise move objects.

Work consists of an office environment with no adverse environmental conditions.

May Require Driving 

This position may require driving for this position whether driving a County owned or personal vehicle to conduct county business such as but not limited to attending conferences, meetings, or any other county related functions. Motor Vehicle Reports may be verified for valid driver’s license and that the driving record is compatible with the county’s driving criteria. 

If a personal vehicle is operated for county business proper insurance is maintained as per Guilford County’s vehicle use policy. 

Special Note: This generic class description gives an overview of the job class, its essential job functions, and recommended job requirements. However, for each individual position assigned to this class, there is available a completed job questionnaire with a physical abilities checklist which can give further details about that one specific position. Those documents should be reviewed before initiating a selection process. They can provide additional detailed information on which to base various personnel actions and can assist management in making legal and defensible personnel.