Guilford County, NC
Senior Azure Cloud Engineer
Guilford County, NC, Greensboro, North Carolina, us, 27497
Salary :
$87,259.00 - $109,073.00 Annually
Location :
201 West Market Street Greensboro, NC
Job Type:
Full Time
Remote Employment:
Remote Optional
Job Number:
03465
Department:
Information Technology
Opening Date:
09/11/2024
Closing Date:
10/21/2024 11:59 PM Eastern
GUILFORD COUNTY GOVERNMENT
Empower
Successful People
to thrive in a
Strong Community
supported by
Quality Government
Transparency & Communication | Equity & Inclusion | Accountability
Service & Outcomes Excellence | Our People Matter
Description
GENERAL STATEMENT OF DUTIESThe Senior Azure Cloud Engineer will help define and deploy enterprise data infrastructure, architecture, design, implementation and maintain for standardized access, analytics, and business intelligence. The Senior Azure Cloud 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.
DISTINGUISHING FEATURES OF THE CLASSThe Senior Azure Cloud 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 Azure Cloud Engineer will be responsible for constantly monitoring our enterprise data infrastructure architecture and quickly addressing any issues.
T
his position is 100% remote (optional); however, the successful candidate must live within three driving hours (approximately 175 miles of Greensboro, North Carolina).Examples of Duties
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 DirectoryBuild / 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 TableauData 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 ownershipMust be proactive with solid organizational and time management skills.Good written and verbal skillsStrong 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
Typical Qualifications
MINIMUM QUALIFICATIONSBachelor'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.
PREFERRED QUALIFICATIONSExperience implementing and working with Microsoft Azure Synapse.
*A skills assessment may be administered during the interview process.Supplemental Information
Physical DemandsAn 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.
Working ConditionsWork 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.
Guilford County is committed to providing Equal Employment Opportunity (EEO) to employees and applicants for employment regardless of color, religion, sex, national origin, age, disability, genetic information, sexual orientation or political affiliation. The County is committed to complying with all applicable federal, state and local laws that pertain to employment, and to providing a work environment that is free from discrimination of any kind. If you need an auxiliary aide, make the request forty-eight (48) hours in advance of the time the accommodation is needed by calling 336-641-3324.
We are excited about the opportunity of having you as a prospective new employee!
You probably already know our county is a wonderful county to live in, but did you know it is also a wonderful place to work?
Below are a few of the reasons why we love working for Guilford County.
We offer Health Insurance ( UnitedHealthCare ) to all benefitted employees working a minimum of 20 hours per week. The shared cost of the premium is based on scheduled/budgeted hours. If you are a full-time employee working 40 hours a week you can expect to pay less than $35 a month for medical coverage, dental coverage for $4 a month and vision coverage for $5 a month. That's less than $45 a month for medical, dental & vision coverage; that's unheard of.
Telehealth UHC Virtual Visits are available to you with no copay or out of pocket expense.
We are excited to inform you Guilford County has an
Employee Wellness Center
(24/7 access) with strength training equipment, cardio machines and a group exercise room with virtual or in person coaching from our Wellness Specialist!
Employee Assistance Program , 100% funded by the county. A superb benefit for you and your family absolutely free. Confidential help with personal or work-related issues.
13 paid holidays, 12 sick days, and 12 vacation days a year.
That's 37 paid days a year, totaling almost 2 months of paid time off.
Employer contributes
5% into your 401(k)
- no match required.
Enrollment in the
State Retirement Plan
by contributing 6%.
Longevity pay
beginning at five years of service.
We provide a $10,000
Life and AD&D
benefit to eligible employees.
Flexible spending accounts
(FSA) allow you to set aside tax-free dollars for health care and dependent care.
Voluntary Life, AD&D, Short-Term and Long-Term Disability.
01
Which best describes your level of education?
High schoolAssociate's degreeBachelor's degreeMaster's degree or higher
02
If you have a degree, is the major field of study in Computer Science, Statistics, Information Systems or another quantitative field?
YesNoI do not have a degree
03
Which best describes your years of experience in Database Administration, Cloud Infrastructure Administration and/or Sr. Data Infrastructure Engineer role?
Less than 1 year1 year than 3 years3 years less than 5 years5 or more years
04
Please share your experience implementing and working with Microsoft Azure?
05
I understand this position is position is 100% remote optional; however, the successful candidate must live within three driving hours (approximately 175 miles of Greensboro, North Carolina).
YesNo
Required Question
$87,259.00 - $109,073.00 Annually
Location :
201 West Market Street Greensboro, NC
Job Type:
Full Time
Remote Employment:
Remote Optional
Job Number:
03465
Department:
Information Technology
Opening Date:
09/11/2024
Closing Date:
10/21/2024 11:59 PM Eastern
GUILFORD COUNTY GOVERNMENT
Empower
Successful People
to thrive in a
Strong Community
supported by
Quality Government
Transparency & Communication | Equity & Inclusion | Accountability
Service & Outcomes Excellence | Our People Matter
Description
GENERAL STATEMENT OF DUTIESThe Senior Azure Cloud Engineer will help define and deploy enterprise data infrastructure, architecture, design, implementation and maintain for standardized access, analytics, and business intelligence. The Senior Azure Cloud 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.
DISTINGUISHING FEATURES OF THE CLASSThe Senior Azure Cloud 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 Azure Cloud Engineer will be responsible for constantly monitoring our enterprise data infrastructure architecture and quickly addressing any issues.
T
his position is 100% remote (optional); however, the successful candidate must live within three driving hours (approximately 175 miles of Greensboro, North Carolina).Examples of Duties
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 DirectoryBuild / 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 TableauData 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 ownershipMust be proactive with solid organizational and time management skills.Good written and verbal skillsStrong 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
Typical Qualifications
MINIMUM QUALIFICATIONSBachelor'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.
PREFERRED QUALIFICATIONSExperience implementing and working with Microsoft Azure Synapse.
*A skills assessment may be administered during the interview process.Supplemental Information
Physical DemandsAn 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.
Working ConditionsWork 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.
Guilford County is committed to providing Equal Employment Opportunity (EEO) to employees and applicants for employment regardless of color, religion, sex, national origin, age, disability, genetic information, sexual orientation or political affiliation. The County is committed to complying with all applicable federal, state and local laws that pertain to employment, and to providing a work environment that is free from discrimination of any kind. If you need an auxiliary aide, make the request forty-eight (48) hours in advance of the time the accommodation is needed by calling 336-641-3324.
We are excited about the opportunity of having you as a prospective new employee!
You probably already know our county is a wonderful county to live in, but did you know it is also a wonderful place to work?
Below are a few of the reasons why we love working for Guilford County.
We offer Health Insurance ( UnitedHealthCare ) to all benefitted employees working a minimum of 20 hours per week. The shared cost of the premium is based on scheduled/budgeted hours. If you are a full-time employee working 40 hours a week you can expect to pay less than $35 a month for medical coverage, dental coverage for $4 a month and vision coverage for $5 a month. That's less than $45 a month for medical, dental & vision coverage; that's unheard of.
Telehealth UHC Virtual Visits are available to you with no copay or out of pocket expense.
We are excited to inform you Guilford County has an
Employee Wellness Center
(24/7 access) with strength training equipment, cardio machines and a group exercise room with virtual or in person coaching from our Wellness Specialist!
Employee Assistance Program , 100% funded by the county. A superb benefit for you and your family absolutely free. Confidential help with personal or work-related issues.
13 paid holidays, 12 sick days, and 12 vacation days a year.
That's 37 paid days a year, totaling almost 2 months of paid time off.
Employer contributes
5% into your 401(k)
- no match required.
Enrollment in the
State Retirement Plan
by contributing 6%.
Longevity pay
beginning at five years of service.
We provide a $10,000
Life and AD&D
benefit to eligible employees.
Flexible spending accounts
(FSA) allow you to set aside tax-free dollars for health care and dependent care.
Voluntary Life, AD&D, Short-Term and Long-Term Disability.
01
Which best describes your level of education?
High schoolAssociate's degreeBachelor's degreeMaster's degree or higher
02
If you have a degree, is the major field of study in Computer Science, Statistics, Information Systems or another quantitative field?
YesNoI do not have a degree
03
Which best describes your years of experience in Database Administration, Cloud Infrastructure Administration and/or Sr. Data Infrastructure Engineer role?
Less than 1 year1 year than 3 years3 years less than 5 years5 or more years
04
Please share your experience implementing and working with Microsoft Azure?
05
I understand this position is position is 100% remote optional; however, the successful candidate must live within three driving hours (approximately 175 miles of Greensboro, North Carolina).
YesNo
Required Question