Data Architect

Job Title: Data Architect

Location: Remote

Fulltime/Contract

About Smart IT Frame:

At Smart IT Frame, we connect top talent with leading organizations across the USA. With over a decade of staffing excellence, we specialize in IT, healthcare, and professional roles, empowering both clients and candidates to grow together.

Position Summary:

• Client is looking to have expertise in one of the data platforms i.e. Databricks, snowflake and willing to do programming in Python/Pyspark.

• Experienced database data modelers Join team of Data Architects to work closely with enterprise customers & collaborate with Adobe consultants. Gain insights & experience with the new, industry leading Adobe.

• Experience Platform. Provide data discovery, define new data schemas, support data ingestion, build creative SQL and sophisticated segments for our Adobe customers.

What you'll do:

• PROJECT TEAM: Coordinate closely with Adobe project team members & work directly with customers to document requirements for Adobe platform solution

• DATA DISCOVERY: Work closely with Enterprise Architect & Digital Strategist roles to provide data discovery with systems & business process review

• DATA SCHEMA DESIGN: Analyze customers' disparate data sources to design & tailor a data model that unifies the data (e.g., sales, CRM, analytics data etc.) to meet customer's digital marketing use cases.

• PLATFORM SETUP: Configure Adobe platform data lake & real-time customer profile to prepare for data ingestion and activation. Create REST API's, POSTMAN and ad hoc basic scripting to automate & streamline setup to additional environments.

• DATA INGESTION: Test schema design loading sample data within platform & coordinate with Data Engineer consultants for customer data importing.

• SEGMENTATION: Build, test & schedule customer segments to activate use cases

• QUERY: Develop tailored sophisticated SQL to provide answers to customers' business questions with the combined platform data (e.g., 360-degree view of customers across data sources)

• CONSULTING: As part of Adobe Consulting organization, project time tracking, billing hours & forecast time toward customer projects and other key reporting are required

• INNOVATION: Join a team of Data Architects to learn & innovate together on new insights to improve team processes & solve customer needs Requirements

• Proficiency & experience with designing customer centric database models, datasets (e.g., CRM, Call Center, Marketing, Offline, Point of Sale etc.)

• Proficiency with data transformation & ETL tools (e.g., Informatica, Unifi, Snaplogic) on large data sets

• Proficiency with Data Modeling experience (e.g., Relational, Dimensional, Columnar, Big Data)

• Proficiency with complex SQL and NoSQL experience

• Experience in advanced Data Warehouse concepts

• Experience with Business Requirements definition and management, structured analysis, process design, use case documentation

• Experience with Reporting Technologies (e.g., 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 coordinate with Sales team & lead customers to successful outcome

• Must be self-managed, proactive and customer centric

• Degree in Computer Science, Information Systems, Data Science or related field Special Consideration given for

• Experience & knowledge with Adobe Experience Cloud solutions or industry relevant Digital Analytics or Digital Marketing experience

• Experience in programming languages (Python or Bash scripting)

• Experience with Big Data technologies (e.g., Hadoop, Spark, Redshift, Snowflake, Hive, Pig etc.) Experience as an enterprise technical or engineer consultant

Apply today or share profiles