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 Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
