Build robust data warehouse/marts/sets which will enable business users to make informed decisions.
Requirements
- 5-10 years minimum experience writing SQL, DAX, SSAS, and creating SSIS Packages
- Knowledge of Software Development Life Cycle, Git, Agile
Responsibilities
- Develops ETL processes to extract data from various sources, transform it into a format suitable for analysis across AmTrust.
- Create moderately complex data models that describe the relationship between different data entities.
- Develop database schemas that are optimized for querying and analysis.
- Design advanced validation and cleansing processing to identify and fix data quality issues for quality and accuracy of the data throughout
- Work with IT resources to integrate data warehouse data, test and validate report building, process automation, and dashboard development.
Other
- Undergraduate degree in Computer Science, Information Systems, Engineering, or equivalent years of work experience.
- Medium-to-Advanced level understanding of business processes of a variety of areas in the company including finance, operations, underwriting, sales, claims, and actuarial to develop a deep understanding of the workflow and the relevant data to produce insights for the larger organization.
