Senior Data Engineer
Provoke Solutions
An application made for this job — a tailored resume and cover letter that speak straight to the posting.
Job summary
Provoke Solutions in Long Beach, CA is seeking a Senior Data Engineer to set the technical bar for data movement, governance and integration patterns. You will mentor juniors and help shape the evolving data architecture for operational reporting and analytics.
You will design scalable ETL/ELT pipelines, implement CDC and data validation, and collaborate with stakeholders to translate requirements into robust data solutions.
Qualifications
- 5–8+ years of enterprise data engineering experience, incl. 5+ years designing ETL/ELT pipelines.
- Strong SQL and SQL Server skills; hands-on Python for data engineering.
- Hands-on experience with Dagster, Airflow, ADF, plus Azure DevOps, Git, Power BI.
- Experience with data integration and APIs, incl. CDC and performance optimization.
- Enterprise data modeling across Dimensional, Data Vault, semantic, MDM, and RDM.
- Proven ability to work independently without direct supervision.
- Experience mentoring or guiding less experienced engineers.
- Comfort operating in ambiguity; help define patterns.
- Strong communication across technical and business audiences.
Responsibilities
- Design, build, optimize, and maintain ETL/ELT pipelines that move data reliably across the environment.
- Develop integrations between Jack Henry Core, enterprise applications, and reporting platforms, establishing integration patterns where none currently exist.
- Implement Change Data Capture (CDC), data reconciliation, and automated data validation across source systems.
- Design and support enterprise data models, including dimensional, Data Vault (Hubs, Links, Satellites), semantic, master data (MDM), and reference data (RDM) models.
- Develop orchestration workflows and automated data pipelines, using tools such as Dagster, Airflow, or Azure Data Factory, and contribute to the emerging data governance layer.
- Mentor junior data engineers and share technical best practices across the team.
- Troubleshoot independently and bring creative solutions to problems that don't have an obvious playbook.
- Partner with technical and business stakeholders to translate requirements into working data solutions.
- Optimize database and query performance across enterprise data platforms.
- Incorporate data quality, metadata, lineage, governance, and auditability into engineering solutions.
Skills
Tools
Job description
Location: Onsite 3 days/week – Long Beach, CA
Provoke is a global consulting firm building AI-native solutions that transform how work gets done. Founded on a culture of innovation, growth, and curiosity, we partner with global clients to design and deploy agentic AI embedded directly into workflows so teams move faster, think smarter, and scale with purpose.
We're looking for a Senior Data Engineer to bring structure and technical direction to a data environment that's still taking shape. This is a senior individual contributor role, not a people‑management position. You'll set the technical bar for how data moves through the organization, mentor junior developers along the way, and help build the foundation for governance and integration patterns that don't fully exist yet.
You'll be joining at a good moment to leave a mark, setting the strategy for scalable integration patterns, reference data models, and governance framework, while helping modernize the platform behind operational reporting, analytics, and ClientIQ. You'll have real influence over how the pieces of our evolving data architecture and systems come together.
- Experience in consulting or professional services environments or similar client‑facing roles.
- Versatile people who thrive on variety and challenge.
- Excited about working in a fast‑paced environment.
- Innate problem solvers who want to grow in a flexible, collaborative culture.
- Takes initiative, pushes boundaries, motivated to innovate.
- Individuals with a growth mindset who want to use their learning and relationship‑building skills.
- Proactively using Gen AI and Agents within their development process to improve quality and speed.
- Design, build, optimize, and maintain ETL/ELT pipelines that move data reliably across the environment.
- Develop integrations between Jack Henry Core, enterprise applications, and reporting platforms, establishing integration patterns where none currently exist.
- Implement Change Data Capture (CDC), data reconciliation, and automated data validation across source systems.
- Design and support enterprise data models, including dimensional, Data Vault (Hubs, Links, Satellites), semantic, master data (MDM), and reference data (RDM) models.
- Develop orchestration workflows and automated data pipelines, using tools such as Dagster, Airflow, or Azure Data Factory, and contribute to the emerging data governance layer.
- Mentor junior data engineers and share technical best practices across the team.
- Troubleshoot independently and bring creative solutions to problems that don't have an obvious playbook.
- Partner with technical and business stakeholders to translate requirements into working data solutions.
- Optimize database and query performance across enterprise data platforms.
- Incorporate data quality, metadata, lineage, governance, and auditability into engineering solutions.
- 5‑8+ years of enterprise data engineering experience, including 5+ years designing ETL/ELT pipelines and data integration solutions.
- Strong SQL and SQL Server skills, with hands‑on Python experience for data engineering work.
- Hands‑on experience with workflow orchestration tools (Dagster preferred, Airflow, Azure Data Factory, or similar), along with Azure DevOps, Git, and Power BI.
- Experience with data integration and APIs, including CDC and performance optimization.
- Enterprise data modeling experience across dimensional, Data Vault, semantic, MDM, and RDM approaches.
- A track record of solving problems independently, without needing a manager to point the way.
- Experience mentoring or guiding less experienced engineers.
- Comfort operating in ambiguity: this environment doesn't have formal patterns yet, and you'll help write them.
- Strong communication skills, since you'll work across both technical and business audiences.
- Banking or financial services experience, particularly with Jack Henry or other core banking platforms.
- Enterprise data warehouse and Customer 360 solution experience.
- Data governance and regulatory reporting experience.
- Microsoft certifications such as Azure Data Engineer Associate (DP‑203) or Fabric Data Engineer Associate (DP‑700)
- Snowflake certifications such as SnowPro Core
- Experience with data governance or cataloging tools (DataHub, OpenMetadata, Collibra, Alation, or similar)
- Familiarity with additional orchestration tooling such as Prefect, beyond the core Dagster/Airflow/ADF stack
- Experience building or maintaining a data warehouse or data mart from the ground up
- Background establishing data quality checks, testing frameworks, or monitoring for production pipelines
- Prior work in an environment moving from on‑prem to cloud, so the candidate has lived through that kind of transition before
- Experience introducing integration patterns or reference data practices to a team that didn't have them yet
- Background in data mesh or domain‑oriented data ownership models
You're the person the team turns to when a data problem doesn't have a clear answer yet. You've helped move the organization from ad hoc pipelines toward a repeatable, governed way of working, and junior engineers are noticeably sharper for having worked alongside you.
US time zone alignment with PT. Flexibility to accommodate client schedules is part of the role.
US; Long Beach, CA area.
$65-90/hour
- This role is offered as W2 hourly employment
- Candidates must be authorized to work in the U.S. without VISA Sponsorship
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
