Senior Data Architect & Power BI Lead

Amplytics Inc.; San Francisco, Northern (CA, KY); Hybrid; USD 125,000 - 160,000; Full time

Job summary

Amplytico seeks a Senior Analytics Engineer / Senior Consultant to join our growing practice. You will design and build end-to-end data solutions spanning source systems (AWS, SAP) to Snowflake warehousing and Power Platform delivery layers that put insights directly in the hands of decision-makers.

You will work with clients and Amplytico delivery teams to solve data challenges—from architecture to polished Power BI dashboards and Power Apps in production use.

Qualifications

• 5+ years of experience in data engineering, analytics engineering, or BI development.
• Expert-level proficiency in Power BI including complex data modeling, DAX, Power Query, and gateway management
• Hands-on experience building Power Apps and Power Automate solutions in enterprise environments
• Deep experience with Snowflake including data modeling, performance tuning, Snowpipe, and cost management
• Strong SQL skills and comfort working with large, complex datasets
• Experience integrating data from AWS services (S3, Glue, Lambda, RDS) into downstream analytical systems
• Experience working with SAP data sources (BW extracts, HANA, OData) in an analytics context
• Ability to work independently and lead workstreams on client engagements

Responsibilities

• Data Architecture & Engineering: design end-to-end data architectures connecting source systems to Snowflake.
• Build ELT pipelines using dbt, Azure Data Factory, Fivetran, or equivalent tooling.
• Model data in Snowflake (raw, staging, marts) for performance and governance.
• Define data quality standards, schema conventions, and documentation.
• Evaluate integration patterns for multi-system environments.
• Power Platform Development: design and build Power BI reports/dashboards with advanced DAX and data models.
• Develop Power Apps (canvas/model-driven) that embed analytics into workflows.
• Implement Power Automate flows for data refresh, approvals, and triggers.
• Leverage Dataverse as needed for Power Apps.
• Enforce governance: row-level security, workspace strategy, deployment pipelines.
• Client Delivery & Consulting: lead workshops to define data requirements and KPIs.
• Translate designs for technical and executive audiences.
• Manage delivery across scoping to hypercare.
• Produce design docs and architecture diagrams.
• Act as trusted technical advisor to identify expansion opportunities.

Skills

Power BI

Power Apps

Power Automate

Snowflake

SQL

AWS

SAP data sources

dbt

Python

Data modeling

Tools

Power BI

Power Apps

Power Automate

Azure Data Factory

Fivetran

dbt

Snowflake

Dataverse

Job description

Amplytico seeks a Senior Analytics Engineer / Senior Consultant to join our growing practice. You will design and build end-to-end data solutions spanning source systems (AWS, SAP) to Snowflake warehousing and Power Platform delivery layers that put insights directly in the hands of decision-makers.

You will work with clients and Amplytico delivery teams to solve data challenges—from architecture to polished Power BI dashboards and Power Apps in production use.