The Role
Position Summary
The Junior Data Engineer will play a key role in developing and maintaining robust data pipelines, ensuring data integrity, and supporting the firm's data infrastructure. This position is ideal for candidates with at least two years of hands-on experience in SQL and Python, coupled with a solid foundation in data engineering principles. The ideal candidate is a proactive learner, passionate about working with modern data technologies, and eager to contribute to the development of efficient, scalable data workflows.
This role is based in St. Louis, MO.
Primary Responsibilities
- Develop and optimize ELT pipelines under the guidance of senior engineers to ensure efficient data processing.
- Write and refine SQL queries for data transformation, processing, and performance optimization.
- Contribute to data model design to support scalable analytics and reporting solutions.
- Monitor, troubleshoot, and enhance data pipelines to maintain reliability, accuracy, and efficiency.
- Collaborate with data analysts and engineers to understand business needs and implement effective data solutions.
- Support data governance initiatives, including metadata management and data quality assurance.
- Document data workflows, system architecture, and transformation logic to enhance transparency and maintainability.
- Stay ahead of industry best practices in data engineering, automation, and cloud-based data platforms, continuously improving skills and processes.
Qualifications
- 2+ years of experience in data engineering, analytics, or software development.
- Proficiency in SQL and Python for data processing and transformation.
- Familiarity with cloud-based data platforms such as Snowflake, AWS, or GCP.
- Understanding of ELT/ETL concepts and data modeling principles.
- Exposure to modern data tools such as Airflow, dbt, or Spark is a plus.
- Strong problem-solving skills and attention to detail.
- Ability to work independently while being open to mentorship and learning.
About Focus Financial Partners
Focus is a leading partnership of fiduciary wealth management and related financial services firms. Focus provides access to best practices, greater resources, and continuity planning for its affiliated advisory firms, which serve individuals, families, employers, and institutions with comprehensive financial services. Focus firms and their clients benefit from the solutions, synergies, scale, economics, and best practices offered by Focus to achieve their business objectives. For more information about Focus, please visit www.focusfinancialpartners.com.
The annualized base pay range for this role is expected to be $55,000 - $65,000. 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 applicant's skill set. The base pay is just one component of the total compensation package for employees. Other rewards may include an annual cash bonus and a comprehensive benefits package.
Focus Financial Partners Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Focus Financial Partners and has not been reviewed or approved by Focus Financial Partners.
-
Fair & Transparent Compensation — Pay is presented with clear salary bands in multiple public job postings across roles and locations, aligning with typical ranges for similar industry titles. Role-level transparency spans client service, trading, and corporate/transaction positions.
-
Affordable Benefits — Health insurance is characterized as affordable alongside favorable commentary on the overall package. Core coverage includes medical, dental, vision, life insurance, and a 401(k) noted in corporate postings.
-
Wellbeing & Lifestyle Benefits — Broader total rewards include paid volunteer time, an in-house headquarters gym, wellness amenities such as lactation rooms and healthy snacks, and tuition assistance/training investment. These elements indicate attention to employee wellbeing beyond core insurance.
Focus Financial Partners Insights
What's It Like to Work at Focus Financial Partners?
Focus Financial Partners Culture & Values
Focus Financial Partners Career Growth & Development
What's the Work-Life Balance Like at Focus Financial Partners?
Focus Financial Partners Leadership & Management
Focus Financial Partners Company Growth, Stability & Outlook
Similar Jobs
.png)
.png)
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Focus Financial Partners is a leading partnership of independent, fiduciary wealth management firms. Focus provides unrivaled access to best practices, resources, and continuity planning for its partner firms who serve individuals, families, employers and institutions with wealth management, benefit and investment consulting services. Focus partner firms maintain their operational independence, while they benefit from the synergies, scale, economics and best practices of the market leader to achieve their business objectives. For more information about Focus Financial Partners, please visit www.focusfinancialpartners.com.
