Principal Data Engineer
Principal Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job Duties:Design develop and maintain reliable scalable ETL (Extract Transform and Load) processes EDI framework and processes for data exchange with regulators and rating services. Segregate tables data into different database filegroups and physical data files to perform ETL process efficiently. Utilize Agile development methodologies and traditional waterfall project management to design and build data warehouse objects for insurance companys enterprise data warehouse. Design Star schema / Snowflake Schema models for data warehouse design. Obtain clear requirements from Business and Product Analysts before committing on task development and deliveries. Estimate the work in form of Story Points to give business timeline about adding new functionality (new dimensions/metrics/facts) in data warehouse. Use Erwin data modeling tool to design entity relationship diagrams and customize the companys purchased Insurance Information Warehouse data model. Use BIML Studio to dynamically generate Integration Services packages (SSIS) to transform data from transactional system to Analytical system. Use Visual Studio to maintain the codebase and version history. Write SQL triggers to send alerts and take action to resolve database blocking issues. Fine tune SQL procedures to execute optimal way to ingest data in data warehouse. Work with analysts and business SMEs to ensure that the right data resources are created for selfserve reporting and analytics in Tableau as well as other tools. Telecommuting permitted.
Job Requirements: Bachelors degree in Computer Information Systems Computer Science Computer Engineering or a related field and five 5 years of experience as a database developer systems analyst or related occupation. In lieu of a Bachelors degree employer will accept seven 7 years of experience as a database developer systems analyst or related occupation. Experience must include:
- Five years of experience utilizing Agile development methodologies and traditional waterfall project management to design and build data warehouse objects for enterprise data warehouse.
- Five years of experience building ETL processes (extract transform and load) with SQL Development and administration SSIS (Integration Services) and SSRS (Reporting Services).
- Two years of experience using BIML Studio to dynamically generate Integration Services packages (SSIS) to transform data from transactional system to Analytical system.
- Five years of experience using Erwin data modeling tools to design data warehouse.
- Three years of experience in insurance product design and IBMs Insurance Information Warehouse (IIW) data model for Auto and Property lines of business.
- Five years of experience using Visual Studio to maintain the codebase and version history.
Compensation and Benefits:
- Wage Range: $185058 $225175
- Regular parttime PEMCO employees working at least 24 hours per week and regular fulltime PEMCO employees are eligible to elect coverage under medical dental and vision plans for themselves and their eligible family members with generous employer premium cost shares. In addition as a benefitseligible employee you are:
- covered by employerpaid basic life and accidental death & dismemberment insurance policies as well as long and shortterm disability benefit coverages.
- eligible to participate in PEMCOs 401(k) plan which includes a generous employer match 2 for 1 on the first 6 employee pretax and/or Roth deferral up to federal maximums).
- PEMCO provides the following paid leave programs for benefitseligible employees in their first year of PEMCO employment:
- Vacation accrues at a rate of 10 days for new hires and increases based on a schedule to a maximum annual accrual of 25 days based on tenure.
- Granted four 4 personal days immediately upon hire.
- Paid holidays for the eight 8 holidays observed by PEMCO throughout the calendar year.
- Granted up to ten 10 days of sick leave immediately upon hire (prorated based on hire date and fulltime/parttime status) which is approximately 28 hours more per year than the Washington staterequired accrual.
- In addition PEMCO provides paid time off for bereavement jury duty and employee volunteering in the community.
- Other miscellaneous benefit programs offered by PEMCO include:
- Flexible Spending Accounts
- Education Assistance Program after one year of service
- Scholarship program for children of PEMCO employees after one year of service
- Employee Assistance Program
- Wellbeing program
- Discretionary taxable gifts and gift cards
- And other Perks & Benefits including discounts on computer software and hardware cell phone plans and rental cars
- Other compensation depending on role contributions and performance may include:
- Discretionary bonuses
- Tiered sales commissions and/or incentives (from 525 of employees monthly sales)
- Employee referral bonuses
- Shift differential pay
To apply please submit resume to position posting on PLEASE SEND RESUME TO:
JOB # 491
PEMCO Mutual Insurance Company
Attn: Carolyn Ohlsen
1300 Dexter Avenue North
Seattle WA 98109
Required Experience:
Staff IC
Employment Type
Full-Time
