Senior Data Analyst

Full Job Description

Are you a data professional who pairs strong technical expertise with the ability to connect, communicate, and collaborate with others?

Do you enjoy turning complex data into meaningful insights while working closely with both internal teams and external stakeholders?

In this role, you’ll develop SQL queries, reporting datasets, and Power BI dashboards while leading conversations to gather requirements, improve data quality, and support enterprise data initiatives.

You’ll help establish data standards, enhance data practices, and identify opportunities for process improvement and automation.

If you’re someone who can step in, add value quickly, communicate effectively with both technical and non-technical audiences, and build strong working relationships, we encourage you to apply.

This senior-level position is responsible for analyzing, evaluating, documenting, and delivering on data requirements, as well as maintaining, analyzing, and transforming data into insights to guide strategy and inform program data, data systems, and software decisions. Responsible for establishing data standards and modeling practices. Employment is subject to the terms, conditions, and policies detailed in the Personnel Policies Manual (PPM). This position requires regular in-person presence as an essential job function. This position may be subject to grant funding.

Requirements

• Develops complex SQL queries and stored procedures for data analysis, quality control, data integrity, and reporting datasets.
• Develops, enhances, and maintains reports and visualizations using Power BI and other Microsoft-based applications.
• Performs a variety of research, analysis, design, testing, integration, maintenance, support, and troubleshooting tasks. 
• Collects, analyzes, interprets, and summarizes novel data and incorporates new attributes into new or existing datasets for reporting and visualization.
• Develops and serves as a subject matter expert regarding data management practices and contributes to increasing the data maturity by providing guidance and hands-on support.
• Responsible for leading and facilitating interview sessions with technical and business stakeholders to understand and document application, data, and reporting requirements. Guides stakeholders through data harmonization activities to enhance the quality and utility of business data.
• Communicates summary analysis and findings to stakeholders, both internal and external.

Performs daily data quality control and integrity checks and makes recommendations for automation opportunities.

Identifies, recommends, and implements process optimization programs using best practice methodologies.

Facilitates automation efforts by developing and deploying minor applications to complement existing line-of-business applications.

• Conducts and supports data profiling activities in relation to data quality assessment and metadata analysis. Develops and manages the enterprise data dictionary by recording data attributes and associated metadata to increase the understanding and utility of data.
• Establishes and applies data standards and documentation.
• Establishes and applies data modeling practices and data architecture options; provides guidance and support to stakeholders.
• Supports new enterprise-level information management capabilities and related change efforts.
• Coordinates with internal service providers and end users to ensure technical compatibility and user satisfaction. Works directly with third-party vendors to coordinate release upgrades, resolve system failures, and define specifications for new system features.
• Performs project management activities, including project plan development, status tracking, and coordination of teams.
• Creates non-technical summaries and other materials to assist in the communication of project efforts and outcomes.
• Provides reporting assistance and technical training to non-technical end-users.
• Drives product adoption and ensures a positive user experience and understanding by hosting product user groups and facilitating product-related knowledge-sharing.
• Understands the strategic importance and value proposition of assigned products and seeks to position products to maximize customer value.
• Performs other duties as required.

Supervision Exercised: This classification does not have supervisory authority; however, may be required to provide expertise or limited guidance or direction to employees, such as overseeing work quality, training, and guidance. Typically serves as a subject matter expert on the scope of functional area.

Supervision Received: Receives general supervision. This classification typically performs job duties by following established standard operating procedures and/or policies. Regular direction, guidance, and coaching from supervisor may be expected. There is a choice of the appropriate procedure or policy to apply to duties. Performance reviewed periodically.

Qualifications

Knowledge, Skills & Abilities

• Working knowledge of ETL processes that include data integration, data quality, and data profiling.
• Knowledge of Microsoft Office 365 and the Microsoft Power Platform.
• Knowledge of statistical analyses, datasets, and associated software such as SAS, R.
• Knowledge of agile project management methods. Skill in prioritizing and organizing multiple tasks and the ability to complete projects in a timely manner, frequently under deadline pressure.
• Familiarity with data architecture, storage, archiving, lineage, and impact analysis.
• Excellent analytical skills, including the ability to quickly and accurately wrangle, analyze and interpret data, identify and define data integrity issues, and make recommendations for resolution. Familiarity with business process modeling.
• Project management understanding of project scopes, project schedules, budgets, and resource allocation for on-time, on-budget projects.
• Skilled in writing and maintaining accurate records, reports, and plans to meet management objectives.
• Excellent facilitation and conflict management skills.
• Must have excellent interpersonal and communication skills with both technical and non-technical audiences. Ability to provide excellent customer service.
• Must possess a high level of professionalism and integrity to handle sensitive and confidential situations and information.
• Must have strong customer service, teamwork, and contract management skills.
• Ability to work cross-functionally with IT teams and key stakeholders, utilizing analytical skills in understanding data flows, dissecting problems, and delivering clear recommendations and guidance.
• Ability to respond in a flexible manner and reprioritize work as situations change.
• Ability to work independently and in a team environment.
• Ability to establish and maintain effective working relationships with co-workers, County staff, partner organizations, and vendors.
• Maintain regular and punctual attendance.

Required Education & Experience

• Bachelor's degree in computer science, information systems, project management, business administration, or related field.
• Five years of related information technology experience.
• Experience with report development using Microsoft Power BI, Tableau, or similar products.
• Hands-on experience in SQL-based analysis and development and related backend database technologies.
• Demonstrated experience using Azure Synapse Data Factory, Data Lake, Data Bricks, and PowerBI.
• Demonstrated experience taking initiative and driving innovation.

Preferred Education & Experience

• Experience with data/information lifecycle management and governance, metadata management, information classification, data quality, data usage, data analysis, document management, privacy, and information security.
• Experience with Qualtrics Voice of the Customer Platform.
• Experience with Azure Map API.
• Experience with mileage reimbursement policies and procedures.

Licenses/Certificates

• Must obtain and maintain necessary certifications/licenses as applicable to position.
• If assigned to the Digital, Strategy, & Technology Department:
  • Must obtain and maintain Criminal Justice Information System (CJIS) Compliance within six months of employment based on regular access to the Sheriff's Office buildings, systems, and/or networks.

Pre-Employment Requirements

• Must pass conditional post offer background investigation and drug screen.

Additional Information

Duties are primarily performed in an office and/or remote work environment dependent on Department discretion and business needs. May be required to work outside of normal business hours and respond to sensitive situations 24 hours a day, 7 days a week; may be required to carry a cell phone. 

The classification specification above is intended to represent only the key areas of responsibilities and minimum qualifications; specific job assignments, duties, education, experience, licenses/certifications, and environmental conditions will vary depending on the needs of the department/office and the particular assignment. Changes to this document may only be made by a member of the Human Resources Department.