Architecture Engineer

Data Analytics (Architecture Engineer)

We are seeking a skilled and delivery-focused Analytics Architecture Engineer (Power BI & Semantic Layer) to design and evolve enterprise analytics architecture within the Data Analytics COA team. This role is centered on hands-on architecture creation and implementation, including scalable semantic layer patterns, reusable integration components, and automation frameworks that accelerate governed analytics delivery across the firm. The engineer will partner closely with analytics delivery teams and data platform stakeholders to define and implement COA reference architectures, enable self-service analytics, and drive reuse of enterprise semantic models.

The role includes developing and maintaining API-driven and scripted automation for analytics processes such as metadata collection, validation routines, deployment enablement, and integration with enterprise tooling. The individual will also contribute to enhancing user experience through Power BI consumption patterns (including Power BI Mobile) and support adoption of AI-driven analytics capabilities, including early integration patterns for Copilot-enabled experiences where applicable.

This role operates on U.S. Eastern Time business hours to ensure close collaboration with U.S.

-based business and technology stakeholders. The position reports directly to the Data Analytics Architecture Lead.

• Snowflake cloud data platform
• Power BI reporting and analytics
• API knowledge, including integration with Power BI REST APIs and other enterprise systems - AI capabilities (Copilot, AI visuals, automated insights)
• Scripting and automation using Power Shell and/or Python to support analytics
• Mobile-optimized dashboard design
• Enterprise job scheduling tools (ie. Tidal)
• Power BI Report Scheduler (PBRS)
• Microsoft SQL Server
• Enterprise data warehousing concepts and architectures
• Semantic model development and tooling (ie. Cube Dev)

• Act as a COA analytics architecture and enablement engineer, guiding delivery teams in designing, building, and scaling analytics solutions across Snowflake, Power BI, and enterprise semantic layers.
• Provide hands-on architectural guidance for Power BI solution design, including dataset modeling, semantic layer implementation (Cube Dev / Power BI), and alignment to enterprise data warehousing patterns.
• Define and review end-to-end analytics architectures, covering data sourcing from Snowflake, semantic modeling, report consumption (desktop, service, and mobile), and operational tooling.
• Design, review, and optimize enterprise semantic models, ensuring consistent business logic, reusable measures, and alignment to underlying data warehouse structures.
• Enable and govern the use of Power BI AI capabilities (Copilot, AI visuals, automated insights) and mobile-first report design, ensuring secure and business-appropriate adoption.
• Provide architectural guidance on automation and orchestration, including use of Power Shell and Python scripting, Power BI REST APIs, PBRS, and enterprise schedulers (e.g., Tidal).
• Partner closely with data architecture and platform teams to align analytics solutions with enterprise data strategy, governance, and Snowflake best practices.
• Serve as a technical advisor and architecture point of contact for analytics teams, business analysts, and developers across the firm.
• Support governance activities including design reviews, standards compliance checks, and architecture documentation.
• Identify opportunities to improve analytics delivery efficiency through automation, templates, reusable components, and improved tooling.
• Collaborate with globally distributed teams, while maintaining primary engagement during U.S. Eastern Time business hours.

• 8+ years of experience in data analytics, business intelligence, and enterprise reporting platforms, with a strong focus on analytics enablement and solution design.
• 8+ years of hands-on SQL experience, including relational and dimensional data modeling, query optimization, and performance tuning on platforms such as Snowflake and SQL Server.
• Demonstrated experience designing, developing, and advising on Power BI reports, datasets, and semantic models, including best practices for reuse and scalability.
• Experience with automation, APIs, and orchestration, leveraging Power Shell/Python, Power BI REST APIs, PBRS, and enterprise schedulers
• Strong understanding of AI-enabled and mobile analytics within Power BI, applied in a secure, governed enterprise context
• Experience working with enterprise semantic layers (e.g., Cube Dev or similar technologies) and promoting standardized business logic across analytics use cases.
• Familiarity with financial services data domains (e.g., Fixed Income, Equities, Derivatives) and the associated reporting and analytical requirements.
• Strong understanding of analytics governance concepts, including standards, design patterns, certified datasets, and controlled self-service…