Principal Software Engineer

Who We Are

Solera is a global leader in data and software services that strives to transform every touchpoint of the vehicle lifecycle into a connected digital experience. In addition, we provide products and services to protect life’s other most important assets: our homes and digital identities. Today, Solera processes over 300 million digital transactions annually for approximately 235,000 partners and customers in more than 90 countries. Our 6,500 team members foster an uncommon, innovative culture and are dedicated to successfully bringing the future to bear today through cognitive answers, insights, algorithms and automation.  For more information, please visit solera.com

The role
We’re looking for a hardworking, success-oriented team player who knows the ins and outs of data and can work in a fast-paced environment. If you’re constantly researching new and exciting uses of technology, we want to talk to you.

What you'll do

• Drive innovations by keeping current on emerging cloud technologies
• Act as a Subject Matter Expert for migrating on-prem applications to cloud-based PaaS, focusing on data warehouse and big data solutions.
• Architect end-to-end data solutions, including data collection
• and storage, data modelling, and data consumption.
• Provide guidance in the migration and transfer of multi-terabyte databases or data warehouses from one data-tier technology to another, based on enterprise strategy.
• Data Modelling: Expertise in data modelling techniques and tools, such as ER modelling and dimensional modelling. Design conceptual and logical data models and flowcharts, including source-to-target mappings, transforms, and data lineage.
• Partner with Application Architects to design data-intensive applications with APIs and streaming data pipelines.
• Design solutions to prepare and transform data into a usable state for multi-platform consumption.
• Create data architecture, engineering and migration patterns for MSSQL, MYSQL, Oracle, Postgres, assisting data tier migrations with multiple technologies, including NoSQL, Relational, Analytical, Big Data, Key Value Data Stores, Data Warehousing, supporting Solera Technology Standards and Strategies (TSS) and Cloud Technology Mapping for software versions, licensing, cost savings and implementation in AWS

What you'll bring

• Lead the design, development, and maintenance of our data engineering infrastructure
• Architect and implement scalable data pipelines for batch and real-time processing
• Establish best practices, coding standards, and technical documentation
• Mentor and provide technical guidance to junior data engineers
• Collaborate with data scientists, analysts, and business stakeholders to understand data requirements
• Optimize data models and database designs for performance and reliability
• Implement data quality controls and monitoring systems
• Evaluate and recommend new data technologies and tools
• Deploy and manage cloud-based data solutions (AWS/Azure/GCP)
• Ensure data security, compliance, and governance standards are met

REQUIREMENTS:

• Bachelor's degree in Computer Science, Engineering, or related technical field (Master's preferred)
• 12+/15+ years of experience in data engineering roles
• 5+ years of experience in a technical leadership position
• Utilising Real-Time, Batch, and NoSQL/SQL technologies.
• Proficiency in data warehousing, data modelling, ETL design, and optimization
• Deep understanding of data enrichment, transformation, security, movement, data architecture, golden record, and data integrity.
• Experience with big data technologies (e.g., Hadoop, Spark, Kafka, Trino, Hive, Iceberg)
• Experience with any data orchestration tools (Airflow, Luigi, etc.)

GenAI:

• Hands-on work in GenAI over the last 1–3 years, including LLM integration, prompt engineering, RAG, MCP, Agentic AI, orchestration frameworks, and inference optimization.
• Familiarity with AWS migration services like Database Migration Service (DMS) and Server Migration Service (SMS).

Technical Skills

• Programming Languages: Python, SQL, Java/Scala
• Big Data Technologies: Apache Spark, Hadoop, Kafka, Hive, Trino
• Any Cloud Platforms(AWS preferred):
• AWS (S3, EC2, RDS, Lambda, DynamoDB, Glue)
• Azure (Data Factory, Synapse, Databricks)
• GCP (Big Query, Dataflow, Dataproc)
• Data Warehousing: Snowflake, Redshift, Big Query, Fabric Data Warehouse
• Any ETL/ELT Tools: Airflow, dbt, Informatica, Talend, Glue
• Hands-on with GenAI
• Databases:
• Relational: PostgreSQL, MySQL, SQL Server, Oracle
• NoSQL: MongoDB, Cassandra, DynamoDB
• Time-series: Influx DB, Timescale DB
• Container & Orchestration: Docker, Kubernetes
• Version Control: Git, GitLab/GitHub workflows
• CI/CD: Jenkins, GitHub Actions, GitLab CI

Data Architecture Skills

• Data modelling (dimensional, relational, NoSQL)
• Database design and optimization
• Batch and real-time pipeline architecture
• Data mesh/data fabric architectures
• Data lake and Lakehouse implementation
• Understanding of API design and development and Microservices architecture is a plus