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.
•Work with business, product and engineering to help define reporting and BI needs.
•Work with end users, business analysts, technical architects, and developers to define the data requirements and data structure for BI solutions.
•Work with business analysts to identify and understand requirements and source data systems.
•Lead the creation of a robust, efficient, and scalable BI solution to the requirements.
•Lead design and implementation of conceptual and logical models for the data warehouse or data mart. Evolves data models to meet new and changing business requirements and growth.
•Lead design and development of ETL processes.
•Work with other solution/data architects to ensure that BI solutions are in sync to meet objectives and performance goals as defined in the requirements.
•Participate and advise in validation, data quality management, and data governance reviews.
•Evaluate and improve existing BI systems
•Collaborate with teams to integrate systems
•Develop and execute database queries and conduct analyses
•Create visualizations and reports for requested projects
•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
•Significant experience (5+ years) with MicroStrategy Metadata, Memory Cubes, Scheduling and Dossier 2020
•Working knowledge in web programming with extensive knowledge on BI tools and able to design Cubes, embedded reports, dashboards in Microsoft framework.
•Experience with Snowflake and associated ELT pipeline technologies
•Proven track record working on high volume, large databases that require performance tuning.
•Strong understanding/Knowledge of AWS, Snowflake
•In-depth knowledge and experience of the software development lifecycle
•A good understanding of configuration management, testing and bug tracking
•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]