Leverages proven Azure/AWS/Snowflake Cloud skills based around the design and development of multiple data pipelines going between legacy on premise and cloud environments. Data focus is on Marketing Analytics in relation to Customer Leads, Contacts & Campaigns. Uses coding skills to enable multiple sources to move data through Snowflake, MDM, RDS, and other cloud data environments using tools such as Spark, Striim, Kafka, Snowpipe, Azure Data factory, AWS Glue, Matillion, FiveTran and more.
KNOWLEDGE AND EXPERIENCE:
EDUCATION: Master's Degree in a technical, MIS or related business degree from an accredited institution of study; or any equivalent combination of education and relevant work experience.
EXPERIENCE: Minimum of 4 years of recent experience developing and implementing data warehouses, data systems or cloud-based solutions (IaaS, PaaS). Experience with message brokers such as Event Hubs or Kafka. Experience working on elastic and data intensive architecture. Experience with R, Python or Spark preferred. Experience with JSON and API calls preferred.
KNOWLEDGE & SKILLS: Experience with Data Warehousing technologies such as Snowflake, Azure SQL DW and Redshift. Experience with Big Data technologies including Data Lake, HDInsight, Hadoop, and blob storage preferred. Experience using SQL, T-SQL stored procedures, T-SQL functions; and/or an Oracle Environment using SQL Plus and PL/SQL Coding Languages. Familiarity with complex SQL Server scaling concepts (AlwaysOn, Geo-Scaling, Sharding, Large Scale DB Management). Familiarity with Kimball methodologies of data warehousing. Experience with legacy technologies such as SSIS and Tableau. Knowledge of Load and Performance test practices. Ability to handle multiple tasks, prioritize accordingly and make decisions as required. Must have excellent communication, interpersonal, and analytical skills with a strong customer service orientation. Be highly collaborative, team-oriented and a strong consensus builder.