Tabular Data Architect

    • Adobe Systems
  • New York, NY
  • Posted 46 days ago | Updated 20 hours ago

Overview

On Site
USD 154,000.00 - 278,800.00 per year
Full Time

Skills

Software development methodology
Product innovation
Digital media
Cloud computing
Data engineering
Microsoft Power BI
Requirements analysis
Sales operations
Data warehouse
Microsoft SSAS
Physical data model
Access control
Reporting
Requirements elicitation
Multitasking
Computer science
Data Science
Data
Adobe
Streaming
Laptop
Tablet
Creativity
Analytical skill
Innovation
Leadership
Business intelligence
Design
Database
Assembly
Collaboration
Derivatives
Debugging
Warehouse
SQL
DAX
Communication
Python
Linux
Bash
ELT
Machine Learning (ML)
Artificial intelligence

Job Details

JOB LEVEL
P50
EMPLOYEE ROLE
Individual Contributor

Our Company

At Adobe, we're changing the world. How? We give people the tools to bring their ideas to life and create content that makes life more fun and work more significant. We give businesses and organizations the power to truly engage their customers. We're the ones behind the elegantly designed content that streams across your laptop, TV, phone, and tablet every day-and the ones who harness the massive power of data to help companies move from data to insight, and from insight to action by delivering high quality content.

At Adobe, you will be immersed in an exceptional work environment that is recognized throughout the world by numerous "best places to work" awards. We are committed to helping each other grow through our Check-In approach where open feedback flows freely. If you're looking to build your career, Adobe's the place for you. Every day, we get to work with some of the most creative, analytical, authentic and inspiring people in the world.

We're a company that understands that product innovation comes from people innovation, and that's why we invest in cultivating leaders throughout the organization. If you are passionate about leading, join us.

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 positionis $154,000 -- $278,800 annually. Paywithin this range varies by work locationand 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.

Internal Opportunities

Creativity, curiosity, and constant learning are celebrated aspects of your career growth journey. We're glad that you're pursuing a new opportunity at Adobe!

Put your best foot forward:

1. Update your Resume/CV and Workday profile - don't forget to include your uniquely 'Adobe' experiences and volunteer work.

2. Visit the Internal Mobility page on Inside Adobe to learn more about the process and set up a job alert for roles you're interested in.

3. Check out these tips to help you prep for interviews.

4. If you are applying for a role outside of your current country, ensure you review the International Resources for Relocating Employees on Inside Adobe, including the impacts to your Benefits, AIP, Equity & Payroll.

Once you apply for a role via Workday, the Talent Team will reach out to you within 2 weeks. If you move into the official interview process with the hiring team, make sure you inform your manager so they can champion your career growth.

At Adobe, you will be immersed in an exceptional work environment that is recognized around the world. You will also be surrounded by colleagues who are committed to helping each other grow through our unique Check-In approach where ongoing feedback flows freely. If you're looking to make an impact, Adobe's the place for you. Discover what our employees are saying about their career experiences on the Adobe Life blog and explore the meaningful benefits we offer.

Adobe is an equal opportunity and affirmative action employer. We welcome and encourage diversity in the workplace regardless of gender, race or color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other characteristics protected by law.

If you have a disability or special need that requires accommodation to navigate our internal careers site or to complete the application process, please contact