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 .
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.