| Title | Data Engineer |
| Posting Date: | 03/18/2019 |
| Location: | Multiple Locations |
| Job Type | Full Time |
Job Summary:
Equinox is looking for a Data Engineer to develop, maintain, test and evaluate data solutions in support of business goals. The person will also develop data models, corresponding data architecture documents and API’s. The right candidate should be an excellent communicator and strategic thinker.
Responsibilities and Duties:
• Create, design and maintain reusable data sets 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.
Required Experience, Skills and Qualifications:
• 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).
• Insurance experience a plus.