Note: The job is a remote job and is open to candidates in USA. The American Red Cross is the world's largest humanitarian network, and they are seeking a Lead Data Engineer to modernize and transform their data and reporting capabilities. This role involves developing and maintaining an enterprise data warehouse system, ensuring data quality, and mentoring junior engineers.
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 our 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 required to troubleshoot data-related issues by building a data quality framework and assist in the resolution of data issues
- Serve as tech lead by mentoring less experienced members of the team through code reviews, pair programming and similar hands-on interactions
Skills
- 4-year college degree in Computer Science, Engineering, Mathematics, or related technical field or equivalent combination of education and experience
- 10 years of relevant work experience in data engineering, business intelligence or related field
- A variety of database technologies and data warehouse schema design patterns
- Cloud-based databases, specifically AWS technologies
- Advanced experience using SQL queries as well as writing and optimizing SQL queries in a business environment with large-scale, complex datasets
- Python coding
- AI-assisted tools (e.g., GitHub Copilot, Duo) for code development, testing, and documentation across the SDLC
- Creating ETL and/or ELT jobs
- DevOps methodologies and tools (e.g., Git, Artifactory, etc.)
- Agile software development methodologies
- Leading data engineering teams in an onshore/offshore model, including mentoring junior engineers through code reviews, pair programming, and establishing team best practices
- Excellent problem solving and troubleshooting skills
- Process oriented with great documentation skills
- Passion, energy, and commitment to the humanitarian mission of the Red Cross
- Combination of candidate's education and general experience satisfies requirements so long as the total years equate to description's minimum education and general experience years combined (Management experience cannot be substituted)
- DBT
- Developing integrations across multiple systems and APIs
- Experience with an MDM platform such as Reltio, Profisee, or a comparable tool
- Redshift
- Snowflake and/ or Star
Benefits
- Medical, Dental, & Vision Plans
- Health Spending Accounts & Flexible Spending Accounts
- PTO + Holidays
- 401K with up to 6% Match
- Paid Family Leave
- Employee Assistance Programs
- Disability and Insurance: Short + Long Term
- Service Awards and Recognition
Company Overview