Business Intelligence Architect

Business Intelligence Architect

Adobe
5-8 years
Not Specified

Job Description


Position Summary:
Working as a team member on the PS Analytics & Insights team, you will provide technical support to our primary reporting and analytics platform, supporting Adobe's Global DX Professional Services organization. Reporting into the Manager of Business Intelligence, you will be responsible for providing architectural support to meet the needs of a fast-paced organization. You will be well-versed in full-stack Business Intelligence solutions, including but not limited to database architecture, data pipeline management, data modeling, and report development. You will have expert SQL skills, and demonstrated experience with various performance tuning techniques. You are a detail-oriented architect with an extensive knowledge of Business Intelligence and data engineering tools and approaches, primarily focused on scale and quality. You are innovative, creative, and can anticipate challenges before they occur. Your ability to foster relationships across the business will allow you to reduce scope ambiguity and deliver collaborative wins.
Responsibilities:

  • Execute against a technical roadmap aimed at the long-term scale of our Business Intelligence platform.

  • Translate complex business requirements into technical solutions.

  • Work with a team of Business Intelligence Architects to develop and optimize a centralized Data Warehouse to support various analytical data cubes.

  • Create data pipelines (ETL, ELT) to blend disparate data sources together.

  • Maintain technical standards and documents (Data Dictionary, development style guide, ERD, etc.).

  • Diagnose performance issues and provide recommendations to improve platform scale.

  • Assist in growing the business usage of Business Intelligence tools to drive efficiency in reporting.

  • Collaborate with high performing teams across multiple geographies.

Requirements:

  • Bachelor's degree required, preferably in Mathematics, Computer Science, Statistics or a Business-related degree.

  • 5+ years of relevant experience in the Business Intelligence or Data Science sector.

  • Expert level SQL skills (TSQL preferred).

  • Advanced data warehousing and data modeling skills (RDBMS, OLTP, DW, OLAP, etc.).

  • Advanced knowledge of Business Intelligence concepts & performance tuning methods (ETL vs ELT, Dimensional Modeling, Schema types, etc.).

  • Demonstrated experience architecting end-to-end Business Intelligence solutions (MSFT BI stack preferred: SSMS, SSIS, SSAS).

  • Experience with enterprise software applications (SFDC, MSFT Dynamics, SAP, Workday, etc.).

  • Strong knowledge of Business Intelligence Tools (Power BI preferred).

  • Strong knowledge of business-facing analytics and automation tools (SharePoint, Excel, Power Automate, etc.).

  • Demonstrated working knowledge of DAX & MDX.

  • Ability to learn technology quickly through instruction and self-training.

  • Strong verbal and written communication skills.

  • Experience in delivering projects using an agile methodology, i.e., SCRUM.

  • High attention to detail, and thoroughness.

  • Ability to work within a virtual internal team to lead discovery and to deliver recommendations at an Executive level.

  • Ability to align efforts of disparate groups to achieve a common goal.

  • Ability to manage large single projects or multiple concurrent smaller projects.

  • Self-motivated and not afraid to tackle unknowns, demonstrating a strong bias to action.

About Adobe

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. There's more than meets the eye when it comes to Adobe. Take the quiz and see how well you know us! 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. 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, please contact accomodations@adobe.com .

Similar Jobs

People Also Considered

Career Advice to Find Better