Our mission is to provide Unconditional Care to children & families through the most challenging times of their lives.
Data Analyst
Location
California
Posted
3 days ago
Salary
$87.4K - $101.4K / year
Seniority
Mid Level
Job Description
Data Analyst
Seneca Family of Agencies
• Develop interactive data reports and dashboards using Microsoft Power BI and Excel based on user requirements (30%) • Manipulate and extract meaning from complex datasets, including development and implementation of automated Extract, Transform, and Load (ETL) functions in Power BI as well as use of Excel spreadsheets and Pivot Tables and writing SQL queries/views to extract and manipulate data from relational databases (30%) • Advise and consult with program leaders and staff on matters related to program evaluation, data collection and reporting, and performance improvement efforts (15%) • Participate in intra- and inter-departmental meetings and represent Data team on relevant agency committees and workgroups (15%) • Actively contribute to team knowledge-sharing through peer review, collaborative problem-solving, and a positive, supportive team culture (10%) • Engage in individual and collaborative work to advance team values related to diversity, equity, and inclusion. • Manage and coordinate complex, time-sensitive projects with many different stakeholders.
Job Requirements
- Bachelor’s degree OR Associate degree + 1 year of applicable experience OR High school diploma + 2 years of applicable experience.
- Applicable experience includes work experience in data/business analytics, manipulation, and visualization.
- At least 21 years of age.
- TB test clearance, fingerprinting clearance, and any other state/federal licensing or certification requirements.
- A collaborative, team-first orientation — sharing knowledge, supporting colleagues' work, and contributing to group success.
- Commitment to working to advance team values related to diversity, equity, and inclusion.
- Writing SQL queries against relational databases.
- Transforming and modeling data using Power Query.
- Building interactive reports and dashboards in Power BI with DAX and data extraction/pivot tables in Excel.
- Applying basic statistical concepts and data visualization best practices in presenting data to different audiences.
- Planning and managing complex projects, communicating across multiple stakeholders, and meeting deadlines.
Benefits
- Starting at $87,418 - $101,418 per year
- Actual salary is dependent on creditable experience above the minimum qualifications for the role
- Salary increases each year
- 5 weeks of Paid Time off and 11 Paid Holidays
- Comprehensive benefits package: Medical, dental, vision, chiropractic, acupuncture, and fertility coverage
- 50% paid premiums for dependents
- Long-term disability, family leave, and life insurance
- 403b Retirement Plan
- Employer-paid Employee Assistance Plan
- Scholarship opportunities, ongoing training, and professional development opportunities
- Promotional opportunities across the agency in California and Washington
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
Senior Data Analyst, GTM
TremendousTremendous lets businesses send one-off payments to people around the world.
• apply a range of analytics methods to gain insights across our go-to-market teams (sales, RevOps, marketing, and customer success) • consolidate diverse facts and findings into compelling narratives that can be applied across Tremendous • advocate for data-informed decisions by partnering with key stakeholders and senior leaders • identify and implement improvements within the Data team by standardizing processes, developing innovative practices, providing mentorship, and fostering new expertise • join a growing team of analysts and actively contribute to team collaboration and culture
• Design, build, and maintain scalable cloud‑native data pipelines supporting batch and near‑real‑time use cases. • Engineer and optimize data ingestion, transformation, and orchestration pipelines using Azure Data Factory, Microsoft Fabric, Databricks, and related services. • Implement and maintain lakehouse and medallion architectures (bronze, silver, gold) to support analytics and AI workloads. • Develop robust transformation logic using SQL, PySpark, and Python with a focus on performance and maintainability. • Partner with Analytics/BI Engineers to ensure datasets are optimized for semantic layers and AI consumption. • Collaborate with data scientists to support feature engineering and model training workloads. • Implement data quality, validation, lineage, and observability solutions to ensure trust in data assets. • Design and enforce data security practices including access controls, encryption, and data classification. • Automate deployment and operations using DataOps and infrastructure‑as‑code practices. • Create and maintain technical documentation, runbooks, and architecture diagrams. • Provide technical leadership and mentorship to junior data engineers.
Role Description POWTEC Solutions is hiring a Data Analyst to support a federal client engagement with NOAA’s Office of the Chief Administrative Officer (OCAO). In this role, you will work with enterprise facility management systems to ensure data integrity, build meaningful dashboards, and help drive informed decisions about federal real property investments. This is a full-time, salaried contract position expected to run approximately 8 months, with the potential for extension. You will work largely independently and remotely, with a preference for candidates located on the East Coast — ideally in the Silver Spring, MD or Tampa Bay, FL areas. What You’ll Do - Data Quality & System Integration - Perform quality assurance on Facility Condition Assessment (FCA) data across enterprise platforms, including BUILDER SMS and Archibus. - Review facility records for completeness, accuracy, and consistency, and reconcile data across systems. - Identify anomalies and gaps, then document findings with recommended corrective actions. - Data Mining & Analysis - Extract and preprocess data from multiple sources across the facility portfolio. - Evaluate data quality, remove duplicates and inconsistencies, and apply statistical methods to surface meaningful insights. - Use machine learning techniques where applicable to support deeper analysis. - Dashboard Development & Reporting - Build and maintain interactive dashboards and KPI reports using Tableau or Power BI. - Develop clear data visualizations and written summaries that translate complex findings into actionable insights for government decision-makers. - Data Governance & Documentation - Help establish data governance policies and standards. - Create data dictionaries, user manuals, and training materials. - Develop and maintain a Data Refresh and Sustainment Guide, including ETL processes and update schedules. Qualifications - Experience with data analysis, quality assurance, or business intelligence work. - Proficiency with at least one BI tool (Tableau or Power BI strongly preferred). - Comfort working with enterprise data platforms and large, multi-system datasets. - Strong attention to detail and ability to document findings clearly. - Ability to work independently with minimal day-to-day supervision. Requirements - Familiarity with facility management or real property systems (Archibus, BUILDER SMS, or similar). - Experience supporting federal or government contractor environments. - Knowledge of ETL processes and data governance practices. Work Environment - Location: Remote; East Coast strongly preferred (Silver Spring, MD or Tampa Bay, FL area). - Schedule: Full-time, salaried. - Contract Duration: Approximately 8 months, with potential for extension. - Compensation: Approximately $40/hour equivalent, commensurate with experience. - Clearance: No security clearance required; candidate must be able to pass a federal background investigation and obtain a CAC and NOAA email address. - Tools: Work is performed in a Government-furnished Google Workspace environment using Government-issued accounts and multi-factor authentication.
Senior Data Analyst
New Brunswick Liquor CoAs one of Atlantic Canada’s Top Employers for 2025, ANBL is proud of the people-first culture we’ve built together with our team members. Alcool NB Liquor (ANBL) is a provincial Crown corporation responsible for the purchase, importation, distribution, and retail activity for all beverage alcohol in the province. Our sister company, Cannabis NB (CNB), manages retail cannabis sales for the province, providing safe and legal products while focusing on education, safety, and responsible access. Together, ANBL & CNB return 100% of profits to the Government of New Brunswick to benefit all New Brunswickers while responsibly serving customers and communities across the province. At ANBL, we take our social responsibility seriously. With our Corporate Social Responsibility Strategy to guide us, we are committed to: Responsible selling through our CHECK 30 program. Food security through our partnership with Feed Nourrir NB. Helping New Brunswickers get home safely through our Safe Ride program.
Role Description The Senior Data Analyst acts as a strategic partner to business functions across ANBL, understanding and anticipating their needs and translating them into actionable insights through reports, dashboards, KPIs, and supporting semantic models. As a primary point of contact for the business, the role works closely with stakeholders to shape and guide analytical solutions, advise on underlying data requirements, and ensure high-quality, scalable outputs through validation, functional testing, and UAT. This role promotes data literacy across the organization, enables data-driven decision-making at both operational and strategic levels, and mentors team members while contributing to the continuous improvement of analytics practices. Additional Responsibilities - Requirements Identification: Partner with business stakeholders to understand and anticipate needs, translating them into scalable analytical solutions while advising on approaches that best support strategic objectives. - Modeling, Analysis & Insights: Design, maintain, and optimize semantic models, perform advanced analysis (e.g., forecasting, segmentation, trend analysis), and deliver insights that uncover drivers, risks, and opportunities to inform business strategy. - Decision Support: Partner with business users and leaders to translate insights into actionable recommendations and initiatives that support strategic and operational decision-making. - Stakeholder Engagement: Build and maintain strategic relationships across ANBL to anticipate evolving business needs and influence the delivery of high-value analytics solutions. - Data Quality Assurance: Proactively monitor and validate data quality, collaborating with Data Governance and Data Solution Developers to address systemic issues and improve data reliability. - Documentation: Establish and maintain documentation standards to support knowledge sharing, solution maintainability, and broader data literacy across the organization. - Continuous Improvement: Lead the review of existing processes to identify and implement more efficient ways of working that deliver increased value to the organization. - Personal & Organizational Capability Building: Promote data literacy across the organization and mentor team members through coaching and knowledge sharing, while advancing expertise in evolving tools, technologies, and industry practices. Qualifications - Post‑secondary degree in Computer Science, Information Systems, Mathematics, Finance, Business Administration, or a related field. - 5+ years of experience in data analysis, report development, and data modeling. - Ability to lead the identification, interpretation, and refinement of complex business requirements, translating them into scalable analytical and reporting solutions aligned with strategic objectives. - Proven experience designing and delivering enterprise Power BI reports and semantic models using Fabric Lakehouse or comparable cloud-based data platforms. - Ability to communicate complex insights effectively through data storytelling and visualization, applying and promoting data visualization and dashboard design best practices. - Advanced proficiency in SQL, DAX, and Power Query (M), with the ability to develop performant and scalable analytical solutions. - Strong analytical and problem-solving capabilities, with the ability to interpret complex datasets and identify key drivers, trends, and opportunities. - Strong communication and interpersonal skills, with the ability to influence and collaborate with stakeholders across technical and business teams. Requirements - Technical Stack: - Microsoft Fabric - Power BI (reports, dashboards, semantic models) - Power BI Service (workspaces, deployment workflows, Git integration) - SQL, DAX, Power Query (M) - Microsoft Excel, Forms, Power Automate, SharePoint - Would be an asset if you had: - Exposure to Microsoft Fabric Lakehouse architecture and medallion (bronze, silver, gold) design patterns. - Familiarity with data warehousing concepts and dimensional modeling approaches. - Experience with Microsoft Dynamics 365 or similar ERP/CRM systems. - Exposure to data governance concepts, including data lineage, metadata management, and data cataloging. - Microsoft Certified: Power BI Data Analyst Associate (PL-300). Benefits - Comprehensive benefits package, including medical, dental coverage and a generous pension plan. - Access to a Health Spending Account or Wellness Subsidy. - Opportunities to utilize flexible work arrangements, such as remote or hybrid work. Company Description Alcool NB Liquor (ANBL) is a provincial Crown corporation responsible for the purchase, importation, distribution, and retail activity for all beverage alcohol in the province. Our sister company, Cannabis NB (CNB), manages retail cannabis sales for the province, providing safe and legal products while focusing on education, safety and responsible access. Together, ANBL & CNB return 100% of profits to the Government of New Brunswick to benefit all New Brunswickers while responsibly serving customer and communities across the province. At ANBL, we take our social responsibility seriously. With our Corporate Social Responsibility Strategy to guide us, we are committed to: - Responsible selling through our CHECK 30 program, which specifies that customers who look younger than 30 will be asked for valid photo identification. - Food security through our partnership with Feed Nourrir NB to help get more food to the New Brunswickers who need it. - Helping New Brunswickers get home safely through our Safe Ride program, providing FREE transportation at ANBL-sponsored events.


