Data Integration Engineer

3 weeks ago

Pierce, United States The Ladders Full time
The Workers' Compensation Insurance Rating Bureau of California (WCIRB) is California's trusted, objective provider of actuarially-based information and research, advisory pure premium rates, and educational services integral to a healthy workers' compensation system. The WCIRB is a California unincorporated, private, nonprofit association comprised of all companies licensed to transact workers' compensation insurance in California, and has over 400 member companies. No state money is used to fund its operations. The operations of the WCIRB are funded primarily by membership fees and assessments.

To accurately measure the cost of providing workers' compensation benefits, the WCIRB performs a number of functions, including collection of premium and loss data on every workers' compensation insurance policy, examination of policy documents, inspections of insured businesses, and test audits of insurer payroll audits and claims classification.

The WCIRB employs approximately 175 people. The home office is located in Oakland, California.

Employer: Workers' Compensation Insurance Rating Bureau of California

Title: Data Integration (DI) Engineer

Location: 1901 Harrison Street, 17th Floor, Oakland, CA - 94612

Job Description: Analyze data values and data patterns to identify the relationships that link desperate data elements into logical units of information or "business objects". Identify and document the transformation rules, atomic grain of the data in the source systems. Responsible for the full ownership and utilization of the IBM Infosphere Discovery to perform the data discovery tasks. Assess and cultivate long-term strategic goals for Enterprise Data architecture and development in conjunction with end users, business partners and other stakeholders. Create and maintain information on the enterprise critical data entities, data attributes and calculations. Organize the information by business units or subject areas. Responsible for analyzing the aligning the enterprise data models with other business models. Create and maintain enterprise Data Warehouse conceptual, logical, and physical data models. Assist data Systems analysts to analyze and document business and data requirements using EDM recommended techniques. Identify and manage the resolution of data quality and data security issues such as uniqueness, integrity, accuracy, consistency, privacy, and completeness in a cost-effective and timely fashion. Create elaborative unit test plan different test cases. Executes each unit test case and ensures that quality meets design specifications prior to quality assurance/integration testing. Support data/Information governance by providing reporting and traceability on data movement, modeling and business intelligence applications as required by regulatory requirements. Telecommuting permissible three (3) days per week.

Requirements: Bachelor's degree or foreign degree equivalent in Computer Science, Engineering (any) and five (5) years of progressive, post-baccalaureate experience in the job offered or related role.

Experience and/or education must include:

  1. Design, Implementation and Maintenance of Data Model in Datawarehouse composed of data from multiple Systems such as MS SQL server.
  2. Creation of ETL Workflow for Data Integration to facilitate data load into the Datawarehouse for generating reports containing metrics for the customers.
  3. Conduct Data Analysis to understand business requirements on the unstructured sources;
  4. Design and Development of the ETL (Extract Transform and Load) and solutions using IBM Infosphere DataStage and Stored procedures.
  5. Building of Visual Reports for Internal Customers to show KPI's
  6. Development of project schedules and ETL process as per the project requirements and
  7. Experience in Agile and SDLC Process.
  8. IBM Infosphere Foundation Tools and scripting in UNIX for Automation of File Transfer, Archival or deletion process.


Perks & Benefits

Our employees enjoy a state of the art, energy-efficient, open work environment that nurtures collaboration and creativity. At the WCIRB, we go the extra mile to keep our employees happy and healthy. Our perks include:
  • Hybrid work environment (40% onsite 60% remote)
  • Medical, dental and vision benefits
  • Competitive PTO Program
  • 401K and pension plan
  • Annual incentive plan
  • Social activities
  • Community volunteer involvement


Please note that the WCIRB has enacted a mandatory COVID-19 vaccine requirement for all employees. Proof of full vaccination or an approved exemption or deferral is required of all employees, including new hires.

Other: Job Site: 1901 Harrison, 17th Floor, Oakland, CA 94612; 40 hours/week; $196,685/yr - $201,685/yr. If offered employment, the applicant must have legal right to work in U.S. EOE.

To Apply:

  • Data Scientist

    3 weeks ago

    Pierce, United States BinckBank Full time

    Data Scientist for Marketing at Saxo Bank Are you passionate about leveraging data to drive impactful marketing strategies? Saxo Bank is on an exhilarating journey to become a data-driven organization, and we are seeking a dynamic Data Scientist to take the lead of the development of our predictive models focused on marketing. If you are eager to make a...

  • Cloud Infrastructure Engineer

    2 weeks ago

    Pierce, Idaho, United States National Rural Utilities Cooperative Finance Corpo Full time

    Microsoft Systems Engineer Become a pivotal member of a dynamic organization dedicated to enhancing the operational capabilities of rural electric cooperatives across the nation. Since its inception in 1969, the National Rural Utilities Cooperative Finance Corporation (CFC) has been at the forefront of providing essential financial solutions to nearly 1,000...

  • Microsoft Systems Engineer

    2 months ago

    Pierce, United States National Rural Utilities Cooperative Finance Corpo Full time

    Microsoft Systems Engineer Join a member-driven leader in a fast-paced, challenging and collaborative environment with the shared mission of supporting America's network of rural electric cooperatives. Since its formation in 1969, National Rural Utilities Cooperative Finance Corporation, or CFC, located in Dulles, Virginia, has provided capital and...

  • Cloud Infrastructure Engineer

    2 weeks ago

    Pierce, Idaho, United States National Rural Utilities Cooperative Finance Corpo Full time

    Microsoft Systems Engineer Become a key player in a dynamic and collaborative environment dedicated to enhancing the operational capabilities of rural electric cooperatives across the nation. Since its inception, the National Rural Utilities Cooperative Finance Corporation (CFC) has been at the forefront of providing essential financial solutions to nearly...

  • Lead Software Engineer

    2 weeks ago

    Pierce, Idaho, United States WEX Full time

    About the Team We provide strategic guidance for our core team by leveraging expertise across various technical domains and adhering to industry best practices. We excel in transforming complex technical features into manageable, actionable tasks for our teams.How You'll Make an Impact Team Collaboration Assist in application support during and beyond...

  • Civil Engineering Project Inspector

    4 days ago

    Ft. Pierce, Florida, United States Actalent Full time

    About the RoleActalent is seeking a skilled Field Inspector to support our clients in the civil engineering and geotechnical engineering sectors. As a Field Inspector, you will play a critical role in ensuring the quality and compliance of construction projects.Key ResponsibilitiesPerform field and laboratory tests on soil, geosynthetics, aggregates, and...

  • Director of Technology Operations

    4 weeks ago

    Pierce, United States DIGITAL INSURANCE Full time

    Director of Technology Operations - Hybrid (Atlanta, GA) Summary: As the Technical Leader for IT Infrastructure, Network, Telecom, and Cloud Management at OneDigital, you will be at the forefront of our technology landscape, driving innovation, efficiency, and reliability. Reporting to the VP of IT Infrastructure, security, and Operations, your role combines...

  • Head of Technology Operations

    2 weeks ago

    Pierce, Idaho, United States DIGITAL INSURANCE Full time

    Position: Director of Technology OperationsOverview:As the leading authority for IT Infrastructure, Networking, Telecommunications, and Cloud Management at DIGITAL INSURANCE, you will play a pivotal role in shaping our technological framework, fostering innovation, efficiency, and dependability. Reporting directly to the VP of IT Infrastructure, Security,...

  • Chief Technology Operations Officer

    2 weeks ago

    Pierce, Idaho, United States DIGITAL INSURANCE Full time

    Chief Technology Operations Officer - HybridAs the leading authority for IT Infrastructure, Networking, Telecommunications, and Cloud Management at DIGITAL INSURANCE, you will play a pivotal role in shaping our technological framework, fostering innovation, and ensuring operational excellence. Reporting directly to the VP of IT Infrastructure, Security, and...

  • Head of Technology Operations

    2 weeks ago

    Pierce, Idaho, United States DIGITAL INSURANCE Full time

    Position Title: Director of Technology Operations - HybridOverview:As the leading authority in IT Infrastructure, Networking, Telecommunications, and Cloud Management at DIGITAL INSURANCE, you will spearhead our technological initiatives, fostering innovation, efficiency, and reliability. Reporting directly to the VP of IT Infrastructure, Security, and...

  • Manager, Investment Performance Analysis

    2 weeks ago

    Fort Pierce, FL, United States StandardAero Full time

    Build an Aviation Career You're Proud Of Your work ties us all together, helping our teams function and operate. Work with the latest technologies and techniques in the aviation industry to source materials, manage inventory, and coordinate logistics. As a Quality Manager , you'll have responsibility in managing implementing & reporting on the state of...

  • Senior Database Administrator I

    2 months ago

    Pierce, United States National Rural Utilities Cooperative Finance Corpo Full time

    Senior Database Administrator I Join a member-driven leader in a fast-paced, challenging and collaborative environment with the shared mission of supporting America's network of rural electric cooperatives. Since its formation in 1969, National Rural Utilities Cooperative Finance Corporation, or CFC, located in Dulles, Virginia, has provided capital and...

  • Lead Application Engineer

    2 weeks ago

    Pierce, Idaho, United States FBL Financial Full time

    Senior Application Developer Are you a motivated individual who excels in a dynamic, achievement-focused setting? We are looking for a proactive team member to contribute to a high-performing, collaborative environment where each day presents new challenges.Key Responsibilities: FBL Financial is in search of a Senior Application Developer to enhance the...

  • Senior .NET Technical Leader

    2 weeks ago

    Pierce, Idaho, United States WEX Full time

    About the Team As a pivotal member of our team, you will provide guidance and direction across various technical domains while adhering to industry best practices. Your ability to simplify complex technical features into manageable tasks will be essential for the success of WEX Health teams.How You'll Make an Impact Team Collaboration Assist in the...

  • Principal .NET Technical Leader

    2 weeks ago

    Pierce, Idaho, United States WEX Full time

    About the Team As a pivotal member of our team, you will provide guidance across various technical domains and adhere to industry best practices. Your expertise will enable you to deconstruct complex technical features into manageable, actionable tasks for the WEX Health teams.How You'll Make an Impact Team Collaboration Assist in maintaining applications...

  • MDS Coordinator

    7 days ago

    Pierce, United States Accura HealthCare Full time

    JOB HIGHLIGHTS: Due to exciting growth, Accura HealthCare is adding a full time on-site MDS LPN. JOB SUMMARY:The MDS (Minimum Data Set) Coordinator is required to be knowledgeable of applicable laws and/or licensing regulations for healthcare facilities. This includes compiling information, preparing statistical reports and data from health records, and...

  • MDS Coordinator

    1 week ago

    Pierce, United States Accura HealthCare Full time

    JOB HIGHLIGHTS:Competitive Wage DOEMedical, Dental, Vision and additional ancillary benefitsSupportive environment for work-life balanceJOB SUMMARY:The MDS (Minimum Data Set) Coordinator is required to be knowledgeable of applicable laws and/or licensing regulations for healthcare facilities. This includes compiling information, preparing statistical reports...

  • Senior Manager, SAP Finance Team Lead

    4 weeks ago

    Pierce, United States YETI Coolers Full time

    Senior Manager, SAP Finance Team Lead At YETI, we believe that time spent outdoors matters more than ever and our gear can make that time extraordinary. When you work here, you’ll have the opportunity to create exceptional, meaningful work and problem solve with innovative team members by your side. Together, you’ll help our customers get the...

  • Lead SAP Finance Manager

    2 weeks ago

    Pierce, Idaho, United States YETI Coolers Full time

    Position Overview:The Senior Finance Integration Manager will spearhead essential program and project initiatives within the Finance Systems and Integrations domain.As the primary authority on content, processes, and procedures pertaining to SAP Finance, this role will supervise a team of both internal and external FICO professionals while collaborating with...

  • MDS Coordinator

    6 days ago

    Pierce, United States Accura HealthCare Full time

    JOB HIGHLIGHTS: Due to exciting growth, Accura HealthCare is adding a full time on-site MDS LPN. JOB SUMMARY: The MDS (Minimum Data Set) Coordinator is required to be knowledgeable of applicable laws and/or licensing regulations for healthcare facilities. This includes compiling information, preparing statistical reports and data from health records, and...