ETL Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, test, and maintain enterprise ETL/ELT solutions that integrate data from various source systems.

• Create scalable, high-performance data pipelines for both batch and near real-time data processing.

• Construct and sustain data integration workflows utilizing modern ETL tools and cloud-based data platforms.

• Analyze source systems and business requirements to establish data mapping, transformation, and validation rules.

• Enhance ETL performance, address data processing issues, and execute tuning strategies.

• Collaborate with data architects, database administrators, business analysts, and application teams.

• Develop and manage data warehouses, operational data stores, and reporting data marts.

• Implement data quality checks, reconciliation processes, and frameworks for exception handling.

• Generate and maintain technical documentation, design specifications, and operational runbooks.

• Assist with production deployments, incident resolution, and initiatives for continuous improvement.

• Ensure compliance with data governance, security, privacy, and organizational standards.

⛳️ Requirements

• U.S. Citizenship or Green Card is required, along with the capability to obtain a Public Trust clearance.

• A Bachelor’s degree in computer science, cybersecurity, engineering, or a related field; alternatively, four additional years of relevant experience may substitute for a degree.

• At least 6 years of practical experience in ETL development, data integration, and data warehousing.

• Extensive experience with ETL tools such as Informatica, SSIS, Talend, DataStage, AWS Glue, or comparable platforms.

• Proficiency in SQL and database technologies, including SQL Server, Oracle, PostgreSQL, or MySQL.

• Experience in designing complex data transformations, migrations, and integrations.

• Strong understanding of data warehousing concepts, dimensional modeling, and star/snowflake schemas.

• Familiarity with cloud-based data services and contemporary data platforms.

• Knowledge of best practices in data quality, data governance, and metadata management.

• Experience with performance tuning, error handling, and troubleshooting large-scale ETL processes.

• Excellent analytical, problem-solving, and communication skills.

• Ability to work efficiently in Agile development environments and collaborate across technical and business teams.

🏝️ Benefits

• Medical, Rx, Dental & Vision Insurance.

• Personal and Family Sick Time & Company Paid Holidays.

• Parental Leave.

• 401(k) Retirement Plan.

• Group Term Life and Travel Assistance.

• Voluntary Life and AD&D Insurance.

• Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts.

• Transit and Parking Commuter Benefits.

• Short-Term & Long-Term Disability.

• Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities.

• Employee Referral Program.

• Corporate Sponsored Events & Community Outreach.

• Care.com annual membership.

• Employee Assistance Program.

• Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance, and ID theft protection, etc.).

• Position may be eligible for a discretionary variable incentive bonus.

• Flexible benefits package.