Jan Janicki

Senior Accounting & Controlling Analyst - SQL advanced - (100% remote-friendly within Poland) @ Docplanner by via all AI news ([Global] Oracle Advanced Analytics) URL: https://ift.tt/XN5ZAS4 Company Description We are the largest digital healthcare platform in the world, present in 15 countries and currently connecting over 30 million patients to more than 2 million healthcare professionals. We seek to make the experience in health more human and we live and breath this mission.  We obsess over the challenge of minimizing patients' pain and helping healthcare professionals thrive managing their patients and expand their online presence. Through services that bring health to users, we provide a space for questions, opinions and a way to find the health professional that best fits your needs. To deliver the best result, we have motivated people with an innovative spirit, giving everyone the opportunity to actively contribute and grow within the company. The DocPlanner team is our secret sauce and for the 2nd consecutive year we were recognized as a Great Place To Work. We love diversity because each unique individual's perspective makes us stronger. We encourage everyone to participate in our hiring process. We’d love for you to bring your unique skill set and join the team! Job Description We are seeking a highly skilled and experienced Senior Financial Reporting Analyst to join our Data & Business Intelligence team. In this pivotal role, you will lead the evolution of financial reporting within a challenging and dynamic environment. You will play a key role in bridging the gap between finance and BI, with a strong emphasis on SQL-based data analysis, integration, and advanced financial modeling. Your expertise will drive data-driven decision-making across the organization, ensuring that our financial reports serve as the primary and most reliable source of business insights. As a senior member of a team of 12 experts, you will provide strategic support to various departments, including finance, marketing, sales, customer success, and people experience. You will collaborate closely with senior stakeholders to develop sophisticated reports, in-depth analyses, predictive models, and actionable recommendations that will enhance the satisfaction of both doctors and patients. Your role will be crucial in shaping the future of our financial reporting, working alongside the Financial reporting team to ensure that business decisions are firmly grounded in data. Key Responsibilities Strategic Financial Reporting and Analysis: Lead the tracking and analysis of key financial metrics and KPIs, ensuring alignment with organizational goals and long-term strategies; Develop, enhance, and maintain advanced financial dashboards using state-of-the-art BI tools; Provide deep, data-driven insights into financial performance, trends, and variances, supporting strategic business decisions. Advanced Data Management and Integration: Leverage...

Problem of the Week:   1.        The client needs to see the selected values of all filters on a page in a single visual. 2.        The measure needs to be recreated for several pages (each with different data set), how do I find and replace all the table names in my DAX code fast.     Solution 1: Displays in Card visual: “On Page Filters: Group : All | Branch : All |  Fleet : All | Province : All” or Selected values in place of All   Measure: Page Level Filters Display= "On Page Filters: Group : "& if(ISFILTERED(Table[Group]),CONCATENATEX(       VALUES(Table[Group]),       'Table'[Group],       ", ",       'Table'[Group]),"All")       &       " | Branch : "& if(ISFILTERED(Table[Branch]),CONCATENATEX(       VALUES(Table[Branch]),       'Table'[Branch],       ", ",       'Table'[Branch]),"All")       &        " | Fleet : "& if(ISFILTERED(Table[Fleet]),CONCATENATEX(       VALUES(Table[Fleet]),       'Table'[Fleet],       ", ",       'Table'[Fleet]),"All")       &        " | Province : "& if(ISFILTERED(Table[Province]),CONCATENATEX(       VALUES(Table[Province]),       'Table'[Province],       ", ",       'Table'[Province]),"All")   Solution 2: Open the DAX measure Highlight “Table”(or any piece of repeated code that you want to change) Press Ctrl+F2 It will edit all occurrences of “Table” Let me know if you have some other/easier ways to solve the problems. For some more useful (and some less useful) shortcuts follow the below link: https://lnkd.in/djkHG9qd #powerbi

Senior Accounting & Controlling Analyst - SQL advanced - (100% remote-friendly within Poland) @ Docplanner by via ai-jobs.net ([Global] Oracle Advanced Analytics) URL: https://ift.tt/XN5ZAS4 Company Description We are the largest digital healthcare platform in the world, present in 15 countries and currently connecting over 30 million patients to more than 2 million healthcare professionals. We seek to make the experience in health more human and we live and breath this mission.  We obsess over the challenge of minimizing patients' pain and helping healthcare professionals thrive managing their patients and expand their online presence. Through services that bring health to users, we provide a space for questions, opinions and a way to find the health professional that best fits your needs. To deliver the best result, we have motivated people with an innovative spirit, giving everyone the opportunity to actively contribute and grow within the company. The DocPlanner team is our secret sauce and for the 2nd consecutive year we were recognized as a Great Place To Work. We love diversity because each unique individual's perspective makes us stronger. We encourage everyone to participate in our hiring process. We’d love for you to bring your unique skill set and join the team! Job Description We are seeking a highly skilled and experienced Senior Financial Reporting Analyst to join our Data & Business Intelligence team. In this pivotal role, you will lead the evolution of financial reporting within a challenging and dynamic environment. You will play a key role in bridging the gap between finance and BI, with a strong emphasis on SQL-based data analysis, integration, and advanced financial modeling. Your expertise will drive data-driven decision-making across the organization, ensuring that our financial reports serve as the primary and most reliable source of business insights. As a senior member of a team of 12 experts, you will provide strategic support to various departments, including finance, marketing, sales, customer success, and people experience. You will collaborate closely with senior stakeholders to develop sophisticated reports, in-depth analyses, predictive models, and actionable recommendations that will enhance the satisfaction of both doctors and patients. Your role will be crucial in shaping the future of our financial reporting, working alongside the Financial reporting team to ensure that business decisions are firmly grounded in data. Key Responsibilities Strategic Financial Reporting and Analysis: Lead the tracking and analysis of key financial metrics and KPIs, ensuring alignment with organizational goals and long-term strategies; Develop, enhance, and maintain advanced financial dashboards using state-of-the-art BI tools; Provide deep, data-driven insights into financial performance, trends, and variances, supporting strategic business decisions. Advanced Data Management and Integration: Leverage...

🦸🦸Power BI Sentinel to the rescue!🦸🦸 We give you peace of mind that you have a roll-back plan and an audit/investigation process should you ever need it; for all your users If you want to read more about practices for DevOps in Power BI read here: https://lnkd.in/egukHRME

🦸🦸Power BI Sentinel to the rescue!🦸🦸 We give you peace of mind that you have a roll-back plan and an audit/investigation process should you ever need it; for all your users If you want to read more about practices for DevOps in Power BI read here: https://lnkd.in/egukHRME

Finance Data Analyst - (100% remote-friendly within Poland) @ Docplanner by via ai-jobs.net ([Global] Oracle Advanced Analytics) URL: https://ift.tt/syQxT0S Company Description We are the largest digital healthcare platform in the world, present in 15 countries and currently connecting over 30 million patients to more than 2 million healthcare professionals. We seek to make the experience in health more human and we live and breath this mission.  We obsess over the challenge of minimizing patients' pain and helping healthcare professionals thrive managing their patients and expand their online presence. Through services that bring health to users, we provide a space for questions, opinions and a way to find the health professional that best fits your needs. To deliver the best result, we have motivated people with an innovative spirit, giving everyone the opportunity to actively contribute and grow within the company. The DocPlanner team is our secret sauce and for the 2nd consecutive year we were recognized as a Great Place To Work. We love diversity because each unique individual's perspective makes us stronger. We encourage everyone to participate in our hiring process. We’d love for you to bring your unique skill set and join the team! Job Description The resource, working within the Financial Reporting team, will play a key role in supporting the evolution of financial reporting in a challenging and stimulating environment. You will help bridge the gap between finance and BI. Our primary objective is to assist the business in making decisions based on data, with a particular emphasis on producing reports as the primary and most reliable source of information. A team of 12 experts provides support to various departments, including marketing, sales, customer success, finance, and people experience, for both short-term and long-term projects. Collaborating closely with stakeholders, we strive to develop reports, analyses, models, and recommendations that enable us to gain a deep understanding of how we can enhance the satisfaction of both doctors and patients. You will be an integral part of the Financial Reporting team, working closely with the Data Analytics team to support business decisions based on data. How would you be impacting our mission Financial Reporting and Analysis: Track key financial metrics and KPIs, ensuring they align with organizational goals; Develop and maintain comprehensive financial dashboards using advanced BI tools; Provide detailed insights into financial performance, trends, and variances; Provide insights for long-term strategic decisions; Data Management and Integration: Ensure accurate and timely collection of financial data from systems like Oracle NetSuite; Integrate data from multiple sources for a unified financial view; Performance Measurement: Analyze profitability and cost efficiency to identify improvement areas; Regulatory and Compliance Reporting: Support audits and...