Consultant, Data Engineer

Software Engineer needed to design, develop, test, and implement scalable ETL/ELT data integration pipelines to acquire and centralize diverse, high-volume datasets from multiple source systems into cloud data warehouses and data marts. Leverage Snowflake and AWS to store, process, and optimize large-scale analytical computations and complex data assets. Perform logical and physical dimensional data modeling, data profiling, and data quality analysis to architect target database schemas (Star and Snowflake schemas) and define optimal data load strategies. Develop custom automated workflows, system alerts, and scripting solutions; architect and implement CI/CD pipelines utilizing enterprise automation software and orchestration frameworks. Conduct POCs on emerging data tools, frameworks, and cloud technologies to assess feasibility and drive platform modernization. Master's degree in Computer Science and 3 years of experience performing the duties listed above.

Responsibilities

Design, develop, test, and implement scalable ETL/ELT data integration pipelines to acquire and centralize diverse, high-volume datasets from multiple source systems into cloud data warehouses and data marts; Leverage Snowflake and AWS to store, process, and optimize large-scale analytical computations and complex data assets; Perform logical and physical dimensional data modeling, data profiling, and data quality analysis to architect target database schemas (Star and Snowflake schemas) and define optimal data load strategies; Develop custom automated workflows, system alerts, and scripting solutions; Architect and implement CI/CD pipelines utilizing enterprise automation software and orchestration frameworks; Conduct POCs on emerging data tools, frameworks, and cloud technologies to assess feasibility and drive platform modernization

Requirements

Master's degree in Computer Science; 3 years of experience performing the duties listed above

Benefits

Medical/dental/vision; life insurance; short and long term disability coverage; paid time off (minimum of 18 days for newly hired associates, pro-rated quarterly based on hire date); nine paid holidays; 8 hours of Lifetime paid time off; 8 hours of Unity Day paid time off; 401(k) with company match; company-paid pension plan; business casual attire