Architecture Engineer

Data Analytics (Architecture Engineer) - Job Description
We are seeking a skilled and deliveryfocused 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 handson 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 selfservice analytics, and drive reuse of enterprise semantic models. The role includes developing and maintaining APIdriven 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 AIdriven analytics capabilities, including early integration patterns for Copilotenabled 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.

Key Platform and Technology Expertise

• 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 PowerShell 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)
  
  Key Responsibilities:
• 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 PowerShell 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.

Qualifications:

• 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 PowerShell/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 enablement.
• Ability to partner with business analysts and delivery teams to translate business requirements into well designed analytics and semantic solutions.
• Self driven and proactive, with the ability to guide and enable other teams through complex analytics design decisions.
• Excellent written and verbal communication skills, with the ability to explain technical concepts clearly to both technical and non technical audiences.
• Strong organizational skills with the ability to manage multiple enablement efforts and COA requests in parallel.
• Bachelor's degree in Computer Science, Information Systems, Computer Engineering, or a related discipline.