Autosoft, Inc. (https://autosoftdms.com) is a Dealership Management System (DMS) software company serving the retail automotive industry for 30 years. At Autosoft, we embrace change, encourage out of the box thinking, and listen to our employees to help shape the future of our business.
Who You Are: As the ETL Developer, you will participate and lead discussions around new feature requirements and develop database functionality to meet the requirements. Continually seeking ways to improve the process of data conversion, migration and integration from the current applications, APIs and various data sources to new systems.
What You’ll Do:
Develop stored procedures, functions, etc. in T-SQL
Create database objects including tables, views, triggers, etc.
Perform data modeling for new applications or extensions of existing applications
Ability to design ETL flows and data mapping/data migration process to ensure successful data migration from legacy systems
Execute performance improvements through optimizing queries, adding indexing, or other methods
Build and execute data migration scripts
Build database release scripts and execute them in development, staging, and production environments
Experience with ETL and data migration activities
Profile data to measure quality, integrity, accuracy and completeness
Advise business on options, risks and any impacts related to data conversion and migration
Turn process into detailed functional requirements, including but not limited to data mapping, file inventories, and data flow
Serve as a functional SME to development team as they implement the data needs as documented
Communicate as necessary, to ensure transparency, share insights, define scope, requirements, and coordinate between teams to manage expectations
What You’ll Need:
Bachelor’s degree in Computer Science, Information Systems and/or equivalent formal training or work experience
Minimum 5 years of experience in development using Microsoft SQL Server (2012 or newer) – Standard and Enterprise
Advanced knowledge of SSIS and SSRS
Data Modeling, Data Archiving, Query & Performance Analysis Experience
Advanced T SQL skills, ORM, Stored Procedures, Table Functions
Experience working with multi-tenant databases
Proven work experience on an enterprise-level projects
Working experience in an Agile development environment strongly preferred
Excellent communication skills, both written and oral
Superior organization, prioritization, analytical and problem-solving skills
Manage challenging timelines and schedules
History of implementing stable, robust solutions quickly and efficiently
Ability to adapt to changing assignments and multiple priorities
Ability to manage multiple tasks and successfully meet deadlines collaboratively with other departments.
Experience with Git repositories
Familiar with using data formats JSON and XML
Basic understanding of API end points (SOAP and REST)
Experience with Agile SCRUM and KANBAN Development process
Experience defining data objects, models and data definitions for financial or automotive business systems by mapping its various components as required for Data Migration/Conversion/Integration
Experience in SQL index management, performance optimization with large datasets, data warehouse/data mining
