- 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.
- 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
- High school
- Associate's degree
- Bachelor's degree
- Master's degree or higher
- Yes
- No
- I do not have a degree
- Less than 1 year
- 1 year than 3 years
- 3 years less than 5 years
- 5 or more years
- Yes
- No
-
Senior Data Infrastructure Engineer
3 weeks ago
Guilford County Greensboro, United StatesSalary · $87, $109,073.00 Annually · Location · 201 West Market Street Greensboro, NC · Job Type · Full Time · Remote Employment · Flexible/Hybrid · Job Number · 03281 · Department · Information Technology · Opening Date · 02/09/2024 · GUILFORD COUNTY GOVERNMENT · Em ...
-
Information Technology Infrastructure Engineer
2 weeks ago
IQE Greensboro, United StatesInfrastructure Engineer · Onsite - Greensboro · Monday - Friday · If you are considering sending an application, make sure to hit the apply button below after reading through the entire description. · Who We Are · IQE is the leading supplier of compound semiconductor wafer p ...
-
System Administrator
6 days ago
ALTEN Technology USA Greensboro, United StatesWe're ALTEN Technology USA, an engineering company that provides solutions for engineering, technology, and product development projects. For decades, we've been helping our clients develop products that are changing the world, from the efficient heavy truck of tomorrow to a full ...
-
Design Engineer
5 days ago
TECHEAD Greensboro, United StatesTECHEAD is celebrating over thirty-five years of incredible heritage, talent, and accomplishments To learn more about TECHEAD, visit us at or on Glassdoor. · Design Engineer · On-Site · Greensboro, NC · Overview: · The Design Engineer III will identify needs, design, and develo ...
-
Cone Health Greensboro, United StatesOverview: · The Facilities Infrastructure Project Engineer is responsible for the coordination, installation and replacement of building infrastructure systems and equipment. This position will also be accountable to manage small scale renovations and space modifications. This p ...
-
Performance Test Engineer with AWS
3 weeks ago
Keylent Inc Greensboro, United StatesPerformance Test Engineer with AWS TECHM-JOB-25697 · Mode of Hire - Fulltime and Subcon · Salary range - $ 85 K and $ 50 / hr · Skill: Software Testing · Day one Onsite in Greensboro, NC some travel required within NC · Position 1Performance Test Engineer/QAExperience testin ...
-
Qorvo US, Inc. Greensboro, United StatesQorvo (Nasdaq: QRVO) supplies innovative semiconductor solutions that make a better world possible. · We combine product and technology leadership, systems-level expertise and global manufacturing scale to quickly solve our customers' most complex technical challenges. · Qorvo ...
-
Project Manager
1 week ago
SEGULA Technologies Greensboro, United States PermanentJob Description · focuses on designing, communicating, and implementing an operational plan for completing an engineering-based project · Preparing designs, project controls and specifications, schedules, cost estimates, production, transportation, installation, testing and/or co ...
-
Reliability Engineer
1 week ago
Qorvo Greensboro, United StatesPress Tab to Move to Skip to Content Link · Select how often (in days) to receive an alert: · Sr Reliability Engineer · Job Type: · Full-Time · Location: · NC - Greensboro (HQ), US · Requisition ID: · 7271 · Qorvo (Nasdaq: QRVO) supplies innovative semiconductor solutions th ...
-
Electrical Project Manager
4 weeks ago
Stefanini Greensboro, United StatesStefanini Group is hiring · Stefanini is looking for a Electrical Project Manager in Greensboro, NC · For quick Apply, please reach out to Sonu Agarwal, call / email: · Product Development Project Management focuses on designing, communicating, and implementing an operationa ...
-
Automation Tester with AWS
2 days ago
Diverse Lynx Greensboro, United StatesTest Engineer/QA · •Experience testing cloud-based infrastructure solutions in AS o Works with development team and application owner on application validation and testing o Develops test plans for applications · •Experience with browser-based debugging and performance testing so ...
-
Utilities Engineer
1 week ago
AECOM Greensboro, United StatesCompany Description · Work with Us. Change the World. · At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our work helps people and communities thrive. We are the world's ...
-
Geotechnical Staff Engineer
2 weeks ago
S&ME Greensboro, United StatesJob Description · Job Description · Geotechnical Staff Engineer · Requisition Number: · S&ME is looking for a motivated and passionate · Geotechnical Staff Engineer · to join our team in · Greensboro, North Carolina . This is an excellent opportunity for an engineer in trai ...
-
Sr Security Engineer with Security Clearance
2 days ago
ClearanceJobs Greensboro, United StatesWhy WWT? Fueled by creativity and ideation, World Wide Technology strives to accelerate our growth and nurture future innovation. From our world class culture, to our generous benefits, to developing cutting edge technology solutions, WWT constantly works towards its mission of c ...
-
Engineering Technician
2 weeks ago
Qorvo Greensboro, United StatesQorvo (Nasdaq: QRVO) supplies innovative semiconductor solutions that make a better world possible. We combine product and technology leadership, systems-level expertise and global manufacturing scale to quickly solve our customers' most complex technical challenges. Qorvo serves ...
-
Project Engineer
2 weeks ago
Rakhere Technologies Greensboro, United StatesProject Manager - Electrical · Greensboro, NC, USA · Full-time · Contract/country: Fixed Term · Job family: Project management · RAKHERE TECHNOLOGIES is looking for a Project Engineer in the automotive or heavy commercial vehicle domain to join our growing team in GreensboroNC, t ...
-
Electrical Project Manager
3 weeks ago
SEGULA Technologies Greensboro, United StatesPosition - Electrical - Project Manager · Location - Greensboro, NC, USA · Company Description · MUST be authorized to work in the United States for any employer. · MUST be available to start working within 3 weeks of offer acceptance date. · SEGULA TECHNOLOGIES is hiring a Proj ...
-
Senior Software Engineer
1 day ago
Qorvo US, Inc. Greensboro, United StatesQorvo (Nasdaq: QRVO) supplies innovative semiconductor solutions that make a better world possible. · We combine product and technology leadership, systems-level expertise and global manufacturing scale to quickly solve our customers' most complex technical challenges. · Qorvo se ...
-
Senior Design Engineer
1 week ago
Qorvo Greensboro, United StatesPress Tab to Move to Skip to Content Link · Select how often (in days) to receive an alert: · Job Type: · Full-Time · Location: · NC - Greensboro (HQ), US · Requisition ID: · 7246 · Qorvo (Nasdaq: QRVO) supplies innovative semiconductor solutions that make a better world poss ...
-
Staff Design Engineer
11 hours ago
Qorvo Greensboro, United StatesPress Tab to Move to Skip to Content Link · Select how often (in days) to receive an alert: · Job Type: · Full-Time · Location: · NC - Greensboro (HQ), US · Requisition ID: · 7220 · Qorvo (Nasdaq: QRVO) supplies innovative semiconductor solutions that make a better world poss ...
Senior Data Infrastructure Engineer - Greensboro, United States - Guilford County, NC
Description
Salary : $87, $109,073.00 AnnuallyLocation : 201 West Market Street Greensboro, NC
Job Type: Full Time
Remote Employment: Flexible/Hybrid
Job Number: 03281
Department: Information Technology
Opening Date: 03/21/2024
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 DUTIES
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.
DISTINGUISHING FEATURES OF THE CLASS
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.
Examples of Duties
DUTIES AND RESPONSIBILITIES
Essential duties and responsibilities include, but are not limited to:
Knowledge, Skills, and Abilities
MINIMUM QUALIFICATIONS
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.
PREFERRED QUALIFICATIONS
Experience implementing and working with Microsoft Azure Synapse.
Supplemental Information
Physical Demands
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.
Working Conditions
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.
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
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?
If you have a degree, is the major field of study in Computer Science, Statistics, Information Systems or another quantitative field?
Which best describes your years of experience in Database Administration, Cloud Infrastructure Administration and/or Sr. Data Infrastructure Engineer role?
Do you have experience implementing and working with Microsoft Azure Synapse?(Must be included on your application.)