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
•Reporting
•Data share, workflow and operations
•Data Ops
Responsibility:
•Fully understand existing migration plan for DMS legacy reporting stacks.
•Fully understand existing migration plan for legacy OBIEE data sharing agents.
•Design and implement data modeling solutions using relational, dimensional, and NoSQL databases.
•Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
•Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
•Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
•Hands-on modeling, design, configuration, installation, performance tuning.
•Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
•Develop and update technical documentation
•Strictly adhere to version control and release management using GitHub
•Ensure Provisioning Management using Terraform and Jenkins Automation
•Follow 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
•Good knowledge of metadata management, data modeling, and related tools
•Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required
•Significant experience (5+ years) with MicroStrategy Metadata, Memory Cubes, Scheduling and Dossier 2020
•Be hands-on in AWS Services including DMS, EMR, PySpark, Snowflake and AirFlow.
•Experience with Snowflake and associated ELT pipeline technologies
•Proven track record working on high volume, large databases that require performance tuning.
•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
•Familiarity with Jenkins/GIT dev ops
•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
Contact
Email: [email protected]