Remote SR. Data Engineer - Pomona, United States - Insight Global

Description

A large financial services company is seeking a remote Sr. Data Engineer to join their team of 12.

This individual will be responsible for the following:
Sr. Data Engineer will support the Enterprise Data Warehouse (EDW) and all systems that integrate with it.

The primary goal is to collect, manage, and convert raw data into usable information for data scientists and business analysts to interpret.

As a Senior Data Engineer you will be responsible for the following:

Data Services Architecture

BI Kimball Dimensional Model

Single Source Reporting Architecture (Client + Ops)

Master Data Management

Adhering to professional development standards

Participate in mandatory solution reviews

Support integration with the following systems:

Mainframe Integration Strategy

SQL Server Integration Strategy

Oracle Integration Strategy

Azure Cloud Integration Strategy

3rd Party Cloud Integration Strategy

SharePoint Integration Strategy

File Integration Strategy

Support change control and all Change Advisory Board (CAB) related processes

Support for all departments within

Data Services:
Business Intelligence, Data Warehousing and Advanced Analytics

Organized and strong documentation skills are a requirement for any person working in Data Services

Support and promote Data Governance

A true team member within the Agile framework

Communicates when blocks arise

Accountable for all work completed or not completed

Active contributor in Data Services Agile Delivery Team

EDW Knowledge Base contributor for EDW Systems, EDW Sources, EDW Reports, EDW Report Components, EDW Report Calendar.

This role will be a 6 month contract to hire, remote, but working PST hours.

Experience with MS 365 and additional MS Products

Microsoft AzDo (Dev Ops) - azure DevOps (more of a plus)

MS 365 / SharePoint - less of a requirement but w/ sharepoint need to know how to integrate with enterprise data warehouse.

Bachelor's in Computer Science or related fields strongly preferred

7+ years experience in data centric technology groups such as Data Services, Business Intelligence or Data Warehousing. Specifically need to be a data warehouse developer doing advanced analytics, not just building apps in SQL.

7+ years of experience working with the full SQL BI stack: SSIS, SSAS, SSRS

4+ years experience working with BI focused reporting tools PowerBI

Advanced proficiency with the Microsoft Power Platform

Power Apps

Power Automate

Power Query

PowerBI

Strong understanding of data structures, security, performance, optimization and usability.

Strong understanding of star schema and Kimball Dimensional Modeling