Data Analyst / ETL Developer

PMA Companies provides risk management solutions and services in the U.S., specializing in workers’ compensation, and offering property and casualty insurance. Headquartered in Blue Bell, PA, PMA has over a century of successful business experience.

The Data Analyst / ETL Developer will be responsible for designing data models, databases and ETL processes to extract, transform, clean, and move data into our Enterprise Data Warehouse and data Stores.

* Interview business users to obtain data requirements for new analytic applications. * Map source system data to data warehouse models. * Designs conceptual, logical and physical models for the data warehouse or data mart. * Evolves models to meet new and changing business requirements. * Develop and test extraction, transformation, and load (ETL) processes. * Define and capture metadata and rules associated with ETL processes. * Adapt ETL processes to accommodate changes in source systems and new business user requirements.

* College degree in Computer Science or Information Systems * Have applied the Kimball methodology to EDW development in an enterprise setting. * 7+ years work experience with a variety of ETL tools including at least 5 years' recent experience with Microsoft SSIS/DTS. Experience with IBM DataStage a plus. * Experience with a data modelling tools, preferably ERWIN. * Hands-on experience with large-scale data modeling, data mining and business requirements gathering / analysis. * Experience with Data Warehousing data population tools and techniques for target structures such as Star Schemas, Snowflake Schemas, highly normalized and dimensional data models * Knowledge of database design principles with specific application to a data warehouse including the handling of history, support for slowly changing dimensions and techniques for addressing performance issues. * Working knowledge of Master Data Management (MDM) a plus. * Experience creating documentation including functional specifications, source to target mappings, system specifications. * Experience in building and maintaining database applications including creation and administration of database objects like tables, indexes, views, physical data constraints, access privileges. * Experience in building customized code in SQL or other Data-mining / ETL tools. * Working knowledge of C# or VB. * SQL Server and/or DB2 required. Knowledge of both will be an added advantage. * Experience in property and casualty insurance a plus. * Excellent oral and written communication skills.