etl engineer

WorldStrides

<div><div><h2 class="jobSectionHeader">Company Introduction</h2>

WorldStrides is the global leader in educational travel and experiential learning. The company was founded in 1967 to provide middle school travel programs to Washington, D.C. and has grown to provide a wide range of programs for more than half a million students annually to over 100 countries around the world. WorldStrides offers experiential learning programs in educational travel, performing arts, language immersion, career exploration, service-learning, study abroad, and sports. Each of these experiences helps students to see beyond the classroom and to see the world &ndash; and themselves &ndash; in new ways.</div>
Job Description: 
The ETL Engineer develops, deploys, and maintains data stores for access by business users including marketing campaign specialists and business data analysts. The ETL Engineer is responsible for supporting and maintaining the data warehouse environment including SQL databases, scheduled jobs, and Python-based ETL processes. The ETL Engineer will be responsible for creating and maintaining data pipelines to support reporting needs and will ensure the quality and integrity of reporting data. The role requires attention to detail and quality. Key customers for the ETL Engineer will include data scientists, analysts, and marketing campaign specialists working in the domains of marketing, operations, customer insights, and finance.

Responsibilities:
<ul>
<li>Manage the structuring and maintenance of data sets for production of reporting and analytics</li>
<li>Build and optimize data pipelines to facilitate the extraction of data from multiple sources and delivery to multiple applications and teams</li>
<li>Reduce waste and improve data flow. This involves continually striving to reduce wasted effort, identify gaps and correct them and improve data development and deployment processes.</li>
<li>Acquire and update data from internal and external data providers</li>
<li>Execute automated testing at every stage of a pipeline to increase productivity while reducing errors</li>
<li>Create queries that allow data to be extracted and to streamline the data retrieval process</li>
<li>Monitor processes to quickly identify and resolve or elevate issues, and identify areas for improvement</li>
<li>Use automation to streamline data processing, automate manual processes, such as data extraction and testing.</li>
<li>Adopt new solutions to produce data more efficiently and with fewer errors. This includes testing and adopting solutions and tools that adhere to the DataOps best practices.</li>
<li>Correspond with team members and customers to understand business concepts, data requirements, and prioritization of development tasks</li>
<li>Communicate, document, and collaborate with other data and BI team members to enhance the quality of data products.</li>
<li>Ensure data security standards are applied across the data pipelines.</li>
</ul>
Qualifications:
<ul>
<li>Experience in SQL, Excel, relational databases, database concepts, and database design.</li>
<li>2+ years' experience with Python</li>
<li>Strong interpersonal, oral and written communication and presentation skills</li>
<li>Ability to work on multiple projects simultaneously and to provide regular status updates proactively</li>
<li>3+ years' experience in BI development, data analysis, or data engineering</li>
<li>BS/BA degree (preferably in a technical or research field)</li></ul> 

<h3 class="jobSectionHeader">
Work Perks:</h3>
<ul><li>Fun &amp; driven environment.</li>
<li>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, and generous 401k match.</li>
<li>10 paid floating corporate holidays, 1 paid volunteer day &amp; 25 PTO days to start &ndash; accrue up to 28 over 3 years, 4 mental health days, and 5 bereavement days.</li>
<li>Tuition reimbursement up to five thousand, two hundred fifty dollars annually or one thousand dollars towards professional certification annually.</li>
<li>Opportunities for paid and discounted travel.</li>
<li>Flexible work schedule providing on-site, remote, and virtual office opportunities.</li>
<li>Encouraged participation in our Employee Resource Groups and Diversity, Equity, &amp; Inclusion council.</li>
<li>Fitness Center and caf&eacute; onsite at select locations.</li>
<li>Employee Assistance Program (EAP)</li>
<li>Paid Parental, Caregiver, and Disability leave.</li>
<li>Team Member Discount Program.</li></ul><div> 
<div>
<div>WorldStrides, a global organization, is committed to educate and serve communities worldwide. Our commitment is fueled by the passion of our team members and partners to make experiential learning accessible, while also being socially, environmentally, and ethically responsible. Together, we accomplish this by investing in initiatives to promote inclusion, diversity, and sustainability.

As an Equal Opportunity Employer, WorldStrides is committed to building a diverse workforce, supported by an environment that promotes inclusion and belonging. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

WorldStrides will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas such as E, F-1, J-1, H-1, H-2, L, B, J or TN, or who need sponsorship for work authorization now or in the future, are not eligible for hire. Select seasonal roles may consider students on J-1 or F-1 visas.</div></div></div></div>

ETL Engineer

Intellibee Inc

<div><div><div>Role summary: Design, build, and operate reliable archiving and purging solutions on Microsoft SQL Server for datasets stored/represented in EBCDIC format, using SQL Server stored procedures and Python automation. Own batch execution and scheduling via Control‑M, ensuring performance, auditability, retention compliance, and safe deletion practices.
Required Skills:
<ul><li>Build and maintain SQL Server stored procedures for data archiving, purge eligibility determination, and purge execution (soft/hard deletes as required).
</li>Handle EBCDIC data processing requirements (e.g., EBCDIC<li> ASCII/Unicode conversion, fixed-length records, packed decimals/COBOL-style encodings when applicable) and ensure data integrity post-conversion.
</li><li>Develop Python utilities for orchestration, validation, reconciliation, exception handling, and operational automation (e.g., pre/post checks, file-based extracts, run reports).
</li><li>Implement purge controls: retention rules, legal hold/exclusions, referential integrity management, dependency ordering, and rollback/restore strategy.
</li><li>Optimize performance for large volumes (partitioning strategies, indexing, batching, minimal logging approaches where appropriate, transaction scoping).
</li><li>Integrate and run jobs in Control‑M: job definitions, calendars, dependencies, resource limits, alerting, rerun/restart logic.
</li><li>Create operational runbooks, monitoring dashboards/metrics, and support production incidents (root cause, fixes, postmortems).
</li><li>Ensure security and compliance: least-privilege access, audit trails, PII handling, and evidence for retention/purge execution.
</li><li>Collaborate with DBAs, data governance, and application teams to validate retention policy interpretation and downstream impacts.
</li></ul>Required technical skills:<ul><li>
SQL Server: T‑SQL, stored procedures, transactions, error handling, temp tables, indexing, query tuning, SSMS, SQL Agent fundamentals (even if Control‑M is primary).</li><li>
EBCDIC: understanding of common code pages (e.g., 037/1047), conversion pitfalls, fixed-width layouts, and validation strategies.
</li><li>Python: building maintainable scripts/modules for ETL-style tasks, database connectivity (ODBC), logging, configuration, and testability.
</li><li>Batch scheduling: Control‑M job creation/execution, dependencies, alerts, reruns, and operational support.
</li><li>Data lifecycle: archiving patterns, retention, purge frameworks, auditability, and safe-delete patterns.
</li><li>Nice-to-have skills Experience with very large tables (VLDB), table partitioning/switching, and archival to cheaper storage tiers.
</li><li>Familiarity with mainframe-originated data models, COBOL copybooks, and packed numeric formats.
</li><li>CI/CD for database objects (DACPAC/SSD T or equivalent), Python packaging, and automated testing.
</li><li>Knowledge of data governance tools/processes and legal hold workflows.
</li><li>Experience in regulated environments (SOX, PCI, HIPAA, GDPR-like retention controls).</li></ul>
Benefits at IntelliBee<ul><li>
Long-Term Stability: Join us on a multi-year opportunities with room to grow.</li><li>
Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.</li><li>
Future Planning: Enroll in our 401(k) program and invest in your financial security.</li><li>
GC Assistance: We support immediate Green Card processing, if required.</li></ul></div></div></div>

ETL Data Engineer

BFG Enterprise Services

<div>Description:

Location: Remote (U.S. Only) 
Environment: Government-Furnished Equipment (GFE), HIPAA-Compliant 
Client: Department of Veterans Affairs (VA) &ndash; SPGP Program 
Type: Full-Time / Contract
Position Overview
BFG Enterprises is seeking an AWS Data Platform Engineer (Integration &amp; Operations) to support and stabilize a cloud-based data platform for the Staff Sergeant Parker Gordon Fox Suicide Prevention Grant Program (SPGP).
This role focuses on system reliability, data pipeline validation, environment management, and integration stability across AWS services and external systems. The engineer will work across development, operations, and data workflows to ensure the platform functions consistently and securely in a federal, HIPAA-compliant environment.
Requirements:

Key Responsibilities<ul><li>
Operate, monitor, and troubleshoot ETL pipelines running on AWS Lambda (Node.js)</li><li>
Validate data flows from external systems through ETL into Amazon DocumentDB</li><li>
Diagnose and resolve issues involving APIs, authentication (JWT), and data inconsistencies</li><li>
Manage deployments across DEV, PPD, and PROD environments</li><li>
Execute and verify safe code deployments from GitHub</li><li>
Monitor logs and system behavior using AWS CloudWatch</li><li>
Manage and update SSL/TLS certificates (DigiCert, Venafi)</li><li>
Ensure secure connectivity to databases and services</li><li>
Perform database queries and validation in DocumentDB (MongoDB-compatible)</li><li>
Support and improve CI/CD pipelines using GitHub Actions or similar tools</li><li>
Maintain documentation and standard operating procedures</li><li>
Participate in required meetings with VA, MITRE, and internal stakeholders</li></ul>
Required Qualifications<ul><li>
3+ years of experience in cloud engineering, data engineering, or platform engineering</li><li>
Strong experience with Node.js and JavaScript</li><li>
Hands-on experience with AWS Lambda</li><li>
Experience troubleshooting ETL or data processing workflows</li><li>
Experience working with REST APIs, including authentication (JWT, API keys, OAuth)</li><li>
Experience with MongoDB or Amazon DocumentDB</li><li>
Familiarity with GitHub (branching, commits, pull requests)</li><li>
Experience using logs for debugging (e.g., CloudWatch)</li><li>
Ability to work across multiple environments (DEV, staging, PROD)</li><li>
Strong problem-solving and troubleshooting skills</li><li>
Clear communication and documentation ability</li></ul>
Preferred Qualifications<ul><li>
Experience with GitHub Actions or CI/CD pipelines</li><li>
Experience with AWS EventBridge (scheduled jobs)</li><li>
Experience managing SSL/TLS certificates</li><li>
Familiarity with Docker or container-based systems</li><li>
Experience in federal, healthcare, or HIPAA-compliant environments</li><li>
Exposure to AWS GovCloud</li></ul>
Security and Compliance Requirements<ul><li>
Must be comfortable working on a GFE (Government-Furnished Equipment) laptop</li><li>
Must adhere to HIPAA and federal data security requirements</li><li>
Must follow strict access control, credential handling, and system usage policies</li></ul>
What Success Looks Like<ul><li>
ETL pipelines run reliably across all environments</li><li>
External API integrations are stable and monitored</li><li>
Deployments are controlled and do not introduce risk</li><li>
Data in DocumentDB is accurate and validated</li><li>
Issues are quickly identified and resolved</li><li>
Operational processes are documented and repeatable</li></ul>
How to Apply
Please submit a resume and a brief description of relevant experience with AWS, ETL, APIs, and Node.js.</div>

AWS Platform Engineer (Integration & Operations)

Arcadia

<div>
 
 
 
 ***This role is unable to provide sponsorship, a visa transfer, or work on a C2C basis. Candidates MUST be permanent residents of the United States****
 
 
 
 
 
 
 
 
 🚀 About the Role
 
 
 
 A fast-growing SaaS startup in the cloud financial management space is hiring a Data Engineer to own and scale the data infrastructure powering a platform built for large enterprises with complex cloud spending needs. This is a technically rich role for an engineer who loves wrangling massive volumes of semi-structured data, building bulletproof pipelines, and caring deeply about data quality end to end.
 
 
 
 
 
 You'll work across the full data stack, from pipeline architecture to schema design to quality control, in an environment where your work directly drives high-stakes financial decisions for enterprise customers.
 
 
 
 
 
 
 
 ***Candidates must currently be located in the San Francisco Bay Area. This role is hybrid (3 days in-office, 2 days remote) in the SF Financial District***
 
 
 
 
 
 
 
 
 
 ***This role is unable to provide sponsorship, a visa transfer, or work on a C2C basis. Candidates MUST be permanent residents of the United States***
 
 
 
 
 
 
 
 
 🛠 What You'll Do
 
 
 <ul>
 <li>
 Design efficient data storage and retrieval systems using ClickHouse, Parquet, and S3
 </li>
 <li>
 Build and maintain ETL pipelines processing hundreds of millions of rows of cloud billing data
 </li>
 <li>
 Develop robust data validation and quality control systems in Python and SQL
 </li>
 <li>
 Design and evolve data models for complex, constantly changing cloud billing schemas
 </li>
 <li>
 Build and optimize Airflow workflows for reliable, scalable data processing
 </li>
 <li>
 Collaborate with the engineering team to investigate and resolve data quality issues
 </li>
 <li>
 Scale data infrastructure as the platform expands to new cloud providers and use cases
 </li>
 </ul>
 
 
 
 
 
 ✅ What We're Looking For
 
 
 <ul>
 <li>
 3+ years of experience with data products: warehouses, lakehouses, OLAPs, ETL pipelines, or job queues
 </li>
 <li>
 Intermediate to strong Python skills with a software engineering foundation
 </li>
 <li>
 Strong SQL chops including CTEs, window functions, and query optimization
 </li>
 <li>
 Experience building data validation and quality control systems
 </li>
 <li>
 Comfort with columnar databases, Parquet, and cloud storage (S3)
 </li>
 <li>
 Startup experience and the ability to move fast in ambiguous, evolving environments
 </li>
 <li>
 A genuine fastidiousness about data quality, even when there's no answer key
 </li>
 </ul>
 
 
 
 
 
 ⭐ Bonus Points For
 
 
 <ul>
 <li>
 Hands-on experience with ClickHouse or other OLAP datastores
 </li>
 <li>
 Familiarity with cloud billing data or cost management tooling (AWS CUR, etc.)
 </li>
 <li>
 Experience with Airflow or similar workflow orchestration tools
 </li>
 <li>
 Backend engineering experience beyond data pipelines
 </li>
 </ul>
 
 
 
 
 
 💥 Why Apply?
 
 
 <ul>
 <li>
 End-to-end ownership of data products that directly impact enterprise customer outcomes
 </li>
 <li>
 Genuinely complex technical challenges at scale in a specialized, fast-growing domain
 </li>
 <li>
 Small, senior team where your contributions are visible and matter immediately
 </li>
 <li>
 Ground-floor opportunity at a well-backed startup with real revenue and strong domain expertise
 </li>
 </ul>
 
 
 
 
 
 
 ***This role is unable to provide sponsorship, a visa transfer, or work on a C2C basis. Candidates MUST be permanent residents of the United States***
 
 
 
 
 
</div>

Data Engineer

Relishiq

Job Description: Remote | Full-TimeAbout the Role Relish is building a knowledge graph to unify the structured and unstructured customer data that flows through our Data Assure and Invoice AI products. This data &mdash; spanning ERP transactions, invoices, purchase orders, vendor records, contracts, and procurement documents &mdash; will power a new generation of alerts, fraud/risk detection, and customer insights. We're looking for a Data Engineer to own the pipelines that make this possible.Key Responsibilities<ul><li>Build and maintain ETL/ELT pipelines that ingest structured data from ERP systems (SAP, Oracle, and similar enterprise platforms) and unstructured data (invoices, contracts, PDFs, and procurement documents) into a graph-ready format</li><li>Develop entity resolution and relationship mapping logic to populate and maintain the Relish knowledge graph</li><li>Partner with our NLP/ML engineer on extraction pipelines that transform raw document content into structured graph entities and relationships</li><li>Integrate with our existing Azure-based infrastructure, including Azure Functions and Microsoft Graph API touchpoints</li><li>Maintain pipeline orchestration, scheduling, and monitoring &mdash; ensuring data is fresh, clean, and trustworthy</li><li>Support the query and alerting layer that surfaces fraud signals, risk patterns, and customer insights from the graph</li><li>Contribute to ontology and schema decisions alongside the Knowledge Graph Engineer and domain experts in invoice/procurement data</li><li>Ensure data quality, lineage, and governance standards across all pipeline stages</li></ul>Our StackLayerTechnologiesLanguagePython (primary), TypeScript/JavaScriptCloudAzure (Azure Functions, event-driven services)Data pipelinesAirflow / Dagster (orchestration), custom ETLGraph DBNeo4j or Amazon Neptune (in evaluation)Unstructured processingLLM-based extraction, NER pipelines, PDF/document parsingEnterprise integrationsSAP, Oracle, ERP connectorsAPIsMicrosoft Graph API, HubSpot API, RESTAI/ML layerAnthropic API (Claude), agentic workflowsContainersDocker, containerized deploymentsWhat We're Looking ForMust-have<ul><li>3&ndash;6 years of data engineering experience with a strong Python foundation</li><li>Proven experience building pipelines for both structured (relational, ERP) and unstructured (documents, PDFs, emails) data</li><li>Familiarity with graph databases (Neo4j, Neptune, or similar) and graph query languages (Cypher or Gremlin)</li><li>Experience with cloud-native data infrastructure, ideally on Azure</li><li>Solid understanding of entity resolution, deduplication, and data quality practices</li><li>Ability to work in a fast-moving, resource-conscious R&amp;D environment</li></ul>Strong plus<ul><li>Prior exposure to invoice, procurement, or ERP data domains</li><li>Experience with NLP pipelines (NER, relation extraction, LLM-based structured output)</li><li>Familiarity with LLM APIs (Anthropic, OpenAI) for data extraction workflows</li><li>Knowledge of ontology design or semantic data modeling (RDF, OWL)</li></ul>Key Certifications Worth HavingCredentialWhy It Matters at RelishNeo4j Certified ProfessionalDirect alignment with our graph DB pathMicrosoft Azure Data Engineer Associate (DP-203)Matches our Azure infrastructureDatabricks Certified AssociateUseful if pipeline scale growsdbt Analytics Engineering CertStrong signal on data transformation practicesCS/Data Engineering MSValued but not requiredWhy Relish You'd be joining a ~$15M ARR enterprise SaaS company at a meaningful inflection point &mdash; the knowledge graph initiative is core R&amp;D that will directly shape the next generation of Data Assure and Invoice AI. You'll have real ownership, work across the full data stack, and see your work surface directly in customer-facing fraud and risk products.Pay: $160,000.00 - $180,000.00 per yearBenefits:<ul><li>401(k)</li><li>401(k) matching</li><li>Dental insurance</li><li>Health insurance</li><li>Life insurance</li><li>Referral program</li><li>Retirement plan</li><li>Vision insurance</li></ul>Work Location: Remote

Smarty

<div>We are looking for a skilled Data Engineer to join our Business Intelligence team at Smarty, a growing SaaS company. In this role, you will be responsible for designing, building, and maintaining the data infrastructure that powers our analytics and reporting capabilities. You will work closely with data analysts and business stakeholders to ensure that clean, reliable, and well-structured data is always available when and where it's needed. 
This is an onsite, non-remote position in Orem, UT.<h2 class="jobSectionHeader">
What You'll Do</h2><ul><li>
Design, build, and maintain scalable data pipelines and ELT workflows using open-source/self-hosted Airbyte and custom Python</li><li>
Develop and maintain dbt models, tests, and documentation to transform raw source data into reliable fact and dimension tables</li><li>
Manage and optimize our AWS data lakehouse architecture, including S3 storage, Glue data catalog, and Athena query layer</li><li>
Orchestrate automated data workflows using AWS Step Functions and EventBridge schedules</li><li>
Deploy and manage Lambda functions for near-real-time pipelines, reverse ETL, and Slack-based data delivery</li><li>
Manage infrastructure as code using AWS CloudFormation for Lambdas, Step Functions, and Glue resources</li><li>
Maintain and administer Airbyte for data ingestion across sources such as HubSpot, MySQL databases, Google Analytics, and others</li><li>
Write and maintain bespoke Python pipelines for sources and use cases not well-served by off-the-shelf connectors</li><li>
Monitor pipeline health via AWS CloudWatch, respond to failures, and maintain data quality through dbt testing</li><li>
Manage AWS services including ECS/ECR (containerized pipeline execution), Secrets Manager, SNS, and IAM</li><li>
Collaborate with data analysts to support Power BI reporting, including scheduled semantic model refreshes</li><li>
Document data architecture, pipelines, and operational runbooks to support team knowledge and continuity</li></ul><h2 class="jobSectionHeader">
Who You Are</h2><ul><li>
3+ years of experience in a Data Engineering or similar role</li><li>
Strong hands-on experience with dbt (data build tool) &mdash; modeling, incremental strategies, testing, and documentation</li><li>
Proficiency in Python for data pipeline development and automation</li><li>
Strong working knowledge of AWS data services, including:</li><li><div><ul><li>
Amazon S3 &mdash; storage management, partitioning, lifecycle</li><li>
Amazon Athena &mdash; query optimization, DDL management</li><li>
AWS Glue &mdash; data catalog, crawlers, DDL management</li><li>
AWS Lambda &mdash; event-driven processing and automation</li><li>
AWS Step Functions &amp; EventBridge &mdash; pipeline orchestration and scheduling</li><li>
AWS ECS/ECR &mdash; running containerized workloads</li><li>
AWS CloudFormation &mdash; infrastructure as code</li><li>
AWS CloudWatch &mdash; logging and monitoring</li><li>
AWS IAM &amp; Secrets Manager &mdash; permissions and credential management</li></ul></div></li><li>
Experience managing an Airbyte (or similar ELT tool such as Fivetran) deployment and its source connections</li><li>
Solid SQL skills and comfort with data modeling concepts (staging, intermediate, fact/dimension layers)</li><li>
Familiarity with MySQL or similar relational databases as data sources</li><li>
Experience with version control (Git/Bitbucket or similar) and code review workflows</li><li>
Strong problem-solving skills and a proactive approach to pipeline monitoring and data quality</li><li>
Nice to have:</li><li><div><ul><li>
Experience integrating with SaaS APIs such as Salesforce, HubSpot, Google Analytics, or Help Scout</li><li>
Familiarity with Power BI or other BI tools (Tableau, Looker, etc.)</li><li>
Experience with reverse ETL patterns (pushing transformed data back to source systems)</li><li>
Experience working in a SaaS company environment or with product usage/billing data</li><li>
Familiarity with Apache Iceberg or similar table formats (VACUUM/OPTIMIZE operations)</li><li>
AWS certifications (e.g., AWS Certified Data Engineer, Solutions Architect)</li></ul></div></li></ul> 
Benefits and Perks<ul><li>
Competitive compensation (DOE)</li><li>
100% paid health, dental, and basic life insurance premiums (including family coverage)</li><li>
Long-term disability insurance</li><li>
Generous PTO that increases with tenure</li><li>
401(k) with company matching</li><li>
Ongoing training and professional development</li><li>
Adjustable standing desk and modern tools</li><li>
Drinks, snacks, team lunches, and activities</li><li>
In-office chiropractic services</li><li>
Company retreats and trips to genuinely fun places</li></ul> 
To apply:
Sounds too good to be true? Apply and find out for yourself.<ul><li>
For more information about the company, please visit us at www.smarty.com.</li></ul> 
We are an Equal Opportunity Employer and we require all candidates (that receive and accept employment offers) to complete a background check. 
About Smarty 
Since its founding in 2011, Smarty has become a recognized industry leader in address data intelligence (exciting, we know). We provide enterprise-grade SaaS solutions worldwide for address validation, geocoding, and data enrichment. 
Our culture is all about creating, building, helping, and collaborating with energy and excitement. We want to enjoy our time together by being outward toward others, making appropriate efforts to master our respective crafts, and doing lots of fun things together.</div>

Penguin Random House

<div><div><div><div><div>We are seeking a Senior API &amp; Data Engineer to own and evolve the critical data flows that power our Metadata API ecosystem. This role sits at the intersection of database architecture, ETL orchestration, and API design, with a focus on modernizing legacy systems while building the next generation of scalable, reliable services. 
In this role, you will work across multiple databases (Oracle, PostgreSQL, and MySQL), maintain and enhance a legacy Java-based API, and help shape the evolution of our next-generation Python-based Metadata API platform. 
The Metadata API platform is foundational to our publishing ecosystem. This role directly impacts how authoritative data is modeled, propagated, and exposed to external customers as well as our own in-house consumers. The engineer in this position will influence both the stability of current systems and the architectural direction of future platforms. 
This is a senior-level position requiring strong technical judgment, architectural thinking, and the ability to assess downstream data impacts across systems. The role reports to the Senior Director of the API, Middle Tier &amp; Mobile team within the Publishing Applications Group. 
Specific responsibilities include:
<ul><li>Own and evolve data flows powering the Metadata API ecosystem, ensuring accuracy, scalability, and reliability across systems
</li><li>Design and optimize relational database schemas, queries, and stored procedures across Oracle, PostgreSQL, and MySQL
</li><li>Maintain and enhance legacy Java-based APIs while contributing to the development of modern Python-based API services
</li><li>Orchestrate ETL processes and manage the safe propagation of schema and data changes across upstream and downstream systems
</li>Troubleshoot data and API issues while partnering cross-functionally on platform architecture, API design, and system improvements 
<li>
</li></ul>Please apply if you meet the following qualifications:
<ul><li>5+ years of backend or data engineering experience with strong SQL expertise across relational databases (Oracle, PostgreSQL, MySQL)
</li><li>Experience designing &ldquo;source of truth&rdquo; data models and managing ETL pipelines or data propagation workflows
</li><li>Proficiency in Java and Python for API development (JAX-RS and FastAPI a plus) and a solid understanding of RESTful design principles
</li><li>Experience working in cloud-based, containerized environments (e.g., AWS, Kubernetes) with familiarity in CI/CD and version control
</li>Strong problem-solving, communication, and collaboration skills, with the ability to assess downstream data impacts across systems 
<li>
</li></ul>The Penguin Random House national headquarters is located in New York City. The position is open to remote candidates based in the United States. 
The salary range for this position is $120,000 - $130,000. All positions are currently eligible for annual profit award or bonus, subject to Company results. 
Applications for this role will be accepted through April 21 or until the role is filled. We encourage you to apply early, as we review applications on a rolling basis. Please include your resume and cover letter for consideration. Before applying for any role at Penguin Random House, we recommend you review our applicant resources page and our FAQs page. 
</div></div></div></div><div><div><div><div>Penguin Random House job postings include a good faith compensation range for each open position. The salary range listed is specific to each particular open position and takes into account various factors including the specifics of the individual role, and candidate's relevant experience and qualifications. 
 
Full-time employees are eligible for our comprehensive benefits program. Our range of benefits include, but are not limited to, Medical/Prescription drug insurance, Dental, Vision, Health Care/Dependent Care Flexible Spending Account, Health Savings Account, Pre-Tax and Roth 401(k), Short and Long-Term Disability Insurance, Life/AD&amp;D Insurance, Commuter Benefits, Student Loan Repayment Program, Educational Assistance &amp; generous paid time off. 
 
Penguin Random House is the leading adult and children's publishing house in North America, the United Kingdom and many other regions around the world. In publishing the best books in every genre and subject for all ages, we are committed to quality, excellence in execution, and innovation throughout the entire publishing process: editorial, design, marketing, publicity, sales, production, and distribution. Our vibrant and diverse international community of nearly 300 publishing brands and imprints include Ballantine Bantam Dell, Berkley, Clarkson Potter, Crown, DK, Doubleday, Dutton, Grosset &amp; Dunlap, Little Golden Books, Knopf, Modern Library, Pantheon, Penguin Books, Penguin Press, Penguin Random House Audio, Penguin Young Readers, Portfolio, Puffin, Putnam, Random House, Random House Children's Books, Riverhead, Ten Speed Press, Viking, and Vintage, among others. More information can be found at http://www.penguinrandomhouse.com/.
 
 
Penguin Random House values the array of talents and perspectives that a diverse workforce brings. All qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status. 
Company: Penguin Random House LLC | Job ID: 287985</div></div></div></div></div>

Senior Engineer, API and Data (Open to Remote)

Search 5257+ Etl engineer jobs near you this April. New roles added regularly across leading industries. Apply today.

5257 etl engineer jobs Near Me

ETL Engineer

ETL Data Engineer

AWS Platform Engineer (Integration & Operations)

Data Engineer

Data Engineer

Data Engineer

Senior Engineer, API and Data (Open to Remote)