I'm currently working with a global Technology client of ours on an exciting Data Engineer opportunity to support their CRM transformation programme. Working closely with the Data Lead you'll be responsible for building specs and creating code using SQL to facilitate the ETL process from legacy platforms to the new CRM.
ADM201, Platform App Builder certifications, Trailhead badges to demonstrate Salesforce knowledge.
SQL : Able to write Queries, Joins, Procedures, Dynamic SQL.
Sound understanding of Data Model concepts, Security Models, able to map business processes to target system processes, understand and configure Duplicate/ Matching Rules, Record Types, Workflows, API Limits, Able to create custom report types, API's & Limits, Understanding of Data Sku's
Tool set: Data Loader, Dataloader.io, DB Amp, Pentaho, D&B Processes (both Online and Onsite) , DataMatch
Excel: Demonstrate advanced skills such as PivotTables, Vlookup, Flash Fill, Filters, Conditional Formatting, COUNTIF, Charts, SUMIF, IFERROR, Slicers, Power Pivots, Indirect functions etc.
Understand & Interpret Data load Errors and be able to translate those as being related to either configuration, deployment (CICD) , Integration or data issues, able to identify and drive corrections with BA's , Devs, TA's.
Identify Gaps in Business processes, data and help steer migration where required.
Be a team player and should be able to accommodate flexible working across different time zones, explain technical / functional data migration issues in a clear and concise way to stakeholders of all levels (inc non-technical SME's).
To be intuitive by nature, wanting to explore new concepts and create POC's