Description
Applicability:
This policy applies to all full and part-time employees. The hiring manager and HR department reserves the right not to post certain positions when there are lawful, nondiscriminatory bases for doing so.
Eligibility:
To be considered for an open position, employees must:
• Have worked for Ascot for at least 12 months and or/in their current position for at least 12 months (any exceptions require HR approval).
• Have discussed the desire to apply for the position with their direct manager.
• Be an employee in good standing and must not have been subject to disciplinary action in the last 12 months.
• Meet the minimum job requirements to perform the essential functions of the position.
Job Summary:
The Associate Data Engineer, Data Warehousing is critical to the ongoing support of Data Warehousing projects for Ascot US. This role will be responsible to assist with the build, implementation, analysis, testing, and support of data warehouse projects going forward.
ESSENTIAL FUNCTIONS AND BASIC DUTIES:
• Serve as an Associate Data Engineer for projects, enhancements, and production support.
• Be responsible for analysis and support of assigned projects to include hands-on development.
• Establish work estimates based on business requirements through participation in project feasibility, scoping, and estimating activities.
• Assist in creation of high/low level design and technical specification documents that can be accurately executed.
• Validate accuracy/quality of data integrations generated from ETL specifications. Ensure data model specifications are met.
• Assist with hands-on design, development and testing for the low to medium complex data related work.
• Assist with production implementations to ensure smooth, quality releases.
• Collaborate with domain experts, product owners, and management to deliver quality work.
• Coordinate with Ascot and third-party resources to ensure high quality and timely deliverables.
• Think independently and creatively to streamline work and remove inefficiencies.
• Find opportunities to increase speed and quality of output. Must be able to articulate ideas and turn those ideas into new capabilities, performance improvements, and quality improvements.
• Anticipate and remove technical and organizational roadblock
TECHNICAL SKILLS:
• SQL skills including experience using SQL to identify and correct data issues.
• Database knowledge, preferably SQL Server, Synapse
• Some capabilities with scripting/SQL skills to perform ETL, data/file validation, analysis, and profiling.
• Ability to design and create data analysis artifacts showing data behavior and solutioning.
• Ability to create, read, understand, and interpret Data Models
• Strong communication skills to deal with non-technical audiences.
• Code maintenance and review experience in one or more general purpose languages.
• Understanding insurance domain data models, desired
EXPERIENCE AND SKILLS REQUIRED:
• 1-3 years of experience as a Data Analyst/Engineer for a large Data Warehouse working with large data sets.
• ETL Tool experience; SSIS, Informatica, ADF preferred.
• Some experience in the Commercial and/or Specialty insurance industry is desired.
• Strong understanding of financial data and concepts
• Analytical, rigorous, with attention to detail
#LI-Hybrid
Location: Iselin, NJ
Posted: Aug. 14, 2024, 8:11 a.m.
Apply Now Company Website