The American Red Cross's Enterprise Data & Analytics Team is modernizing and transforming its data and reporting capabilities across multiple verticals by implementing a new modernized data architecture and technical stack. The Lead Data Engineer will help develop, test, maintain, and support an enterprise data warehouse system and corresponding data, and will be responsible for database design and implementation of agreed-upon standards.
Requirements
- Experience with a variety of database technologies and data warehouse schema design patterns (snowflake and star in particular).
- Experience with cloud-based databases, specifically AWS technologies (e.g., Redshift (preferred), RDS, S3, EC2, EKS, Zero ETL)
- Advanced experience using SQL queries as well as writing and optimizing SQL queries in a business environment with large-scale, complex datasets.
- Proficient in object-oriented programming (Coding experience in Python is a required).
- Experience with DBT is preferred.
- Experience creating ETL and/or ELT jobs.
- Experience with DevOps methodologies and tools (e.g., Git, Artifactory, etc.).
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.
Other
- The work location is 100% virtual from a home office with occasional in-person meetings as necessary.
- Preference for candidate to work an East coast schedule for coordination with off-shore resources.
- This position also requires the ability to work a rotational weekend support schedule once every 8 weeks.
- Qualified candidates must be authorized to work in the United States. The American Red Cross does not sponsor employment visas.
- Excellent problem solving and troubleshooting skills.
