Business Intelligence Solution Architect

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.

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 Health 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.