Our client is a Full Service Marketing firm. This is a full-time role
What you'll do:
Take business requirements and produce data sets for efficient cross-business analysis
Execute architected techniques and solutions for data collection, ingestion, management, aggregation and usage
Extreme focus on detail and data quality validation
Deep interest in the data and analytics market with the ability to creative in solving data integration and delivery problems
Design, deploy and integrate process-specific data models feeding a wide range of reporting/insights/activation data sets.
Using tools like Alteryx, Tableau, DBT and platforms like Snowflake create innovative data solutions for media/marketing teams optimization processes
What we need (Position requirements):
Minimum 4-6 years of recent, progressive experience and demonstrable technical expertise in enterprise-class data analytics solutions and services. Including advanced skills in areas such as Data Modeling, Integration, Storage, Indexing, Security, Logging, Data Quality, Master Data Management, and Archiving.
Minimum 2 years of recent experience in enterprise-class data analytics architecture, including enterprise and solution architecture assessment/definition, and significant depth in two or more data analytics solution architecture components (i.e., data management, data integration, information delivery, and/or advanced analytics)
Experience designing logical and physical data models utilizing ERDs, data pipelines and workflow documentation
Proficiency in all aspects of SQL (complex joins and aggregations, stored procedures, functions, triggers) (5+ years).
Experience with architecture and applications on or incorporating cloud infrastructure-, platform-, and/or software as a service (particularly data analytic solutions on Amazon AWS, Microsoft Azure, or other cloud platforms and service providers)
Experience with Alteryx (Designer/Server) or similar, DBT, and cloud-based storage/databases/data-warehouses (Redshift, Snowflake, etc.)
What we look for:
Passion and dedication
Desire to be the best
Ability to work both independently and as part of a team
Strong interpersonal communication skills - written and verbal
Strong Quantitative Reasoning and Pattern Recognition ability
Proven track record of problem-solving
“Common sense” business approach (ability to balance real world with the theoretical.