Data Architecture Manager

Family Resource Home Care; Liberty Lake (WA); On-site; USD 140,000 - 160,000; Full time

Benefits offered by this job

Unlimited PTO

11 Paid Holidays

Comprehensive Insurance

Company-Paid Life Insurance

401(k) Plan

Health Savings Account

Employee Assistance Program

Work Equipment

Ongoing Development

Bonus Program

Job summary

Family Resource Home Care is seeking a Data Architect Manager to transform complex data into actionable dashboards. You will work across Azure-based data ecosystem, delivering reporting solutions with a focus on data quality and accessibility.

Responsibilities include designing Power BI dashboards, Python scripting, and building Azure Data Factory pipelines. Hybrid work arrangement with occasional travel. Salary range $140,000-$160,000 per year.

Qualifications

• 3+ years of experience in a data analyst or business intelligence role.
• Strong proficiency in Power BI, including DAX, data modeling, and report publishing.
• Solid Python skills, particularly for data wrangling.
• Hands-on experience with Azure Data Factory for building and monitoring data pipelines.
• Working knowledge of Azure SQL Database- query optimization, schema design and access patterns.
• Familiarity with data warehouse concepts and dimensional modeling.
• Ability to communicate technical findings to non-technical stakeholders.
• Strong attention to detail and a bias toward clean, well-documented work.
• Experience with Azure Synapse Analytics or Databricks.
• Familiarity with version control (Git) for managing code and pipeline configurations.

Responsibilities

• Design, build, and maintain Power BI dashboards and reports across a variety of business domains.
• Write and maintain Python scripts for data extraction, transformation and automation.
• Collaborate to implement and extend data pipelines and integration workflows using Azure Data Factory.
• Query and manage data within Azure SQL databases, ensuring accuracy and performance.
• Apply data warehouse modeling principles (star schema, snowflake, etc.) to support scalable, reliable reporting structures).
• Translate business requirements into reporting specifications and deliver them end-to-end.
• Document data sources, transformations, and report logic for maintainability and knowledgeable sharing.
• Identify data quality issues and work with upstream teams to resolve them.
• Adhere to all organizational policies, procedures, and applicable data governance requirements.
• Other Duties: As assigned.

Skills

Power BI

DAX

Python

Azure Data Factory

Azure SQL Database

Data Warehouse Modeling

Stakeholder Communication

Data Quality

Git

Azure Synapse Analytics

Databricks

Tools

Azure Synapse Analytics

Databricks

Git

Job description

Join Our Team at Family Resource Home Care!

Family Resource Home Care is a leading home care agency dedicated to providing high-quality, compassionate care to our clients in their homes. We specialize in personalized in-home care to help our clients maintain their independence and improve their quality of life. Our mission is simple - to improve more lives!

We are currently hiring for a Data Architect Manager.

Position: Data Architect Manager

The Data Architect Manager is responsible for transforming complex data sets into clear, actionable dashboards and reports that drive business decisions. Reporting directly to the Chief Technology Officer, this role works across the organization's Azure-based data eco-system, partnering with stakeholders to deliver reporting solutions that are both technically sound and visually compelling. You will play a key role in ensuring data quality, consistency, and accessibility across all reporting models - a role built for someone who cares about the quality of the data as much as the quality of the dashboard.

Responsibilities

• Design, build, and maintain Power BI dashboards and reports across a variety of business domains.
• Write and maintain Python scripts for data extraction, transformation and automation.
• Collaborate to implement and extend data pipelines and integration workflows using Azure Data Factory.
• Query and manage data within Azure SQL databases, ensuring accuracy and performance.
• Apply data warehouse modeling principles (star schema, snowflake, etc.) to support scalable, reliable reporting structures).
• Translate business requirements into reporting specifications and deliver them end-to-end.
• Document data sources, transformations, and report logic for maintainability and knowledgeable sharing.
• Identify data quality issues and work with upstream teams to resolve them.
• Adhere to all organizational policies, procedures, and applicable data governance requirements.
• Other Duties: As assigned.

Minimum Qualifications

• 3+ years of experience in a data analyst or business intelligence role.
• Strong proficiency in Power BI, including DAX, data modeling, and report publishing.
• Solid Python skills, particularly for data wrangling (pandas, numpy, or similar libraries).
• Hands-on experience with Azure Data Factory for building and monitoring data pipelines.
• Working knowledge of Azure SQL Database- query optimization, schema design and access patterns.
• Familiarity with data warehouse concepts and dimensional modeling.
• Ability to communicate technical findings to non-technical stakeholders.
• Strong attention to detail and a bias toward clean, well-documented work.

Preferred Qualifications

• Experience with a Aure Synapse Analytics or Databricks.
• Familiarity with version control (Git) for managing code and pipeline configurations.
• Exposure to medallion architecture (Bronze/Silver/Gold) or similar layered data frameworks.

Working Conditions

The Data Architect Manager will primarily work in an office or hybrid environment with regular use of a computer workstation. Standard business hours apply, Monday through Friday, though occasional flexibility may be required to meet project deadlines or support time-sensitive reporting needs.

This position may require limited travel to collaborate with business stakeholders at other locations ,approximately 5% of the time. This position will operate under general supervision.

Physical Requirements

Role requires frequent sitting and keyboarding. Occasional standing and walking. Position requires the employee to regularly communicate verbally and in writing. Lifting requirements are minimal, generally 10lbs or less.

Pay Range: $140,000 - $160,000 / Yr

Benefits & Perks

• Unlimited PTO: Enjoy the flexibility to take the time you need for rest and rejuvenation.
• 11 Paid Holidays: Celebrate holidays with family and friends without worry.
• Comprehensive Insurance: Medical, dental, vision, and prescription options to keep you and your family healthy.
• Company-Paid Life Insurance: Peace of mind with our company-paid life and AD&D insurance.
• 401(k) Plan: Secure your financial future with our retirement plan, including company matching.
• Health Savings Account: Manage your healthcare costs effectively.
• Employee Assistance Program: Support for personal and professional challenges.
• Work Equipment: Company-provided computer and office setup.
• Ongoing Development: Participate in weekly training meetings, annual summits, and continuous coaching.
• Bonus Program: Opportunity to earn bonuses based on performance.