We are seeking a talented Lead Data Software Engineer/Data Solution Architect to join our team in the automotive sector.

This role involves working with innovative recon software that simplifies documentation, optimizes processes, and delivers instant insights into business operations. Our goal is to provide the most dynamic and user-friendly technology solutions for automotive reconditioning businesses.

In this dual role, you will take on the responsibilities of both an architect and an engineer. As an Architect, you will play a crucial role in designing schemas and pipelines, defining transformations, and orchestrating efficient data insertion into an analytics-focused relational structure. As an Engineer, you will execute these designs, crafting a robust and efficient system, and utilizing your development expertise to enhance data processing capabilities.

Our current data originates from a MongoDB dump stored in Snowflake, and familiarity with these technologies will be advantageous.

This role presents a fantastic opportunity for individuals who excel in both engineering and architectural disciplines and are eager to make a significant impact on our client's business operations.

The remote option applies only to the Candidates who will be working from any location in Ukraine.

Responsibilities

• Design schemas and pipelines
• Enforce an efficient structure for data insertion
• Build a system focused on optimized data processing

Requirements

• Proficiency in SQL and Snowflake
• Background in Star or Snowflake schema design
• Skills in data warehousing, analytics, and data modeling
• Experience in cleaning, transforming, and preparing data for analysis

Nice to have

• Familiarity with a Business Intelligence tool (Domo preferred)
• Background in MongoDB

We offer

• Work on a flexible schedule remotely or from any of our comfortable offices or coworking spaces in Ukraine
• Receive the necessary equipment to perform your work tasks
• Change projects and technology stacks within EPAM
• Gain experience in various business domains (Insurance, E-commerce, Healthcare, Finance, Travelling, Media, Artificial Intelligence, and more)
• Consider relocation options in over 30 countries worldwide
• Participate in volunteer, charity programs and communities (both technical and interest-based)
• You can plan your individual career path together with your manager
• Receive regular feedback from colleagues
• Improve your English for free with certified teachers (Speaking Clubs, client interview preparation courses, etc.)
• Get the opportunity to undergo free training and certification in AWS, GCP, or Azure Clouds
• Use the internal E-learn training program (18,200+ specialized training and mentoring programs)
• Access corporate accounts on LinkedIn Learning, Get Abstract and other partner resources
• Study at EPAM Solution Architecture School with the instructors who are practicing architects
• Develop as a leader, join Delivery Management, Resource Management, Leadership Essentials school and more
• Participate in internal communities (500+ meetups, technical discussions, brainstorming sessions, online events and conferences annually)
• Vacation and sick leave (including a sick leave without a medical certificate)
• A wide range of Voluntary Medical Insurance programs providing both medical treatment and various preventive options (including sports activities)
• Medical insurance for family members at corporate rates
• Company support during significant life events (childbirth or adoption, marriage, etc.)
• Support for psychological comfort: discounts on services from mental health specialists or coaches, thematic training
• E-kids program - a free programming language training program for EPAMers' children

EPAM strives to provide its global team of over 52,800+ professionals in more than 55 countries with opportunities for professional growth from day one of collaboration. Our colleagues are the source of EPAM's success, so we value cooperation, strive to always understand our clients' business and aim for the highest quality standards. No matter where you are, you will join a dedicated, diverse community that will help you realize your potential to the fullest.