Data Architect
First seen by Alion on Sep 26, 2026.
Role Overview:
We are looking for a Data Architect with 10+ years of experience in data transformation and ETL on large data sets to interface with Adobe customers, gather requirements, design solutions, and make recommendations.
Total Experience: 10 - 15 years
Required Skills:
- 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
- Experience and knowledge with Adobe Experience Cloud solutions
- Experience and 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
Role and Responsibilities:
- 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 and 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 360 degree view of customer across data sources
- Leverage scripting languages to automate key processes governing data movement, cleansing, and processing activities
- Bill and forecast time toward customer projects
- Innovate on new ideas to solve customer needs
- Demonstrate exceptional organizational skills and ability to multi-task simultaneous different customer projects
- Strong verbal and written communication skills to interface with Sales team and lead customers to successful outcome
- Must be self-managed, proactive and customer focused
Skills
Adobe Experience Platform, Data Modeling, Data Warehousing, ETL, SQL, NoSQL, Data Architect, Reporting Tools