Data Architect jobs in Greensboro, NC

The Enterprise Data Architect is an experienced professional reporting to the Chief Data Officer, working closely with cross-functional teams from various departments to provide recommendations for optimized data architecture based on the data storage and retrieval needs for Guilford County and within each department. The ideal candidate will have proven experience with data warehouse design, Master Data Management (MDM) design and development, data storage, data modeling, quality assurance, ETL, and analytics/business intelligence capabilities. A key function of this position will be to advise on best practice for data management – extraction, cleansing, alignment, storage, and governance. The Enterprise Data Architect will be responsible for constantly monitoring our enterprise data architecture and quickly addressing any issues.

DUTIES AND RESPONSIBILITIES

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

Design, develop, and maintain the enterprise data management framework 

• Design, build, support and maintain countywide database systems including Microsoft SQL Server. 
• Define/update county-wide data documentation and storage standards. 
• Analyze database 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.  
• Develop database design and architecture documentation for executive administration. 
• Ensure the integrity and security of county data assets. 

Analyze systems and create solutions for business requirements 

• Provide insight into the changing data storage and utilization requirements for the county and offer solutions. 
• Provide guidance, assistance and support for creation and maintenance of complex data sets that meet cross-functional requirements. 
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. 
• 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. 

Establish and cultivate a data-driven culture 

• Lead design sessions in prototyping new solutions to enhance current solutions and increase user adoption of existing tools within our support and work management portfolio. 
• Functions as a subject-matter-expert and participate in the resolution of system and product issues in escalation situations. 
• Work with cross functional stakeholders to assist with data-related technical issues and support their data infrastructure needs. 
• Other duties as assigned by the Manager / Supervisor. 

RECRUITMENT STANDARDS

Knowledge, Skills, and Abilities

• Sound working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
• Ability to build processes supporting data transformation, data structures, metadata, dependency and workload management.
• Experience eliciting and translating business pain points into tangible KPI’s and associated business intelligence solutions.
• Strong project management and organizational skills
• Knowledge of Data Governance and best practices around data architectures.
• Experience with software tools such as Visual Studio, Microsoft SQL Server Reporting Services, Integration Services and Management Studio, Microsoft PowerBI and Tableau 
• Experience supporting and working with cross-functional teams in a dynamic environment