Data Engineer

About the Position

We are seeking a skilled Data Engineer to develop, maintain, and evaluate data solutions in support of business goals. The role involves creating datasets, assessing data sources, and implementing ETL processes.

Responsibilities

• Create, design, and maintain reusable datasets for analysis by data scientists.
• Assess new data sources to better understand availability and quality of data.
• Provide governance and best practices of data structures, data integrity, and querying.
• Interpret business needs from requests, and rapidly implement effective technical solutions.
• Design, implement, and enhance ETL (extract, transform, and load) processes.
• Write SQL queries to answer questions from stakeholders.
• Maintain source code repository of scripts (SQL, Python, R) and other data products (dashboards, reports, etc.).
• Work with technology teams (BA, QA, Dev, and Admin) to understand data capture and testing needs.
• Automate and improve creation/maintenance of reports and dashboards.

Requirements

• BA/BS or Master's degree with emphasis on coursework of a quantitative nature (e.g., Statistics, Computer Science, Engineering, Mathematics, Data Sciences).
• Advanced SQL and relational databases including queries, database definition, and schema design.
• Python or R experience required.
• Writing and maintaining ETL on a variety of structured and unstructured sources.
• Experience sourcing data via REST web services.
• Excellent written and verbal communication skills.
• Microsoft SQL Server, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Excel (pivot tables).

Nice to Have

• Insurance experience a plus.

We Offer

• Competitive salary of $120,000 per year.
• Excellent Benefits Package.

About the Company

Location: Long Beach, NY, United States

Category: Senior

Employment type: Full time

Product: Database