Data EngineerUSI Insurance Services • New York, New York, United States
Cette offre d'emploi n'est plus disponible
Data Engineer
USI Insurance Services
- New York, New York, United States
- New York, New York, United States
À propos
Responsibilities
Participate in the design, development, and maintenance of Azure Data Factory and dbt data pipelines. Utilize extract, load, and transform (ELT) methodologies to move data from various systems into a Snowflake enterprise data warehouse.
Participate in the design, development, and maintenance of SSIS/TSQL processes. Utilize extract, transform, and load (ETL) methodologies to move data from disparate systems into SQL databases.
Contribute to the development of best practices for data ingestion, dataset creation, storage and updates, naming conventions, and retention.
Collaborate with stakeholders to define tables, views, and schemas to support data products.
Participate in the design and implementation of data models in Snowflake. Ensure they are efficient, scalable, and optimized for performance.
Monitor the data movement processes and pipelines for overall health and performance.
Investigate and troubleshoot issues to ensure data availability and reliability.
Fine tune and optimize SQL queries and pipelines for improved efficiency.
Operate in accordance with USI Policies for the Information Security Program (PISP) and USI Standards for the Information Security Program (SISP).
Keep up to date with security updates and improvements. Implement improvements as appropriate.
Protect systems against unauthorized access by appropriately defining access.
Upgrade systems by implementing and maintaining security and technical controls.
Knowledge, Skills and Abilities
5+ years SQL programming, SQL database design, and data architecture concepts.
Bachelor’s degree in computer science, information systems, statistics, or a related field.
Experience with data models and data warehousing.
Experience working with SCRUM agile processes.
Experience with Microsoft Azure components such as DevOps and Azure Data Factory.
Good understanding of Snowflake or similar cloud data warehousing.
Good understanding of modern data transformations using dbt or similar tool.
Hands‑on experience working with Git code repositories and CI/CD tools.
Working knowledge of insurance brokerage or sales workflows and systems preferred.
Benefits Salary Range: $110,000–$125,000. This is a bonus‑eligible position with a target incentive of 8%.
USI offers a full suite of competitive benefits for our growing population and its diverse needs. We offer a wide range of health, welfare and financial benefits including medical, wellness, dental and vision, 401(k), flexible spending and health savings accounts, short and long‑term disability, life insurance and other unique employer-sponsored and voluntary programs. USI also offers a generous paid time off policy, paid family leave benefit as well as paid holiday time.
#J-18808-Ljbffr
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre a été publiée par l’un de nos partenaires. Vous pouvez consulter l’offre originale ici.