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.
Required Skills & Experience
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
Nice to Have Skills & Experience
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.
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.