Senior ETL Engineer
WorldStrides•Vienna, VA
•Hybrid
About The Position
The Senior ETL Engineer is responsible for the design, development, optimization, and long-term stewardship of enterprise data pipelines, data warehouse, and lakehouse solutions that support reporting, analytics, and advanced data use cases. This role goes beyond individual pipeline delivery, providing technical leadership, mentorship, and architectural collaboration across the data warehousing function. The Senior ETL Engineer partners closely with business stakeholders, data scientists, analysts, and BI teams to ensure data products are reliable, scalable, secure, and aligned with business strategy. This role plays a critical part in shaping data standards and ensuring the quality and integrity of enterprise reporting data. Key customers include data science, analytics, and marketing teams operating across marketing, operations, customer insights, and finance.
Requirements
- Advanced experience with SQL, relational databases, and data warehouse design
- Strong expertise with Microsoft Fabric and modern data platform concepts
- Proficiency in Python for ETL development, automation, and testing
- Deep understanding of data modeling, query optimization, and performance tuning
- Strong knowledge of DataOps, CI/CD, and automated testing for data platforms
- Experience designing and supporting production-grade, enterprise-scale pipelines
- Excellent verbal, written, and interpersonal communication skills
- Proven ability to lead multiple initiatives and influence without formal authority
- 5+ years of experience in data engineering, BI development, or analytics engineering
- Bachelor’s degree in a technical or analytical discipline required
Responsibilities
- Design, build, and maintain scalable, high-performance ETL/ELT pipelines supporting analytics, reporting, and advanced data use cases
- Define and enforce data engineering standards, best practices, and reusable patterns for pipeline development
- Lead data modeling efforts to ensure datasets are optimized for analytics, performance, and usability
- Evaluate and recommend improvements to existing data architectures, tools, and processes to support growth, scalability, and cost efficiency
- Leverage AI tools responsibly to improve ETL development productivity and quality, including accelerating pipeline development, test generation, documentation, anomaly detection, and operational troubleshooting
- Establish and enforce data quality, validation, fault-tolerance, and automated testing frameworks across all pipeline stages
- Ensure data integrity, accuracy, freshness, and lineage throughout the data lifecycle
- Lead DataOps and CI/CD practices for data pipeline deployment and management
- Drive automation to reduce manual processes in all stages of development
- Continuously optimize pipeline performance through query tuning, architectural improvements, and technology enhancements
- Identify and eliminate waste in data flows, reducing redundant processing and improving overall efficiency
- Evaluate, test, and adopt new tools, platforms, processes, and solutions aligned with modern data engineering best practices
- Serve as a technical lead for complex or high-impact data initiatives
- Mentor and coach ETL Engineers, and collaborate on data architecture evolution
- Share knowledge through documentation, design artifacts, and technical guidance
- Partner with business stakeholders to understand business requirements and translate into scalable data solutions
- Lead technical discussions to resolve ambiguous or competing data needs
- Communicate complex concepts clearly to technical and non-technical audiences
- Collaborate with data scientists, analysts, and BI engineers to adopt data products, and improve data usability and trust
- Act as a trusted advisor on data feasibility, trade-offs, risks, and prioritization
- Ensure data pipelines adhere to enterprise security, privacy, and governance standards
- Implement access controls, data protection measures, and compliance requirements
- Support data lineage, auditability, and metadata management initiatives
Benefits
- Excellent medical, dental, and vision coverage
- life, accidental death and dismemberment, accident, critical illness, and disability insurance
- FSA healthcare
- FSA dependent care
- HAS with employer contribution
- generous 401k match
- 10 paid floating corporate holidays
- 1 paid volunteer day
- 25 PTO days to start – accrue up to 28 over 3 years
- 4 mental health days
- 5 bereavement days
- Tuition reimbursement up to five thousand, two hundred fifty dollars annually
- one thousand dollars towards professional certification annually
- Opportunities for paid and discounted travel
- Flexible work schedule providing on-site, remote, and virtual office opportunities
- Encouraged participation in our Employee Resource Groups and Diversity, Equity, & Inclusion council
- Fitness Center and café onsite at select locations
- Employee Assistance Program (EAP)
- Paid Parental, Caregiver, and Disability leave
- Team Member Discount Program
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
