Data Architect

Phoenix, AZ, United States

Posting Date

01/05/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. Tasksrequire managingtime 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

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!

#J-18808-Ljbffr