SullivanCotter

Business Intelligence Analyst

• SullivanCotter partners with health care and not-for-profit organizations to provide workforce strategy and compensation benchmarking
• Participate in survey data collection, data validation, benchmark and report creation for health care compensation surveys
• Participate in data cleaning processes across multiple phases using in-house and statistical software
• Collaborate with analysts and survey managers to produce compensation and survey reports and analyses
• Provide guidance and support to internal and external clients and survey participants regarding survey processes and analysis
• Provide in-depth quality assurance to compensation reports per formatting, analysis, and content guidelines
• Create and/or audit workflows, analyses, charts, and dashboards using Alteryx, Databricks, and Tableau
• Identify and implement workflow improvements, automation, and streamlining opportunities
• Assist with ad hoc survey reports, analyses, and projects
• Create and standardize training materials for new and existing processes
• Ensure compliance with deliverable reporting requirements by performing quality data audits and analysis
• Lead complex reporting projects with consideration for scalable cloud solutions
• Build and refine data models to support migration from legacy tools to cloud infrastructure
• Understand ETL processes and data warehousing best practices
• Conduct and train others in in-depth data cleaning and assure reporting calculations per documented specifications
• Oversee ad hoc analytics and one-off projects and present findings to stakeholders
• Mentor and train more junior analysts and assist management with administrative duties

Survey Data and Reporting Analyst