Data Architect

Adobe; Bengaluru; On-site; INR 1,500,000 - 2,000,000; Full time

Job summary

Adobe is looking for a Data Architect with extensive experience in data modeling and ETL. The successful candidate will have 5+ years of experience with Adobe Experience Platform (AEP) and a background in data transformation on large datasets. Responsibilities include interfacing with customers to gather requirements and leading project discussions. A degree in Computer Science or related field is required. Strong communication skills also essential. This position is a fantastic opportunity to impact Adobe's data-driven initiatives.

Qualifications

• 5+ years of strong experience on AEP, RTCDP, CJA, and AJO.
• 10+ years of strong experience with data transformation & ETL on large data sets.
• 5+ years of Data Modeling experience (i.e., Relational, Dimensional, Columnar, Big Data).

Responsibilities

• Interface with Adobe customers to gather requirements.
• Lead customer project conference calls.
• Deliver Technical Specifications documents for customer review.

Skills

Data Modeling

SQL

ETL

AEP

Data Transformation

Data Warehouse Concepts

Reporting Technologies

Programing Languages

Education

Degree in Computer Science, Information Systems, Data Science, or related field

Tools

Informatica

Tableau

PowerBI

Hadoop

Spark

Redshift

Snowflake

Hive

Pig

Job description

Data Architect – AEP Competency

Experienced data modelers, SQL, ETL, with development background and experience on AEP, RTCDP, CJA and AJO to provide defining new data schemas, data ingestion for Adobe Experience Platform customers. Interface directly with enterprise customers and collaborate with internal teams.

Responsibilities

• Interface with Adobe customers to gather requirements, design solutions & make recommendations
• Lead customer project conference calls or interface with a Project Manager
• Deliver Technical Specifications documents for customer review
• Strong collaboration with team software engineer consultants onshore & offshore
• Leverage understanding of data relationships and schemas to structure data to allow clients to perform dynamic customer-level analysis
• Construct processes to build Customer ID mapping files for use in building a 360-degree view of customers across data sources
• Leverage scripting languages to automate key processes governing data movement, cleansing, and processing activities
• Bill & forecast time toward customer projects
• Innovate on new ideas to solve customer needs

Requirements

• 5+ years of strong experience on AEP, RTCDP, CJA and AJO
• 10+ years of strong experience with data transformation & ETL on large data sets
• Experience with designing customer centric datasets (i.e., CRM, Call Center, Marketing, Offline, Point of Sale etc.)
• 5+ years of Data Modeling experience (i.e., Relational, Dimensional, Columnar, Big Data)
• 5+ years of complex SQL or NoSQL experience
• Experience in advanced Data Warehouse concepts
• Experience in industry ETL tools (i.e., Informatica, Unifi)
• Experience with Business Requirements definition and management, structured analysis, process design, use case documentation
• Experience with Reporting Technologies (i.e., Tableau, PowerBI)
• Experience in professional software development
• Demonstrate exceptional organizational skills and ability to multi-task simultaneous different customer projects
• Strong verbal & written communication skills to interface with Sales team & lead customers to successful outcome
• Must be self-managed, proactive and customer focused
• Degree in Computer Science, Information Systems, Data Science, or related field

Special Consideration(s)

• Experience & knowledge with Adobe Experience Cloud solutions
• Experience & knowledge with Digital Analytics or Digital Marketing
• Experience in programming languages (Python, Java, or Bash scripting)
• Experience with Big Data technologies (i.e., Hadoop, Spark, Redshift, Snowflake, Hive, Pig etc.)
• Experience as an enterprise technical or engineer consultant

Adobe is proud to be an Equal Employment Opportunity 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 protected characteristic. Learn more.