BI & Data Engineer

Primary Responsibilities

• Design, build, and maintain Power BI reports and dashboards built on top of Snowflake semantic models and semantic views, ensuring reporting is accurate, performant, and aligned to business needs.
• Own Power BI tenant administration, including workspace governance, row-level security (RLS), capacity management, gateway configuration, and DirectQuery performance tuning against Snowflake.
• Design, build, and maintain interactive data applications directly in Snowflake, using Streamlit in Snowflake and custom container-based applications (React frontend with a FastAPI backend) via Snowpark Container Services, enabling business users to interact with data beyond static dashboards.
• Leverage AI-assisted coding tools (e.g., GitHub Copilot) to accelerate development of reports, applications, and backend services, while maintaining code quality and review standards.
• Partner with data engineers and analytics engineers who build and maintain Snowflake semantic models, and work directly with business stakeholders to gather requirements and translate them into usable reporting and application experiences.
• Monitor and optimize performance across Power BI reports and Snowflake-hosted applications, and manage access controls for reports, apps, and underlying datasets in coordination with data platform governance standards.
• Manage the full lifecycle of BI reports and data applications, including version control (Git/GitHub), CI/CD for application deployment, testing, and release management.

Required Skills

• Advanced Power BI development skills (DAX, data modeling, report design) and administration experience (workspace governance, RLS, gateways, capacity planning).
• Experience connecting Power BI to Snowflake via DirectQuery or Import against semantic models.
• Proficiency building Streamlit applications, along with experience using React (or a similar frontend framework) and FastAPI (or a similar Python backend framework) to build custom applications.
• Familiarity with containerization (Docker) and deploying containerized apps, ideally within Snowflake via Snowpark Container Services.
• Strong SQL skills and familiarity with Snowflake semantic models/semantic views, Cortex Analyst, and general Snowflake data structures.
• Comfort using AI coding assistants (e.g., GitHub Copilot) as part of a daily development workflow.
• Solid Python skills for backend and application development, and working knowledge of JavaScript/TypeScript for frontend development.
• Experience with Git/GitHub and CI/CD pipelines (e.g., GitHub Actions) for deploying applications and reports.
• Strong ability to translate business requirements into technical solutions, with excellent stakeholder communication skills.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related technical field, or equivalent hands-on experience.
• Typically 4+ years of professional experience in BI development and/or administration, with demonstrated experience expanding into application development (e.g., Streamlit or full-stack web applications).
• Proven track record of owning a BI platform end-to-end and delivering interactive data applications beyond static dashboards and reports.
• Experience in financial services, wealth management, or other regulated industries is a plus.
• Demonstrated ability to work independently, manage priorities, and take ownership of data products from requirements through ongoing support.

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.

Benefits

The annualized base pay range for this role is expected to be between $110,000 - $130,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.