ETL Developer at Autosoft (West Middlesex, PA) (allows remote)

Posted 2 weeks ago

Apply Now

Job Description

Autosoft, Inc. (www.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


Posted: 09 April, 2019