Senior Data Architect

A Senior Data Architect at Red Ventures has the end-to-end vision of conceptual, physical, and logical storage of data and how analysts, applications, and data scientists consume it.  We’ll look to you to recognize and identify patterns in data relationships from disparate systems and create data management solutions. You will design and build scalable infrastructure platforms to collect and process large amounts of structured and unstructured data that will be consumed in near real-time.

Responsibilities

On a day-to-day basis, you will work on a team responsible for all aspects of Red Ventures’ data including timeliness, accuracy, consumption, and security. You will work on automating data pipelines, creating data models, and monitoring and ensuring performance. You will communicate with business analysts, data scientists, and business leaders to understand and meet their data needs. You will be tasked with identifying and executing on best practices. You will work on a team with a focus on continuous learning and will have an opportunity to provide mentor and guidance. You will work on designing and implementing Red Ventures’ next generation data solution.


Preferred Background

Experience in application development, ETL development, report development and/or other data warehouse projects to bring a well-rounded perspective of the big picture 
Thorough understanding of dimensional modeling and data warehouse
Experience with Query, Database, Cube tuning
Knowledge of Big Data technologies
A sense of humor, thirst for knowledge, and a commitment to continuous improvement


Technology stack:

Microsoft BI Stack: Sql Server 2014 and 2016, SSIS, SSAS (cubes and tabular), Power BI, SSRS
Scala and Spark
Big Data: Hadoop, Hive, Kafka, NoSQL, event streams
MySQL
Both on-premise and in the cloud


About Red Ventures:

Red Ventures is a leading digital consumer choice platform based in Charlotte, North Carolina. Through deeply integrated brand partnerships and consumer-facing assets, Red Ventures connects online customers with products and services across high-growth industries including home services, financial services, and healthcare. Founded in 2000, Red Ventures has more than 2,700 employees in offices across the Carolinas, Seattle, Washington, and Sao Paulo, Brazil.