Senior Data Engineer
Red Ventures
Charlotte, NC
Full-time
Engineering
Posted on July 5, 2020
SENIOR DATA ENGINEER sought by Red Ventures for its MAC-business division at its U.S. headquarters in Ft. Mill, SC to perform data warehousing & business intelligence (DW/BI) w/ Microsoft BI Tool stack & dimensional modelling. Job duties incl: modelling data warehouse structure based on Kimball methodology (Star, Snowflake & Hybrid Schemas), dsgng, building, testing, deploying & supporting ETL & reporting solutions for very large data sets. 4 yrs of exp in the job offered is reqd & must incl: 4 yrs of writing complex T-SQL queries & stored procedures using SQL server; min. 4 yrs of data warehouse architecture exp to dsgn various aspects of dimensional modelling incl Star, Snowflake & Hybrid Schema, dsgn considerations for fact & dimension tables (SCD, Surrogate Key, additive/non-additive fact etc.) ; 4 yrs of ETL dvlpmt using SSIS along w/ standard auditing & logging frameworks; min 2 yrs of SSAS cube dvlpmt w/ tabular model; 2 yrs of exp in reporting tools like SSRS/Power BI/ Tableau; & 3 yrs of SQL query optimization & performance tuning exp using Perfmon, DMV, Clustered/ Non-Clustered/Column store indexes. Employer will accept & suitable combo of edu, training & exp. Submit resumes & salary history to: Red Ventures, 1101 Red Ventures Dr, Ft. Mill, SC 29707, Attn: HR, Req. #1102.