Casey Family Programs an Equal Opportunity Employer is the nations 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 we work in 50 states the District of Columbia and two territories and with more than a dozen 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 inclusion diversity equity and respect for individuals in the workplace. We encourage candidates with diverse lived experience and perspectives from underrepresented communities to apply.
Job Summary:
The Business Intelligence Solution Architect serves as a key bridge between Technology Services and business units driving the organizations 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 Caseys 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 organizations 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.
- 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 $148495 to $174700. The full salary range for the role is $148495 to $200905. As a mission-driven organization Casey strives to balance competitive pay with our mission. Actual placement in the range will depend on a candidates 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 leave10 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.