Data Architect

Data ArchitectSalary Range: $108,468 - $162,701. This is an exempt position. Pay rates are based on education, skill, experience level and internal equity.Position SummaryProvides a key role in structuring the enterprise in terms of its processes, capabilities and technology. This incumbent aligns strategic goals and objectives with decisions regarding products and services; partners and suppliers; organization; capabilities; and key business and IT initiatives. This individual's primary responsibility is ensuring that the technological solutions in support business goals, requirements, capabilities and objectives are translated into detailed system architectural designs through use of process flow diagrams, future-state operational changes and technical solutions models.Who Will I Be Working With?As part of the Enterprise Architecture Team, the Data Architect Role will work in collaboration with other Architecture roles to design solutions for various project types. In addition, the Data Architect role will work with both Development staff, Support staff and Business Partners to define and implement Data Standards and Governance across the enterprise.More About The Role:The Data Architect role will work to implement TOGAF (The Open Group Architecture Framework) and is expected to set data architecture principles, create models of data that enable the implementation of the intended business architecture, create diagrams showing key data entities, and create an inventory of the data needed to implement the architecture vision.What Will I Be Doing?Quickly and effectively understand business issues and challengesElicit business needs and builds a trusted advisor relationship with business leaders to provide coaching and guidance on system architectural and design solution options based on understanding of industry trends and customer expectationsServes as an integral member of the team that helps develop a consolidated business and technology roadmap to help ensure that resources, interdependencies and business priorities are effectively alignedManages multiple projects and priorities simultaneouslyDetermine overall modeling standards, guidelines, best practices and approved modeling techniques and approaches.Participate in due diligence of new software purchases by reviewing all proposed data models contained in packaged or commercially available applications.Serve on data integration, business intelligence and content managementWork with business users to identify and document the key facts and dimensions necessary to support the business requirements.Develop and maintain conceptual, logical and physical models, as well as metadata repository.Identify the appropriate data sources with the assistance of the business analysts and conduct thorough data quality assessments on source data. Prepare prototype models to support development efforts.Develop entity and attribute descriptions and definitions for the models. Ensure that conflicts in descriptions and definitions are resolved.Describing data entities and relationships, master data, metadata, data quality, data cleansing, and data governanceEssential FunctionsEvaluate and select from existing and emerging technologies to best fit business and project needs.Define and maintain conceptual, logical, and physical data models to support business and analytical needsIdentify and document key data entities, attributes, and relationships required to support enterprise systemsAssess data sources and perform data quality evaluations to ensure accuracy, completeness, and reliabilitySupport data integration, business intelligence, and analytics initiatives through structured data design and modelingBuild a trusted advisor relationship with business leaders to provide coaching and guidance on system architectural and design solution options based on understanding of industry trends and customer expectationsTranslate complex topics, concepts and business opportunities into possible system architectural and design solution options that will help Mecklenburg County take advantage of market opportunities or overcome business challenges; create a standard set of EA work products including business capability models, logical architecture models, and physical architecture models that enable the organization to achieve the value identified with high quality.Work successfully with and on Agile teamsDevelop and maintain standard enterprise architecture artifacts, including business capability models, logical architectures, and physical solution designs, ensuring consistency and quality across initiativesDetermine overall modeling standards, guidelines, best practices and approved modeling techniques and approachesCollaborate with cross-functional teams to ensure solutions are scalable, secure, and aligned with enterprise governance and policy requirementsEnsure solutions align with enterprise data, security, and governance policies, supporting regulatory compliance and responsible use of dataAdministrative:Participation in Candidate Interviews - participate in interview process for new hires and in identifying skill set for new positions.Contributions to Business Process - Lead and engage ongoing committees and teams.Professional Development - improve professional skills and develop connections with industry peers.Minimum QualificationsExperience: Minimum of six years of progressively responsible programming experienceEducation: Bachelor's Degree in Information Technology or Computer ScienceCombination of relevant education and relevant experience accepted: YesPreferred QualificationsData Migration Tools, Azure Data Lake Experience, Azure Data Factory Experience, Power BI, SQL Server Reporting Services, Big Data Concepts, Master Data Management.Data Analysis, Data Modeling, Data Integration, Data Warehousing, Database Design, Proficiency in both Oracle and SQL Server.Knowledge, Skills and AbilitiesKnowledge ofCurrent software development technologies, trends, and methodologiesCommon and advanced software engineering design patternsTraining techniquesAssigned governmental functionsComplex data relationships among multiple sources of structured and unstructured dataSkillsObject-oriented programming and designRelational database programming and designWeb-based application programming and designProject managementDevelop software using multiple tools, operating systems, languages, and methodologiesDefine, track, and assure responsiveness to clients' information service problemsEstablish and maintain effective working relationshipsAbilitiesContributing to Team Success: Actively participates as a member of a team to move the team toward the completion of goals.Building Partnerships: Identifies opportunities and takes action to build strategic relationships between one's area and other areas, teams, departments, units, or organizations to help achieve business goals.Communication: Clearly conveys information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message.Collaboration: Works effectively and cooperatively with others; establishes and maintains good working relationships.Customer Focus: Ensures that the customer perspective is a driving force behind business decisions and activities; crafts and implements service practices that meet customers' and own organization's needs.Decision Making: Identifies and understands issues, problems, and opportunities; compares data from different sources to draw conclusions; uses effective approaches for choosing a course of action or developing appropriate solutions; takes action that is consistent with available facts, constraints, and probable consequences.Technical/Professional Knowledge and Skills: Has achieved a satisfactory level of technical and professional skill or knowledge in position-related areas; keeps up with current developments and trends in areas of expertise.Driving for Results: Sets high goals for personal and group accomplishment; uses measurement methods to monitor progress toward goals; tenaciously works to meet or exceed goals while deriving satisfaction from that achievement and continuous improvement.Planning and Organizing: Establishes courses of action for self and others to ensure that work is completed efficiently.Managing Conflict: Deals effectively with others in an adversarial situation; uses appropriate interpersonal styles and methods to reduce tension or conflict between two or more people.Computer SkillsRelational database programming and designReasonable Accommodations StatementTo accomplish this job successfully, an individual must be able to perform, with or without reasonable accommodation, each essential function satisfactorily. Reasonable accommodations may be made to help enable qualified individuals with disabilities to perform the essential functions.Disclaimer StatementThis is not intended to be an all-inclusive list of job-related responsibilities, duties, skills, requirements or working conditions. Other duties may be assigned based on business need and the supervisor's request. Mecklenburg County reserves