Looking for a resource who has data architecture experience, design data structures, creating structures that promote data quality, ER diagrams, referential integrity. Analytical skills example of work to have the resource pointed at a database or set of tables and do investigation on “how clean data is” and unpack any challenges with data sets. 50% analytics doing investigation designing / less than 50% on data engineering side, data architecture.
MUST HAVES:
- Salesforce Marketing Cloud experience and knows SF marking lingo: what audience generation, segmentation, and subscribers are
- Digital marketing focused
- Contacts, campaigns, accounts within Salesforce suite
- Strong Snowflake experience. That’s where data is going
- Data Architecture experience with ER diagrams, how data should be organized, analytical skills – pull out of marketing cloud.
- Data engineering in writing extracts, pushing to FTP server and grabbing and move to snowflake in a set of structures and other systems as well
- Python development for moving data from one system into snowflake
NICE TO HAVES:
- Work as part of a team and Agile.
- They use Rally for user stories
- AWS Data into snowflake – familiar with staging or stage with AWS bucket and S3 buckets. JDBC connection or CSV files and put into S3. Command lines and snowflake