Data Analytics Consultant

About the role

We are seeking a highly skilled, self-driven, and results-oriented senior data analyst to support Chief Administrative Office (CAO) data enablement and management activities. This role involves gathering and writing data use case requirements, performing data analysis, and developing data relationship designs. The ideal candidate will be comfortable working independently, managing multiple workstreams, and engaging with business partners to define and deliver impactful and reusable data solutions. This role is critical to enabling CAO-wide data initiatives and will directly influence how data is leveraged across key business functions.

Responsibilities

• Collaborate with business stakeholders to gather and refine requirements for data use cases.
• Design and architect scalable data models and data element relationships with a strong emphasis on usability, performance, and data accuracy.
• Identify and write requirements for data source integrity monitoring.
• Support database enhancement requests and contribute to logical data design solutions.
• Participate in data management documentation, including data lineage, data sharing agreements, and other metadata management.
• Evaluate upstream system of record changes for potential data impact and provide recommendations.
• Translate business needs into actionable data requirements and technical specifications.
• Partner with technology and data governance groups to ensure alignment with the team’s and enterprise data standards.

Qualifications

• 4+ years of Analytics experience or equivalent demonstrated through work, consulting experience, training, military experience, or education.
• Proficiency in MSSQL, including the ability to write, read, and optimize queries for data extraction, transformation, and analysis.
• Experience in data cleansing, validation, and transformation logic using Alteryx and SSMS.
• Ability to define clear data sourcing and transform logic requirements and database/table/column specifications.
• Experience with metadata management and data governance practices.
• Proficiency in data profiling and root cause analysis for data quality issues.
• Proven ability to work independently and manage multiple priorities.
• Strong communication and stakeholder engagement skills.
• Comfortable navigating ambiguity and driving clarity in complex data environments.

Skills

• Experience with Google Data Cloud stack (Dataplex, BigQuery, etc.).
• Familiarity with SSIS packages and jobs.
• Familiarity with Agile processes and Atlassian software (Jira).

Pay

Pay Range: $50 - $52 (specific compensation determined by scope, complexity, location, cost of labor, skills, education, training, credentials, experience, and other conditions of employment).

Benefits

Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.