American Red Cross
Lead Data Warehousing Engineer
American Red Cross, Apex, North Carolina, United States, 27502
Overview
Lead Data Warehousing Engineer at American Red Cross. 100% virtual from a home office with occasional in-person meetings as necessary. Preference for candidates to work an East coast schedule for coordination with off-shore resources. This position requires the ability to work a rotational weekend support schedule once every 8 weeks. What You Need To Know About The Job
The Enterprise Data & Analytics Team is building out a team of well-rounded, full-stack Data Engineers to support mission-transforming work through data. We are hiring for a Lead Data Engineer to help modernize and transform our data and reporting capabilities across multiple verticals by implementing a new modernized data architecture and technical stack. You will help develop, test, maintain and support an enterprise data warehouse system and corresponding data; you will be responsible for database design and implementation of agreed-upon standards. This role requires an innovative engineer who is passionate about data, data quality & automation. The ideal candidate will have strong data warehousing experience and the ability to develop and deploy scalable data pipelines that make data management and analytics/reporting faster, more insightful, and more efficient. Responsibilities
Collaborate with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization. Build and implement scalable solutions that align to data governance standards and architectural roadmap for data integrations, data storage, reporting, and analytic solutions. Design, develop and test data integration solutions. Write, automate and document unit/integration/functional tests. Manage automated deployments using Git pipelines, ensuring code changes are efficiently version-controlled and deployed. Collaborate with multiple teams to streamline deployment workflows, monitor and troubleshoot pipelines for reliability and performance. Perform data analysis to troubleshoot data-related issues by building a data quality framework and assist in the resolution of data issues. Serve as technical lead by mentoring less experienced team members through code reviews, pair programming and hands-on guidance. Qualifications
Education: 4-year college degree or equivalent; preferred fields in Computer Science, Engineering, Mathematics, or related technical field. 10 years of relevant work experience in data engineering, business intelligence or related field. Experience with database technologies and data warehouse schema design patterns (Snowflake and star schemas). Experience with cloud-based databases, specifically AWS technologies (Redshift preferred, plus RDS, S3, EC2, EKS). Advanced SQL skills and ability to optimize queries in large-scale datasets. Proficient in object-oriented programming (Python required). Experience with DBT is preferred. Experience creating ETL and/or ELT jobs and working with Agile methodologies. Strong problem solving, documentation, and DevOps familiarity (Git, Artifactory, etc.). Experience integrating across multiple systems and APIs is a plus. Combination of education and experience that meets the minimum requirements; management experience cannot be substituted. Salary & Benefits
Pay Information: Annual salary range $140,000 - $150,000. No annual bonus for this role. Salaries align to geographic location; specific salary determined at phone screen based on location and experience. Benefits include medical, dental, vision; HSA/FSAs; PTO; holidays; 401(k) with up to 6% match; paid family leave; employee assistance; disability insurance; service awards and recognition. EEOC and Equal Opportunity Employer: All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law. Apply now. This job posting will remain open for a minimum of five business days and may be extended if the applicant pool requires. #J-18808-Ljbffr
Lead Data Warehousing Engineer at American Red Cross. 100% virtual from a home office with occasional in-person meetings as necessary. Preference for candidates to work an East coast schedule for coordination with off-shore resources. This position requires the ability to work a rotational weekend support schedule once every 8 weeks. What You Need To Know About The Job
The Enterprise Data & Analytics Team is building out a team of well-rounded, full-stack Data Engineers to support mission-transforming work through data. We are hiring for a Lead Data Engineer to help modernize and transform our data and reporting capabilities across multiple verticals by implementing a new modernized data architecture and technical stack. You will help develop, test, maintain and support an enterprise data warehouse system and corresponding data; you will be responsible for database design and implementation of agreed-upon standards. This role requires an innovative engineer who is passionate about data, data quality & automation. The ideal candidate will have strong data warehousing experience and the ability to develop and deploy scalable data pipelines that make data management and analytics/reporting faster, more insightful, and more efficient. Responsibilities
Collaborate with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization. Build and implement scalable solutions that align to data governance standards and architectural roadmap for data integrations, data storage, reporting, and analytic solutions. Design, develop and test data integration solutions. Write, automate and document unit/integration/functional tests. Manage automated deployments using Git pipelines, ensuring code changes are efficiently version-controlled and deployed. Collaborate with multiple teams to streamline deployment workflows, monitor and troubleshoot pipelines for reliability and performance. Perform data analysis to troubleshoot data-related issues by building a data quality framework and assist in the resolution of data issues. Serve as technical lead by mentoring less experienced team members through code reviews, pair programming and hands-on guidance. Qualifications
Education: 4-year college degree or equivalent; preferred fields in Computer Science, Engineering, Mathematics, or related technical field. 10 years of relevant work experience in data engineering, business intelligence or related field. Experience with database technologies and data warehouse schema design patterns (Snowflake and star schemas). Experience with cloud-based databases, specifically AWS technologies (Redshift preferred, plus RDS, S3, EC2, EKS). Advanced SQL skills and ability to optimize queries in large-scale datasets. Proficient in object-oriented programming (Python required). Experience with DBT is preferred. Experience creating ETL and/or ELT jobs and working with Agile methodologies. Strong problem solving, documentation, and DevOps familiarity (Git, Artifactory, etc.). Experience integrating across multiple systems and APIs is a plus. Combination of education and experience that meets the minimum requirements; management experience cannot be substituted. Salary & Benefits
Pay Information: Annual salary range $140,000 - $150,000. No annual bonus for this role. Salaries align to geographic location; specific salary determined at phone screen based on location and experience. Benefits include medical, dental, vision; HSA/FSAs; PTO; holidays; 401(k) with up to 6% match; paid family leave; employee assistance; disability insurance; service awards and recognition. EEOC and Equal Opportunity Employer: All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law. Apply now. This job posting will remain open for a minimum of five business days and may be extended if the applicant pool requires. #J-18808-Ljbffr