Casey Family Programs, an Equal Opportunity Employer, is the nation’s largest operating foundation focused on safely reducing the need for foster care and building Communities of Hope for children and families across America. Founded in 1966, Casey Family Programs works in all 50 states, the District of Columbia, two territories, and tribal nations to influence long-lasting improvements to the safety and success of children, families and the communities where they live. Casey Family Programs values diversity, equity, inclusion, anti-racism, anti-discrimination, and respect for individuals in the workplace. We encourage candidates with diverse lived experience and perspectives to apply.
Job Summary:
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.
Essential 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.
Qualifications:
- 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.
The typical hiring range for this position in Seattle, WA is $148,495 to $174,700. The full salary range for the role is $148,495 to $200,905. As a mission-driven organization, Casey strives to balance competitive pay with our mission. Actual placement in the range will depend on a candidate’s job-related skills, experience, and expertise, as evaluated during the interview process.
Casey Family Programs offers comprehensive benefits including medical, dental and vision coverage, accrual of 12 days of annual leave, 12 days of sick leave,10 paid holidays per year, and each employee receives one personal holiday to use each calendar year. Employees that meet certain tenure qualifiers are eligible for up to eight weeks of parental leave for the birth or placement of a child for adoption or foster care. After the completion of 10 years of continuous, full-time regular employment, employees in good standing are permitted for a three-month sabbatical with pay. CFP also offers many opportunities for continued learning, training, and development
This position will remain open until the needs are met and is subject to closure at any time without notice. It is to your advantage to file your application early as you will not be able to apply once the position has closed.
Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights (https://www.eeoc.gov/poster) notice from the Department of Labor.
