Data & Integration Ops Engineer

Position Summary

The Data & Integration Ops Engineer is an experienced data engineering professional responsible for the stable secure and efficient operation of Focuss data platforms and integration pipelines. This role bridges data engineering and operations - applying DataOps and DevOps best practices to own SLAs monitor systems proactively and resolve issues before they impact the business. Youll work closely with data engineers analytics engineers and platform teams to ensure data is delivered accurately and on time. The ideal candidate is a data engineering expert with a passion for operational excellence a keen eye for detail and the ability to troubleshoot complex systems in real-time.

This is a hybrid role with 3 days/week onsite in St. Louis.

Primary Responsibilities

• Data Pipeline Operations & Reliability: Oversee the end-to-end operation of data pipelines (ELT workflows) across development UAT and production environments. Monitor pipeline schedules (e.g. Airflow DAGs) and ensure on-time data delivery to meet or exceed defined SLAs for data availability and quality.

• Integration Pipeline Operations: Monitor and troubleshoot integration workflows across Azure Integration Services (Logic Apps Event Hub AKS-based transformation jobs) that move data between source systems (e.g. Salesforce FSC) and downstream targets. Diagnose failures in integration code and coordinate with Infrastructure/Cloud Engineering and Cyber teams when issues trace back to underlying Azure infrastructure.

• Incident Response & Recovery: Act as the primary point of contact for data platform incidents during business hours diagnosing issues in real-time and coordinating rapid recovery efforts. Lead root cause analysis and implement preventive measures to minimize future disruptions.

• Operational Governance & Compliance: Serve as a steward of the data platform managing production data access and governance. Administer Snowflake RBAC and access policies and audit write-access permissions to production datasets and systems to ensure data integrity security and compliance with internal policies and industry regulations.

• Deployment Support & Release Management: Collaborate with data engineers and analytics engineers to facilitate deployments of new data models transformations (e.g. dbt models) and pipeline code. Conduct code reviews and enforce deployment gates to ensure that only well-tested high-quality code moves into production. Work with DevOps and platform teams to refine continuous integration/continuous deployment (CI/CD) processes for data pipelines using GitHub Actions and GitHub-native deployment workflows.

• Troubleshooting & Performance Optimization: Identify and troubleshoot pipeline failures or data quality issues including root cause diagnosis of failed dbt transformations or upstream data problems. Optimize pipeline performance (e.g. query tuning resource scaling) across both data pipelines and integration workflows to improve throughput and reduce latency ensuring robust performance of the data platform.

• Platform Monitoring & Improvement: Implement monitoring logging and alerting for data workflows and platforms using these tools to proactively detect anomalies. Analyze performance metrics and incident patterns to drive continuous improvements such as enhancing resiliency refining SLAs and updating processes to prevent recurring issues.

• Cross-Team Collaboration: Work closely with Data Engineering Analytics Infrastructure/Cloud Engineering Cyber and IT Ops teams to prioritize and address production data issues. Provide guidance and mentorship on operational best practices to other data team members fostering a culture of reliability and quality.

Required Skills

• Data Pipeline & Orchestration: Strong hands-on experience with data workflow management systems (especially Apache Airflow/Astro for DAG orchestration) and familiarity with scheduling monitoring and maintaining complex DAGs in production.

• Data Transformation & Tools: Proficiency with SQL and data transformation frameworks like dbt (Data Build Tool) for building and troubleshooting data models. Capability to debug SQL queries and pipeline scripts to resolve data quality or performance issues in a timely manner.

• Programming & Scripting: Advanced programming skills in Python (or similar languages) for writing data pipeline jobs and automation scripts. Experience with version control (e.g. Git) and understanding of CI/CD tools/processes for deploying data pipelines and platform changes.

• Monitoring & Incident Response: Experience implementing monitoring and alerting systems (using tools such as logging frameworks observability dashboards) to track SLAs runtime metrics and quickly detect pipeline failures. Skilled in systematic troubleshooting and root cause analysis for complex systems under pressure.

• Data Platforms & Cloud: Solid understanding of Snowflake (RBAC secure views dynamic tables resource monitors) and Astro/Airflow including their operational aspects (performance tuning security monitoring). Strong working knowledge of Azure services relevant to data and integration pipelines (networking basics APIM Event Hub AKS Logic Apps).

• Scope Boundary: This role troubleshoots integration and pipeline code within these environments but does not own infrastructure-as-code or infrastructure deployments which are managed by the Infrastructure/Cloud Engineering team.

• Communication & Collaboration: Excellent problem-solving abilities with strong communication skills to coordinate across engineering analytics and operations teams. Demonstrated ability to document processes produce runbooks and clearly communicate during incident management.

Qualifications

• Education: Bachelors degree in Computer Science Software Engineering or a related technical field or equivalent hands-on experience. Formal degree requirements are secondary to a demonstrated track record of operating production data systems.

• Experience: Typically 5 years of professional experience in data engineering data operations (DataOps) or a related field including substantial experience managing production data pipelines and platforms. Experience applying DevOps DataOps or SRE practices to production data systems is highly desirable. Experience with cloud integration platforms (e.g. Azure Integration Services MuleSoft Boomi) is a plus.

• Expertise: Proven track record of operational excellence in a data-focused environment e.g. owning and improving SLAs handling production incidents and implementing robust automation. Familiarity with industry best practices in DataOps/Data Engineering and data governance standards.

• Industry: Experience in financial services wealth management or other regulated industries is a plus.

• Working Style: Demonstrated ability to work independently manage priorities and take ownership of data products from design through ongoing support.

This position is an exempt position. The annualized base pay range for this role is expected to be between $110000 - $130000. Actual base pay could vary based on factors including but not limited to experience subject matter expertise geographic location where work will be performed and the applicants skill set. The base pay is just one component of the total compensation package for employees. Other reward may include an annual cash bonus and a comprehensive benefits package.

#LI-KJ2

About Focus Financial Partners

Focus is a leading financial services firm comprised of integrated wealth management family office and business management services. Blending deep expertise and expansive resources with a boutique client-first fiduciary philosophy Focus helps individuals families and institutions navigate complex financial situations with highly personalized solutions tailored to their unique needs. To learn more about Focus visit follow the company onLinkedIn.

Focus is an equal opportunity employer and bases its employment decisions on the employee or candidates skillset and without regard to an employee or candidates race color religion sex (including pregnancy) gender identity sexual orientation national origin age disability genetic information veteran status or any other characteristic protected by local state and/or federal law.

Focus complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process to perform essential job functions and/or to receive other benefits and privileges of employment please contact .

The following language is for US based roles only

For California Applicants:Information on your California privacy rights can be found here

For Indiana Applicants: It is unlawful for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States a member of the Indiana National Guard or a member of a reserve component.

For Maryland Applicants: I UNDERSTAND THAT UNDER MARYLAND LAW AN EMPLOYER MAY NOT REQUIRE OR DEMAND AS A CONDITION OF EMPLOYMENT PROSPECTIVE EMPLOYMENT OR CONTINUED EMPLOYMENT THAT ANY INDIVIDUAL SUBMIT TO OR TAKE A POLYGRAP OR SIMILAR TEST. AN EMPLOYER WHO VIOLATES THIS LAW IS GUILTY OF A MISDEMEANOR AND SUBJECT TO A FINE NOT EXCEEDING $100.

For Massachusetts Applicants: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this shall be subject to criminal penalties and civil liability.

For Montana Applicants: If hired the employment relationship is governed by the Wrongful Discharge from Employment Act. Mont. Code Ann. Section.

For Rhode Island Applicants: Focus is subject to Chapters 29-38 of Title 28 of the General Laws of Rhode Island and is therefore covered by the states workers compensation law. If you willfully provide false information about your ability to perform the essential functions of the job with or without reasonable accommodations you may be barred from filing a claim under the provisions of the Workers Compensation Act of the State of Rhode Island if the false information is directly related to the personal injury that is the basis for the new claim for compensation. The Company complies fully with the Americans with Disabilities Act.