Data Developer I

Aegis•Jersey City, NJ

22h•$80,000 - $85,000•Hybrid

About The Position

AEGIS Insurance Services, Inc. (“AEGIS”) has an immediate opening for an Data Developer I responsible for the development and testing of data integration workflows (ETL Packages, Stored Procedures, UDF, Adhoc-Queries), test plans, and test cases using Microsoft technologies such as SSIS, SSAS and SQL Server Database, as well as company-wide document management. The incumbent works closely with the IT development and analyst teams which maintains a broad portfolio of business critical vendor and custom applications.

Requirements

Minimum 2 years of experience with Microsoft SSIS, SSAS and Relational Database technologies
Exposure to web services (SOAP, XML, etc.)
SQL Server including T-SQL or PL/SQL
Data warehousing – Data Modeling (Star - Schema), Data Profiling
Insurance industry (Property & Casualty desired)
Experience implementing coding best practices via code reviews and code inspection tools
Experience implementing Code Version Control such as GitHub
Undergraduate degree in Computer Science, Engineering, Software Engineering or Mathematics, or equivalent work experience
Demonstrated ability to write efficient, maintainable SQL and Python code

Responsibilities

Write efficient, maintainable SQL and Python code to create, implement, and optimize data pipelines ensuring high data quality and flow across systems
Responsible for ETL and Data PL/SQL coding and unit testing based on the design provided by the Enterprise Data Lead
May contribute to the development of part of a larger initiative or independently manage a standalone project
Collaborate and exchange work seamlessly with offshore developers
Collaborate with business analysts, testers and business users to effectively prioritize development activities within resource constraints
Provide technical support for assigned applications
Develop and maintain current, relevant technical documentation for assigned applications
Provide appropriate training to users on the use of assigned applications
Continuously develop knowledge of new technology practices, platforms, and tools, and remain up to date on the latest technological trends