Job Description
Join our team as a Senior Data Solution Engineer and turn data into business-ready insights. You will architect and deliver domain data marts, semantic models, and Power BI solutions that make data accessible, bridging business needs with robust data engineering practices. You’ll work within a data engineering team that sets up the platform, migrates the existing data and analytics solutions, operates and further develops the platform.
Your main responsibilities are:
Architect business data marts in Snowflake and lead the development of production‑grade dbt models, setting standards for modeling, documentation, and testing;
Develop and improve the data vault 2.0 architecture together with the data architect;
Lead the design of the semantic layer through Power BI; design and implement reports in Power BI;
Optimize performance and cost of data models, queries, and reporting solutions across all tools;
Collaborate closely within the data engineering team to estimate, plan, and deliver data analytics solutions as well as with the data architect, delivery lead, business analysts and business counterparts to meet business requirements;
Incorporate SLAs and processes into designs; anticipate business impact, participate in root‑cause analysis and incident resolution, and maintain clear documentation;
Coach and mentor peers in the team;
Evolve CI/CD for dbt and BI (Azure DevOps), including automated testing, deployment, and rollback strategies;
Implement security and governance end‑to‑end (Snowflake roles/policies, RLS in Power BI), ensuring data privacy and compliant access.
Requirements
Strong experience in data solution engineering or analytics engineering, with proven track record of delivering data vault 2.0 architecture, data marts and semantic models in enterprise environments;
Industry experience in finance or similar industries;
Extensive experience with Snowflake, dbt, Power BI, and SQL; familiarity with Azure Data Factory and Python is a plus;
Good understanding of CI/CD pipelines, ideally using Azure DevOps;
Experience with migrating on-prem (data warehouse) systems to the cloud is valuable;
Experience working in agile/scrum environments;
Fluent in English, with German language skills being an advantage.
What you can expect
We provide modern working conditions, including work-from-home options, flexible hours and a home office allowance to ensure staff members have a work environment equipped with the latest technology;
A diverse culture founded on mutual respect, teamwork and appreciation awaits you at LGT Capital Partners. We go the extra mile to generate impact;
We empower and invest in you: your professional development and personal growth are our priority. We offer various internal and external training opportunities that are aligned with your ambitions and our business needs. If you are interested, you can also enhance your German or English language skills;
We are proud to be owned by the Princely Family of Liechtenstein and our company is inspired by its entrepreneurial spirit;
Commitment to ESG: our approach to business is influenced by the Princely Family’s long-term perspective. Sustainability is key for us and has shaped our actions since 2002;
You benefit from favorable terms and conditions if you wish to participate in LGT Capital Partners’ investment programs or to use LGT banking products and services.
Contact Information
If you are interested in becoming an integral part of a successful alternative investment management team in an international, multicultural working environment we will be pleased to get to know you soon.
For further information please contact us.
Human Resources
LGT Capital Partners AG, PfaeffikonContact:
+41 58 261 86 62