Data Architect

Posting Date

04/11/24

Application Deadline

Open Until Filled

Pay Range

Min

• 1st Quartile

• Mid

• Max

$93,500.00 - $108,875.00 - $124,25.000 - $155,000.00

Job Type

Unclassified

Department

Sheriff

About the Position

The Data Architect functions as a technical lead overseeing the architectural design, development, implementation, maintenance support, and management of complex data service systems including design and management of data warehouse and databases using database platform tools and systems, such as Microsoft SQL Server, Power BI, and other Microsoft suite of data products and Power Platform capabilities. This position provides technical solutions, expertise, guidance, and direction to database administrators, database developers, data analysts, report writers, and IT executive management on a broad range of complex information technology matters and projects

About the Maricopa County Sheriff's Office

Do you possess integrity, strong interpersonal skills, and do you have a desire to serve your community? The Maricopa County Sheriff's Office (MCSO) invites you to become part of Arizona's leading law enforcement agency. We are seeking passionate individuals to join our team with a variety of openings for Civilian, Detention and Sworn personnel. We come together as a team to support and provide public safety. We are OneMCSO - become one with us!

Position Qualifications

We recognize your time is valuable, so please apply if you meet the following required qualifications:

Education

• Bachelor's Degree in Computer Science, Computer Information Systems, or related field.

Experience

• Seven years (7) in an information technology role that involves responsibility, accountability, and hands-on experience with database & data warehousing architecture, design, development, and implementation, and includes reviewing and managing complex information technology projects using Microsoft suite of data products and Power Platform.

OR

Combined education and experience qualifications

• Other combinations of education or experience may substitute for the minimum qualifications on a year for year basis.

Other requirements

• Training that may be provided on-the-job: FEMA NIMS - IS100 and 700; Safety; Payroll; PREA.

• Prior to hiring, the Sheriff's Office requires that all candidates pass a background review.

Our Preferred Candidate has

• Master's degree in Computer Science, Computer Information Systems, or related field.

• Experience in database, data warehousing and business intelligence architect role.

• Experience building databases, data warehouses, business intelligence solutions, including high availability and disaster recovery with the Microsoft technology stack using the best practices with Microsoft suite of data products and Power Platform.

• Proven experience with Microsoft SQL Server, T-SQL, Stored Procedures & Triggers, SSIS, SSRS, PowerShell, Power BI, Python, R.

• Experience with Team Foundation Server, or Git administration / configuration or build and release management.

• Experience working with Microsoft Dynamics, SharePoint, and Power Platform.

• Experience working in Agile Methodology.

Essential Job Tasks

(This is not an all-inclusive list of all job duties that may be required; employees will be required to perform other related duties as assigned.)

• Provides technical and analytical guidance; develops and defines business and technical requirements and solution designs as part of specific projects.

• Leads technical design and development with key role in technical decision process; evaluates and troubleshoots functional design and system architecture, component, and framework programming.

• Develops and recommends strategies and specifications for data solutions based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure.

• Oversees the design, assessment, selection, application and maintenance of major databases, data warehousing & business intelligence solutions and metadata structures.

• Leads the Data and Data Warehousing & Business Intelligence teams to maximize existing systems, ensure data integrity / data consistency, chain of custody, and develop analysis to be used in mission critical reporting.

• Formulates data and metadata policies and procedures for functional design and development to build, maintain and upgrade the data model, ensuring compliance with organization data standards.

• Administers technical troubleshooting and integration of new technology or new capabilities into the metadata and data standards and structures and completes assessment of the technical specifications of proposals and alternatives recommended to optimize database performance.

• Develops a logical/physical database design by applying data design standards and guidelines.

• Develops and facilitates resolution of data related project issues.

• Creates and proposes technical design documentation which includes database design models, specifications, and diagrams to provide direction to development teams on the physical implementation of the data model.

• Creates and maintains documentation as it relates to data configuration, mapping, standards, and processes.

• Builds processes supporting data transformation, data structures, metadata, dependencies, and model management.

• Designs, develops, and tests data migration solutions as needed.

• Assists in the design of databases and data warehouses to ensure interoperability with BI solutions.

• Monitors emerging data warehouse technologies and recommends applications appropriate to the organization's environment and its users to ensure the data warehousing solution remains current.

• Designs and delivers end-user training and training materials; provides technical support as necessary.

• Develops and presents conceptual and functional innovation prototypes for assessment and evaluation.

• Shapes the strategy, architecture, methodology and standards for delivering business intelligence and data visualization solutions.

• Plans, prepares, defines, structures, develops, and implements complex database systems.

• Manages data integrity, security, availability, recoverability to ensure optimal performance.

• Participates in multiple, technically complex, mission-critical, and/or high-profile data projects or initiatives.

• Partners with internal customers to conceptualize new projects, recommends technical resources and strategies, and designs project requirements.

• Conducts detailed reviews of all major development projects undertaken by information technology functions within the MCSO, within area of expertise or as requested by management.

• Identifies opportunities to re-engineer business practices to enhance the MCSO's information technology strategies and plans.

• Maintains state-of the-art knowledge in emerging technologies, methodologies, and best practices to enhance the enterprise's image as a first-class organization.

• Provides expertise regarding the integration of applications across the business.

• Determines specifications; plans, designs, and develops complex and business critical data solutions individually or in partnership with project team.

• Acts as evangelist for BI benefits across the organization; promotes BI usage to relevant departments.

• Provides expert level support for the most difficult support problems; resolves unique or non-routine data and BI problems.

• Analyzes short and long-term strategic data or BI/reporting problems and develops solutions.

• Performs other duties as assigned.

Working Conditions

Maricopa County is an EEO/ADA Reasonable Accommodation Employer.

The following environments described are only representative of how the essential job tasks are currently performed or envisioned. As such, in order to accommodate a disability or limitation, the essential job tasks may be performed in ways other than described on these pages.

Work occurs primarily indoors. Tasks require managing time pressures and high work volume with decision making, concentration, and accuracy. Position requires ethical conduct and a professional demeanor.

Work environment

• Indoors

• Rarely outdoors, in temperatures above 90 degrees or below 40 degrees

• Conditions may rarely include stairs or ladders, confined area, unprotected heights, high noise level, dim or bright lighting

Physical environment

• Sitting, standing, walking

• Speaking, hearing, seeing, reading

• Distinguishing colors

• Bending/kneeling, reaching

• Twisting, climbing, crawling

• Crouching, balancing

• Wearing protective gear

• Precise dexterity

• Lifting floor to waist fifty (50) lbs

• Lifting waist to shoulder twenty-five (25) lbs

• Lifting shoulder to overhead twenty (20) lbs

• Carrying fifty (50) lbs for 10 feet

• Pushing/pulling fifty (50) lbs for 10 feet

Social environment

• Emergencies

• Interruptions

• Time pressures

• High volume of work

• Handling multiple or complicated tasks

• Accuracy

• Decision making

• Concentration/vigilance

• Interruptions

• Teamwork

• Conditions frequently include unscheduled or frequently changing tasks, working in close physical proximity with others, overtime/rotating shifts

• Conditions may rarely include traumatic subject matter, dangerous environment, isolation, public contact

Knowledge, Skills, and Abilities

Knowledge of

• Computer applications program design, development, and implementation.

• Big data tools and capabilities as well as data modeling.

• Industry best practices and a deep understanding of application development, continuous integration and continuous delivery, current data structure / modeling, and DevOps.

• SharePoint information architectures, workflows, and mobile applications best practices.

• Cloud Based platforms and methodologies.

Skill in

• Communicating effectively with all levels of clients, including business stakeholders, technical staff, and vendors.

• Maintaining and updating technical documents for application and database support, including Tier 1 support personnel

• Providing technical leadership, with consultative application of technical and management principles and software architecture / design skills to others.

• Designing database architecture that manages data and joins diverse sets of data and sources.

• Using REST APIs, HTML5, CSS and other core web technology concepts.

• Datawarehouse design and implantation.

• Team Foundation Server / DEVOPS.

• PowerBI or other reporting platforms such as tableau or Qlik.

• Microsoft Power Platform, Microsoft Dynamics, and SharePoint.

Ability to

• Address and resolve unique situations or obstacles creatively.

• Plan, architect, design, organize, monitor, control, and implement information systems projects.

• Coach application administrators, developers, database administrators, and other technical staff.

• Lead people from many different disciplines with varying degrees of technical expertise.

• Provide technical oversight across systems and application and leverage support skills across multiple teams and departments.

• Interact with APIs, utilizing SDKs and other tools.

SELECTION PROCEDURE:

The Maricopa County Human Resources Department reserves the right to admit to the selection process only those candidates considered to be the most highly qualified. Those selected will be assessed based on the evaluation of listed education and experience. The hiring authority will interview and select the successful candidate from a list provided by Human Resources.

All offers of employment made to new hires and rehires at Maricopa County are contingent upon successful completion of a post-offer, pre-employment thorough background investigation. A background investigation is conducted on a current employee who changes to a Safety Sensitive Position or one having the potential for serious adverse impact on the integrity or efficiency of the County. These requirements do not pertain to employees of elected officials who undergo background investigation processes administered through their respective offices.

Typically, successful candidates are hired at a salary rate up to the midpoint of the range, based on relevant experience, internal equity, and budgetary allowances.

Maricopa County is an EEO/ADA Reasonable Accommodation Employer.

Selection Procedure

• Only the most qualified candidates will be considered

• Consideration will only be given to candidates who submit online applications

• Candidates will be contacted primarily through email and their Workday online application profile

• Must pass a pre-employment background and/or fingerprint investigation as required by statute or policy, including drug and alcohol testing requirements for positions designated as safety-sensitive

Maricopa County is an equal opportunity employer.

Apply Now!