Services
Languages
B. Rhyner
Analytics Engineer | Business Intelligence Consultant | Data Analytics ExpertPreferred skills to work with
All Skills
About
An accomplished Analytics Engineer with a proven track record in managing and optimizing data pipelines. Here’s an overview of my expertise:
- Technical Skills: Proficient in SQL, dbt, Google BigQuery, R, Python, Microsoft Power BI, and GitHub, with a foundational command over various BI tools like Tableau and Looker.
- Data Handling Expertise: Specializing in ELT (Extract, Load, Transform) and rETL (reverse ETL) processes, ensuring data integrity and accessibility across organizations.
- Analytical Approach: Leveraging a strong academic background in Political Science and a Master’s in Political Data Journalism to interpret complex datasets and derive actionable insights, especially for political and social narratives.
- Innovation and Leadership: Leading teams in data innovations, predictive analytics, and Customer Data Platforms, while fostering a culture of continuous learning and upskilling team members.
- Client Collaboration: Experienced in presenting KPIs and insights to C-level executives, helping to drive strategic decisions based on accurate data analysis.
Throughout my career, I've been dedicated to enhancing organizational growth through data-driven methodologies, ensuring I stay at the forefront of emerging technologies and analytics practices.
Experiences
As a BI Consultant at Heyde AG, I play a pivotal role in enhancing business intelligence solutions tailored to meet client needs. Heyde AG is renowned for its innovative approach in delivering data-driven insights to businesses.
- Collaborating with clients to understand their business challenges and translate them into actionable business intelligence strategies.
- Developing and implementing data analyses, data collection systems, and other strategies that optimize statistical efficiency and quality.
- Designing dashboards and reports that present insights in an engaging and user-friendly manner.
- Conducting workshops and training sessions for clients to improve their analytical skills and ensure effective use of BI tools.
- Assisting in the evaluation of existing BI tools and recommending improvements that align with industry best practices.
- Achieving significant improvements in data reporting accuracy and reducing decision-making time for clients through the integration of advanced analytical models.
HAIR & SKIN, located in Winterthur, Switzerland, is a leading company specializing in hair and skin care products. In my role as Lead Business Intelligence, I was responsible for overseeing key business intelligence initiatives, ensuring the organization was equipped with timely and accurate reporting to drive strategic decisions.
- Managed all reporting needs across the organization, focusing on the delivery of insightful information to stakeholders.
- Oversaw the development and enhancement of data products, specifically leveraging Business Intelligence tools and optimizing Data Warehouse structures to improve visibility and accessibility of information throughout the company.
- Drove the innovation of data solutions including Customer Data Platforms, predictive analytics, and reverse ETL processes to promote data-driven operations.
- Led a skilled team of data professionals, fostering a culture of continuous learning and implementing best practices in business intelligence.
- Collaborated with technical teams, particularly within the Salesforce ecosystem, to ensure data architecture was robust and aligned with business objectives.
- Regularly presented key performance indicators (KPIs) and insights to C-level executives, providing summaries of organizational performance and identifying areas for improvement.
As a Senior Data Analyst at HAIR & SKIN, a leading company in the beauty sector, I played a pivotal role in enhancing data-driven decision-making and operational efficiency within the organization.
- Led numerous organization-wide projects aimed at streamlining processes, resulting in improved communication and resource planning.
- Developed and maintained a cloud-based Data Warehouse using tools such as dbt, Fivetran, and BigQuery, ensuring high performance and scalability while guiding team members in skill development.
- Actively participated in a dynamic analytics team to address urgent data inquiries, providing timely and impactful insights to stakeholders.
At bestsmile, a prominent dental services provider based in Winterthur, I served as the Business Insights Lead and Business Intelligence Architect, focusing on enhancing data-driven decision-making across the organization. My role encompassed a variety of critical projects and responsibilities:
- Identified solution requirements and use cases to analyze operational business challenges, ensuring that our data strategies aligned with the company's objectives.
- Acted as the project manager and primary contact for the implementation of a company-wide Business Intelligence (BI) system, driving the adoption of data analytics tools and methodologies.
- Conceptualized and designed the data architecture for a data warehouse that facilitated effective integration with the BI system, enhancing overall data accessibility and utility.
- Processed BI use cases across various BI tools, including Looker, Tableau, Power BI, and Dundas BI, to determine the best fit for the company's analytical needs.
- Implemented a fully automated data pipeline, integrating all source systems into a centralized data warehouse, thus streamlining data collection and reporting processes.
- Built, modeled, and cataloged a data warehouse using Google BigQuery in conjunction with dbt (data build tools), enhancing data governance and accessibility.
- Delivered training and support to the internal data hub team within the Data Engineering Unit, fostering a culture of innovation and continuous learning.
At bestsmile, a leading company in dental care solutions, I served as a Retail Analyst and Operations Lead, where I was central to enhancing retail operations.
- Acted as the main retail stakeholder, representing business requirements with the Salesforce Development Team, ensuring alignment on priorities and deliverables.
- Led retail-specific and cross-sectional KPI tracking and reporting, providing critical insights for decision-making.
- Engaged in advanced reporting activities by utilizing scripting languages such as R and Python, enhancing the data-driven approach within the organization.
- Planned and successfully launched an internal knowledge management system using Salesforce Community Cloud, fostering better collaboration and information sharing.
- Managed and supervised a small team of Retail Operations Trainees, mentoring them while driving operational excellence.
As an Operations Intern at Bestsmile, a leading player in the dental industry, I was responsible for managing and supervising critical operational tasks across multiple dental offices in Switzerland.
- Managed process controlling utilizing Salesforce and the appointment management tool, ensuring streamlined operational workflows.
- Conducted initial touchpoints in Salesforce reporting, aiding in the development of comprehensive reporting metrics.
- Took charge of shift and absence planning for a total of 14 operational dental offices located in Western and Southern Switzerland, which represented half of the company's revenue and staffing.
- Actively participated in Salesforce sprint meetings, where I contributed to the definition and oversight of Salesforce update features, thus enhancing our organizational efficiency.
Education
During my Master's studies at the University of Zurich, I focused on expanding my analytical abilities and understanding of political systems, policies, and data journalism. The program involved engaging with a variety of methodologies applicable to political science, allowing me to explore complex social issues and refine my research skills. I participated in significant projects that emphasized the importance of data interpretation in political contexts, fostering my ability to analyze substantial datasets and convey their implications effectively. Additionally, I collaborated with peers on critical case studies that deepened my understanding of data management and its impact on real-world political scenarios.
During my studies at the University of Zurich, I pursued a Bachelor of Arts with a strong emphasis on Political Science and Chinese Studies. My academic journey spanned from January 2016 to January 2020, culminating in a solid GPA of 5.4. Throughout this period, I actively engaged in various research projects and academic workshops that honed my analytical and critical thinking skills. My coursework provided me with a comprehensive understanding of political structures and cultural dynamics, particularly in relation to China. Additionally, I collaborated with peers on projects that explored issues of international relations and policy-making, which further enriched my academic experience and prepared me for a career in analytics and data-driven decision-making.
Completed a non-degree program focused on Chinese language and literature at Dalian University of Foreign Languages from January 2017 to January 2018, achieving a notable GPA of 87.75. This program offered rich insights into Chinese linguistics and cultural studies, fostering a deep understanding of Chinese literary works and enhancing proficiency in the language. Participated in various projects and activities that encouraged practical application of language skills and cultural engagement.