Design and implement robust end-to-end data integration solutions ensuring data quality, availability, and compliance while collaborating with cross-functional teams.
Focus Financial Partners is looking for a Data Integration Architect to design and implement end-to-end data integration solutions, ensuring seamless data flow and high availability across systems. You’ll develop best practices for ETL/ELT processes, optimize data pipelines, and enforce data governance frameworks. Collaborating with cross-functional teams, you will troubleshoot platform issues, ensure data quality and compliance, and help build scalable, secure data architectures.
Primary Responsibilities
- Architect, design, and implement end-to-end data integration solutions that ensure seamless data flow and high availability across various transactional systems and data platforms.
- Develop and enforce best practices, standards, and guidelines for ETL/ELT processes and data integration methodologies
- Design scalable, secure data systems, focusing on integration, optimization, and compliance.
- Collaborate with cross-functional teams, including business stakeholders, data engineers, and IT, to understand complex data integration requirements and translate these into scalable, efficient, and reliable solutions.
- Develop and enforce best practices, standards, and guidelines for ETL/ELT processes and data integration methodologies.
- Ensure high data quality, reliability, and accessibility by implementing robust data governance and quality frameworks.
- Work experience with complex data warehouses and data lakes, with familiarity in Snowflake and SQL Server being a plus.
- Work closely with data engineers and data analysts to create efficient, scalable data pipelines and workflows.
- Troubleshoot and resolve complex data platform issues, ensuring minimal downtime and optimal performance.
- Document comprehensive system designs, processes, and workflows to facilitate knowledge sharing and maintain a robust, well-documented data infrastructure.
Qualifications
- Bachelor's degree in Statistics, Mathematics, Computer Science, or related field. Master's degree preferred.
- Proven experience in data analysis, business intelligence, or related roles.
- Proficiency in data analysis tools and programming languages (e.g., SQL, Python, R, etc.).
- Strong analytical and problem-solving skills with attention to detail.
- Excellent communication and presentation abilities.
- Ability to work independently and collaboratively in a fast-paced environment.
- Experience with data visualization tools (e.g., Tableau, Power BI, etc.) is a plus.
- Knowledge of machine learning and data mining techniques is desirable.
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 between $175,000-$200,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.
Top Skills
Elt
ETL
Power BI
Python
R
Snowflake
SQL
SQL Server
Tableau
Similar Jobs
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
This role involves managing the end-to-end SDLC for public sector Salesforce initiatives, working with business stakeholders to ensure compliance with federal security requirements, and driving user adoption through effective change management.
Top Skills:
Customer CommunityFedrampIl4Il5SalesforceSalesforce Government CloudService Cloud
Fintech • Machine Learning • Social Impact • Software • Financial Services
The Data Scientist II will lead data-driven projects, applying machine learning to enhance business processes and customer experiences.
Top Skills:
PandasPythonSklearnSQLTensorFlow
Healthtech • HR Tech • Kids + Family • Other • Social Impact • Telehealth
The Senior Director of Outcomes Analytics will lead the analytics team, develop measurement strategies, and translate complex data into strategic insights to enhance health outcomes and drive revenue growth.
Top Skills:
Ai/Ml CapabilitiesDbtPythonRSnowflakeSQLTableau
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
