Data Architect

Full Time
  • Post Date: June 8, 2021
  • Apply Before: December 31, 2021
Job Description

Job Type: Full time

Workplace: Atlanta, GA OR Dallas, TX OR Irvine, CA


Project Scope:

Maintain and advance a data, analytics and reporting solution in AWS using Snowflake and MicroStrategy products that leverages and extends the Cox Automotive Data Platform patterns and capabilities.

The program includes:

•Data Lake

•Data Warehouse


•Data share, workflow and operations

•Data Ops



•Provide Architecture leadership and guidance

•Sets data vision and direction, collaborate and drives cloud data architecture strategy and long-term planning.

•Recommends standards, policies, and procedures for the form, structure, and attributes of the data tools and systems.

•Design data solutions for Snowflake using best practices.

•Design operational data store (ODS) that complements the data warehouse

•Fosters the reusability of data through modeling consistency, simplicity, and discoverability.

•Integrate with other Snowflake databases

•Provides guidance and oversight, sharing best practices in data architecture to the team members.

•Collaborates with and guides the business in data rationalization and data sourcing.

•Communicates data architecture to stakeholders and team members

•Research latest data technologies and develops proof of concept

•Involved in data vendor selection processes and management throughout the project lifecycle.

•Plan effective data storage, sharing, and publishing

•Develop and update technical documentation

•Strictly adhere to version control and release management using GitHub

•Ensure Provisioning Management using Terraform and Jenkins Automation

•Follow DSS development life cycle through CAFÉ and agile sprints.

•Guide on new architecture, review and approve security standards, development architecture, code, test cases

•Coordinate with Offshore team.


Job Qualification

•Bachelor’s and/or master’s degree in computer science or related field

•Five+ years of experience delivering high quality software products

•Hands on with MicroStrategy Metadata, Memory Cubes, Scheduling and Dossier 2020

•Hands on with AWS Services including DMS, EMR, PySpark, Snowflake and AirFlow.

•Hand on with Snowflake and associated ELT pipeline technologies

•Strong experience/working knowledge of Lambda, AWS SQS, AWS SNS, DynamoDB, Redshift, Aurora for data pipelines.

•Strong Experience with Data engineering utilizing Python/PySpark and Spark SQL on AWS EMR

•Proven track record working on high volume, large databases that require performance tuning.

•Familiarity with Jenkins/GIT dev ops

•In-depth knowledge and experience of the software development lifecycle

•Having experience to work/lead onsite/offshore model team.

•Strong communication skills. Able to easily collaborate with peers and customers.

•Technical Leadership: driving the team, work through complicated situations, problems. Get things done in very short time duration.

•Experience delivering software in an Agile or Lean delivery method

•Strong SQL query knowledge

•Experience in production support design decisions with our business partners and the rest of the development team members



Email: [email protected]