Business Intelligence Solution Architect

Casey Family Programs • Seattle, WA

1d • $148,495 - $200,905 • Onsite

About The Position

The Business Intelligence Solution Architect serves as a key bridge between Technology Services and business units, driving the organization's data integration strategy and enabling data-driven decision making. This role combines technical expertise with business acumen to design, implement, and support data solutions that advance Casey's strategic objectives. The BI Solution Architect partners with stakeholders across the organization to understand data needs, translate them into technical solutions, and build capabilities that enhance both internal analytics and external data sharing while promoting data literacy throughout the organization.

Requirements

• 7+ years of experience with business intelligence, data integration, and analytics solutions.
• Proven track record of partnering with business units to define and prototype business intelligence solutions.
• Demonstrated expertise in with the following technologies: SQL Server, Tableau, SSIS, and SSRS. Experience with ETL tools such as Workato and workflow automation a plus.
• Experience working with child welfare data sets AFCARS, NCANDS, and Social Determinates of Heath a plus.
• Demonstrated skill in designing and implementing data architectures that connect disparate data sources and enable comprehensive reporting and analytics.
• Experience supporting collaborative data management initiatives with a focus on enhancing data quality, accessibility, and usability across an organization.
• Proven ability to translate complex business requirements into technical specifications and solutions.
• Strong communication skills with the ability to explain technical concepts to non-technical stakeholders and advocate for data-driven approaches.
• Experience fostering data literacy and building data capabilities within an organization.
• Knowledge of data security and privacy best practices, HIPAA.
• Ability to work onsite full-time to meet the collaborative responsibilities that are essential for position. Regular and reliable attendance is required.
• Physical requirements include the ability to lift and reach for light objects; ability to type and work at a computer for extended periods of time as a primary job function.
• Ability to protect the confidentiality of sensitive information by learning and following all relevant policies and protocols and using sound judgment in the handling and sharing of that information.
• Local travel as well as occasional out of town travel may be required. Driving on Casey business may require use of personal vehicle; adherence to vehicle safety guidelines and qualification for insurance is require.
• Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Nice To Haves

• Experience with ETL tools such as Workato and workflow automation
• Experience working with child welfare data sets AFCARS, NCANDS, and Social Determinates of Heath

Responsibilities

• Collaborates with business stakeholders to understand data requirements and translate them into technical solutions using leverage database, reporting/visualization, and ETL technologies such as Tableau, SQL Server, and Workato. Acts as a primary liaison between Technology Services and business units for data-related needs.
• In partnership with Database Engineer, Sr. and Sr. Integration Solution Engineer, designs and implements data integration solutions that connects disparate data sources to enable cross-organizational analysis and reporting. Develops and implements data models and architectures that support the organization's one-stop shop for data access.
• Supports the development and ongoing refinement of BI applications, reports, and dashboards that provide actionable insights for decision-making.
• Contributes to data literacy initiatives by developing documentation, providing training, and serving as a technical resource for data enthusiasts across the organization.
• Evaluates and recommends data management tools and practices that align with the organization's data principles and strategic objectives.
• Collaborates with cross-functional teams to implement efficient data workflows and automation using ETL/integration tools.
• Ensures quality and security of data solutions through proper testing, documentation, and adherence to data protection standards.
• Performs other duties as assigned.

Benefits

• medical, dental and vision coverage
• accrual of 12 days of annual leave
• 12 days of sick leave
• 10 paid holidays per year
• one personal holiday to use each calendar year
• up to eight weeks of parental leave for the birth or placement of a child for adoption or foster care
• three-month sabbatical with pay
• opportunities for continued learning, training, and development

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed