As a  Senior Software Engineer  on the Automotive Client Insights nVision Product Team at Dealer.com, you will be a leader on the team that designs and develops robust and scalable analytics processing applications. You will implement data access services that operate with maximum throughput and minimum latency.

You will be an accomplished, well-rounded developer with a solid understanding of the appropriate use of best practices and frameworks for high volume data processing and analytics. You will mentor junior engineers on good software practices. You will be passionate about exploring the use of innovative technologies and techniques and evaluating them for suitability in our environment.

Your Role:

• Design and develop code that consistently adheres to good programming practices
• Design, develop, and maintain high volume Java and Scala based data processing jobs using industry standard tools and frameworks in the Hadoop ecosystem, such as Spark, Kafka, Hive, Impala, Avro, Flume, Oozie, and Sqoop
• Design and maintain schemas in our analytics database
• Write efficient SQL for loading and querying data
• Collaborate with product managers and technologists to solve business problems
• Mentor junior engineers with all aspects of software development
• Live by Agile (particularly Scrum) principles and collaborate with team members using Agile techniques including test driven development, code reviews, and retrospectives
• Maintain Cox Automotive position as an industry leader by exploring innovative technologies, languages, and techniques in the rapidly evolving world of high-volume data processing

Technologies We Use:

• Development languages/frameworks : Java/Scala, Apache Spark, Kafka, Vertica, JavaScript (React / Redux), MicroStrategy
• Amazon : EMR, Step Functions, SQS, LaMDA and AWS cloud-native architectures
• DevOps Tools : Terraform or Cloud Formation, NewRelic, Jenkins, Grafana, PagerDuty, GitHub, GitHub Actions
• Database : MySQL, Vertica, DynamoDB
• Stream Processing : Kafka, Spark Streaming, Kinesis

What We Look For:

• Ability to work within a dynamic team committed to excellence.
• Team contributor to active discussion, meetings.
• Solid listening skills, ability to be flexible and open minded to all ideas
• Excellent verbal and written communication skills
• Commitment to working in an Agile environment and upholding its principles
• Passionate developer with an innovative mindset
• Strong Java or Scala skills
• Experience with designing and implementing high volume data processing jobs is a plus
• Working knowledge of Spark on EMR is a plus
• Strong database development skills, including advanced SQL, relational and NoSQL database technologies
• Experience with AWS technologies are required.
• Experience deploying infrastructure with Terraform is preferred.
• Experience with CI/CD tools such as GitHub Actions is preferred.
• Strong analytical and problem-solving skills with an understanding of common mathematical principles used in statistical analysis.
• Proven ability to work independently designing, developing and deploying solutions with minimal direction
• Experience designing and developing platform level components including event architectures, messaging, and caching is a plus.
• Experience writing frontends, particularly in JavaScript, is a plus

Responsibilities

• The Senior Developer MicroStrategy has overall responsibility for design, development, and implementation of MicroStrategy dashboards.
• Manage report security, folder security, database row level /Column level security, report schedules and distribution.
• Create MicroStrategy schema and applications objects such as attributes, metrics, prompts, filters, templates, compound metrics, custom groups and consolidation, security Filters and transformation Metrics.
• Develop complex MicroStrategy reports using advanced filters, conditional formatting, transformation metrics, level metrics and custom groups.
• Define the relationship between the attributes, facts, and other objects within MicroStrategy.
• Define Hierarchies and drill functionality within MicroStrategy.
• Design, develop and maintain MicroStrategy reports using standard features such as sort, rank, report filters, view filters, drill up, drill down and prompts.
• Troubleshoot and tune MicroStrategy reports to determine and fix data issues, incorrect joins, incorrect results, and performance issues.
• Senior member of team that interacts with business engagement teams to define dashboards and reporting solutions to meet diverse, complex business needs.
• Establish and maintain design and development best practices.

Qualifications Required:

• Bachelor’s degree and 4 years’ experience in a related field. The right candidate could also have a different combination, such as a master’s degree and 2 years’ experience. a Ph.D. and up to 1 year of experience; or 16 years’ experience in a related field.
• 4+ years of professional application development experience with a proven ability to deliver projects on time
• Experience with Snowflake, Redshift or Vertica
• 4+ years of Enterprise level MicroStrategy development, modeling, administration, and architecture experience.
• Demonstrated experience with MicroStrategy development tools including Architect, Desktop, Web, Mobile, Object Manager, Enterprise Manager, Command Manager, Integrity Manage.
• Demonstrated experience with MicroStrategy applications including reports, dashboards, data visualization, data discovery, data marts and cubes.
• Strong experience on Schema objects like Logical tables, Attributes, Facts, Hierarchies etc
• Experience in implementing of BI projects with a strong understanding about architecture, development, and administration concepts.
• Experience with MicroStrategy security models Experience in Agile development methodology.
• Experience in Data Warehousing (Star/Snowflake schema) concepts.
• Demonstrated experience architecting the semantic layer and schema objects in MicroStrategy.
• Demonstrated experience with MicroStrategy platform administration and services.
• Strong SQL skills, familiar with complex functions and capable of working in large datasets.
• Ability to work with other IT groups and business users.
• Demonstrated experience and ability to deliver results quickly in a fast-paced environment on multiple projects.