MCD Partners ยท 1 day ago
Data Analyst
MCD Partners is focused on improving life outcomes for patients through teamwork. The Data Analyst will be responsible for data analysis, reporting, and providing business insights to support decision-making.
Digital MarketingGraphic DesignInternetUX DesignWeb DesignWeb Development
Responsibilities
Developed interactive Power BI dashboards to improve analytical efficiency and provide actionable business insights
Created measures and calculated columns using DAX (data analysis expressions) to perform advanced calculations and support decision-making
Strong Power BI desktop reporting and visuals
Published reports from Power BI Desktop to Power BI Service and shared dashboards with stakeholders in real-time
Monitored KPIs, conducted Root Cause Analysis (RCA), and provided insights on production and operational performance
Applied time intelligence calculations (YTD, PYTD, CYTD) and comparative analysis techniques for trend analysis
Standardized raw data to reduce errors and improve overall data quality
Worked with calendar, geographical, text, and decimal data in Power BI Transform Query Editor to ensure accurate analysis and reporting
Working with third parties (snowflake, Boolean), to build and maintain data warehouses. Build customized reports as needed from warehouse data sources
Strong leadership skills to take lead of the project and to be able to present new ideas to management
Extract data from xlsx, xlsm, csv files to Power BI desktop (if needed on a one-time project)
Qualification
Required
Developed interactive Power BI dashboards to improve analytical efficiency and provide actionable business insights
Created measures and calculated columns using DAX (data analysis expressions) to perform advanced calculations and support decision-making
Strong Power BI desktop reporting and visuals
Published reports from Power BI Desktop to Power BI Service and shared dashboards with stakeholders in real-time
Monitored KPIs, conducted Root Cause Analysis (RCA), and provided insights on production and operational performance
Applied time intelligence calculations (YTD, PYTD, CYTD) and comparative analysis techniques for trend analysis
Standardized raw data to reduce errors and improve overall data quality
Worked with calendar, geographical, text, and decimal data in Power BI Transform Query Editor to ensure accurate analysis and reporting
Working with third parties (snowflake, Boolean), to build and maintain data warehouses. Build customized reports as needed from warehouse data sources
Strong leadership skills to take lead of the project and to be able to present new ideas to management
Extract data from xlsx, xlsm, csv files to Power BI desktop (if needed on a one-time project)
A growth mindset and focused on continuous growth
Thrive in a dynamic and fast-paced work environment
Highly organized and have a strong attention to detail
Can handle sensitive information and maintain complete confidentiality in all aspects of work
Advanced knowledge of Microsoft Excel and Power BI
Proficient in financial report writing and interpretation
Excellent analytical skills with the ability to identify trends and variances
Solid understanding of financial concepts and corporate finance principles
Preferred
Experience with DSO's, Dental, Orthodontic practices, or medical accounting preferred
Experience with Snowflake AI data cloud highly valued
Benefits
401(k)
Dental insurance
Health insurance
Paid holidays
Paid time off
Vision insurance
Work from home
Company
MCD Partners
MCD is an agency focused on the digital customer experience.
H1B Sponsorship
MCD Partners has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (5)
2020 (2)
Funding
Current Stage
Growth StageTotal Funding
unknown2016-03-16Acquired
Company data provided by crunchbase