Note: The job is a remote job and is open to candidates in USA. Ategrity Specialty Insurance Company is a knowledge-rich organization focused on data engineering and delivery. The data engineer will build ETL processes, ensure high-quality data collection, and work with various business functions to support strategic analysis and decision-making.
Responsibilities
- Ensure that data is dependable and high quality and that we’re collecting the right data to enable strategic analysis, measurement, and decision making
- Design, build, and scale data pipelines to extract, load, and transform data from a wide variety of data sources
- Provide documentation, descriptions, and flow diagrams, ensuring any changes to the business rules on master data are documented and communicated effectively
- Work closely with finance and actuarial to ensure they have accurate data for financial and regulatory reporting
- Troubleshoot automation failures and data issues, and recommend new data integrity checks
- Deliver data via Power BI reporting suite and Excel
Skills
- Bachelor's degree in Computer Science, Data Science, Statistics, Informatics, Information Systems, or related field
- Deep knowledge of programming languages and tools (e.g., SQL, SSIS, Power BI, Excel, VBA)
- Experience in data management technologies (Microsoft SQL Server, MySQL, advanced SQL coding, relational database design, data warehousing)
- 2+ years of experience creating deployment pipelines in Azure, Python/SQL or similar programming languages
- 3+ years of experience using SSIS or similar ETL tools
- Experience monitoring the health of data and pipelines using various tools and techniques including open-source monitoring tools, custom dashboards and cloud pipeline monitoring
- Experience engineering P&C insurance data is required
Company Overview