Business Intelligence Architect

Job Description:

The Principal, IT Business Systems will design and deliver scalable, secure, and high‑performing data and analytics solutions that enable informed decision‑making across Finance and enterprise functions. This role combines data architecture, advanced analytics, and reporting with cross‑functional support for all technology solutions managed by the Finance Business Applications team.

• Translate business and Finance requirements into technical solutions, data models, semantic layers, and reporting solutions.
• Serve as SME for data interpretation, ensuring consistent understanding of metrics across the organization.
• Present insights and recommendations and facilitate alignment when stakeholders have differing interpretations of data meaning.
• Validate that technical implementations accurately represent original business intent.
• Collaborate with Finance, HR, IT, and other business partners.

• Design enterprise Power BI semantic layer architecture, including data models, relationships, and calculation frameworks.
• Define standardized business logic, measures, and time intelligence patterns.
• Ensure alignment of calculations and metrics across multiple data sources and domains.
• Partner with data warehouse teams to support analytics‑ready data structures.

• Design scalable solutions supporting multi‑source data integration.
• Implement row‑level security and data access controls across user groups.
• Optimize performance through aggregation strategies, DAX tuning, and query optimization.
• Ensure solutions meet enterprise standards for scalability, reliability, and performance.

• Provide data and analytics support across all Finance‑owned technology solutions (e.g., ERP, planning tools, workforce systems, BI solutions).
• Partner with product owners and system leads to ensure reporting, data structures, and integrations support business needs.
• Identify opportunities to enhance tools, eliminate redundancies, and improve end‑to‑end data flows.
• Serve as a point of contact for Finance Business Applications solutions.

• Apply enterprise Power BI standards.
• Establish architectural patterns within the enterprise framework.
• Document architectural decisions, trade‑offs, and rationale.
• Validate implementations against architectural standards through design reviews.
• Document data definitions, architecture decisions, and solution designs.

• Bachelor's degree required.
• 7+ years of experience in data analytics, BI, or data architecture.

• 7+ years Power BI experience including semantic model design, DAX development, and performance optimization.
• 5+ years of data architecture experience with dimensional modeling (star/snowflake schemas).
• Expert‑level understanding of Power BI semantic models, relationships, calculation groups, aggregations, etc.
• Advanced DAX expertise including complex calculations, time intelligence, and performance optimization.
• Strong SQL and data modeling, including writing optimized queries and developing scalable views for proofs of concept.
• Enterprise data warehouse experience (Redshift/AWS or similar).
• Row‑level security design and implementation across complex data models.
• Knowledge of ETL/ELT processes and multi‑source integrations and their impact to downstream reporting.
• Familiarity with Excel, Python, or other analytics tools.

• Strong analytical thinking and problem‑solving skills.
• Ability to translate complex concepts for business users.
• Experience working across multiple systems and stakeholder groups.
• Proven ability to manage multiple priorities and drive results.

• Individual contributor role leading complex analytics and architecture efforts.
• Influences enterprise data strategy and Finance technology ecosystem.
• Balances hands‑on development with strategic design and stakeholder engagement.

The annual salary range for this position is $120,000 – $140,000. An annual bonus is not offered.

• Medical,…