Tabular Data Architect

Adobe

Seattle (WA)

On-site

USD 154,000 - 278,800

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Adobe is seeking a BI Data Architect in Seattle, WA to design and build data solutions for their enterprise business, including Creative Cloud and Document Cloud. The role involves collaborating with product managers and BI developers to analyze and implement complex data requirements.

Successful candidates will have over 10 years of experience in BI and data warehousing along with expertise in Microsoft SSAS Tabular models and SQL. The competitive salary range for this position is $154,000 to $278,800 annually, varying by location and experience.

Qualifications

  • 6+ years of experience designing, implementing, and optimizing Microsoft SSAS Tabular models.
  • 10+ years of professional experience with BI and data warehousing.
  • Strong SQL and database skills.

Responsibilities

  • Work creatively and analytically to solve problems in a fast-paced environment.
  • Analyze Power BI reporting requirements.
  • Modify and create Tabular models to support reports.

Skills

Microsoft SSAS Tabular models
Data warehousing
SQL
Power BI report development
DAX
Requirement gathering
Multi-tasking

Education

BS or MS in Computer Science

Tools

Python
Linux
Bash

Job description

The challenge

The BI data architect will be responsible for helping design and build data solutions to support the $2B+ Digital Media for Enterprise business, including Adobe’s flagship Creative Cloud and Document Cloud solutions.

Working with the product managers, BI developers, and the Senior Manager of Data Engineering, the BI data architect will analyze reporting requirements and help design and implement the necessary database tables and Tabular models.

In this role, you will be working with a complex assembly (100+ tables) of data sources from many business units which are transformed and integrated into a shared Tabular model leveraged by an expanding suite of complex Power BI reports.

The reporting requirements from the product managers are complex, and the shared Tabular model must evolve to support those requirements. Thorough analysis and thoughtful design are needed before implementing Tabular model changes. The reporting requirement analysis requires collaboration with product managers and BI developers, and the Tabular model and database changes require collaboration with the Senior Manager of Data Engineering.

What you’ll do
  • Work creatively and analytically to solve problems in a fast-paced development environment.
  • Become a domain expert in Adobe’s sales, support, and product usage data.
  • Become intimately familiar with the team’s data warehouse and Tabular models.
  • Analyze Power BI reporting requirements, especially in relation to data warehouse tables and Tabular models.
  • Create derivative database tables to support reporting requirements.
  • Modify and create Tabular models to support Power BI reports.
  • Identify and debug data problems in warehouse tables and Power BI datasets.
  • Identify deficiencies in Tabular models; recommend and implement improvements.
What you need to succeed
  • Experience designing, implementing, and optimizing Microsoft SSAS Tabular models; 6+ years
  • 10+ years of professional experience with BI and data warehousing
  • Data architect skills; conceptual, logical, and physical modeling; integration techniques; access control strategies
  • Strong SQL and database skills
  • Experience with Power BI report development and DAX; 3+ years
  • Strong requirement gathering skills; understanding the problem; efficient communication
  • Ability to multi-task simultaneous projects
  • BS or MS in Computer Science or comparable experience
Special consideration given for
  • Python, Linux, Bash; the team’s SQL-based ELT workloads are orchestrated/automated using these technologies
  • Knowledge in Data Science, ML/AI application life‑cycle

Adobe is an equal opportunity employer. We welcome and encourage diversity in the workplace regardless of race, gender, sexual orientation, gender identity, disability, or veteran status.

Our compensation reflects the cost of labor across several U.S. geographic markets, and we pay differently based on those defined markets. The U.S. pay range for this position is $154,000 -- $278,800 annually. Pay within this range varies by work location and may also depend on job‑related knowledge, skills, and experience. Your recruiter can share more about the specific salary range for the job location during the hiring process.

At Adobe, for sales roles starting salaries are expressed as total target compensation (TTC = base + commission), and short‑term incentives are in the form of sales commission plans. Non‑sales roles starting salaries are expressed as base salary and short‑term incentives are in the form of the Annual Incentive Plan (AIP).

In addition, certain roles may be eligible for long‑term incentives in the form of a new hire equity award.

Adobe is proud to be an Equal Employment Opportunity and affirmative action employer. We do not discriminate based on gender, race or color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law. Learn more.

Adobe aims to make Adobe.com accessible to any and all users. If you have a disability or special need that requires accommodation to navigate our website or complete the application process, email accommodations@adobe.com or call (408) 536-3015.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data Engineer
Lead Data Engineer

Adobe • San Jose (CA)

On-site
USD 177,900 - 257,550
Data Analyst 5
Data Analyst 5

NextDeavor • San Jose (CA)

On-site
USD 77,613 - 97,010
Health, vision, and dental benefits
Paid sick leave
Potential for extended or permanent full‑time employment
+1
Senior Business Intelligence Engineer
Senior Business Intelligence Engineer

ArthaNexgen • San Jose (CA)

On-site
USD 140,000 - 185,000
Data Analyst 5
Data Analyst 5

Cypress HCM • San Jose (CA)

Hybrid
USD 97,024
Senior BI Engineer: Scale Data Pipelines & Dashboards
Senior BI Engineer: Scale Data Pipelines & Dashboards

Artha Nexgen • San Jose (CA)

Hybrid
USD 140,000 - 185,000
BI Developer II
BI Developer II

Confidential Careers • Scottsdale (AZ)

On-site
USD 100,000 - 130,000
Data Architect
Data Architect

Compunnel Inc. • Trenton (NJ)

On-site
USD 110,000 - 150,000
Data Visualization Architect / Designer
Data Visualization Architect / Designer

247Hire • Burbank (CA)

On-site
USD 120,000 - 150,000
Data Scientist
Data Scientist

Adobe (old) • Lehi (UT)

On-site
USD 109,000 - 201,000
Sr. Director, Strategic Planning & Business Insights
Sr. Director, Strategic Planning & Business Insights

Adobe • San Jose (CA)

On-site
USD 172,000 - 389,600