Director of Business Intelligence & Corporate Analytics - CBIZ

Marcum LLP is thrilled to announce that we are now part of CBIZ and CBIZ CPAs, a partnership that unites us with one of the nation's top accounting and advisory providers. As part of this new chapter, we are pleased to confirm that you'll still be working with the same dedicated team and receiving the same high-quality service you've come to rely on.

Together, we will continue to support a diverse array of industries, including healthcare, real estate, construction, retail & consumer products, manufacturing & distribution, technology, media & telecommunications (TMT), government, not-for-profit, hospitality & leisure, and education.

CBIZ has been honored to be the recipient of several national recognitions for 2023:

• Best and Brightest Companies to Work for in the Nation
• Top Workplaces USA
• Top Workplaces - Financial Services Industry
• Best and Brightest Companies in Wellness
• Great Place to Work Certification

Together, CBIZ and CBIZ CPAs are ranked as one of the top providers of accounting services in the United States. CBIZ CPAs is an independent CPA firm that provides audit, review and attest services, while CBIZ provides business consulting, tax and financial services. In certain jurisdictions, CBIZ CPAs operates under its previous name, Mayer Hoffman McCann P.C.

Essential Functions and Primary Duties

• Lead and manage the Business Intelligence & Corporate Analytics team
• Transform internal corporate data reporting resources and tools, to improve efficiency and effectiveness
• Develop and implement data-driven strategies to support organizational decision-making
• Enhance benchmarking capabilities to provide actionable insights for client service
• Identify opportunities to serve clients better through enhanced corporate data repositories and reporting
• Based on data governance and security standards, identify areas where data may be used to benchmark client businesses, foster client growth, and enhance client profitability
• Transform data insights into a competitive market differentiator for the organization
• Define internal data requirements and establish data processes to achieve ultimate data objectives
• Collaborate with cross-functional teams to identify and implement data analytics solutions
• Stay current with emerging trends and technologies in business intelligence and data analytics

Preferred Qualifications

• 10+ years of experience in professional services, with a preference in accounting, tax, audit, consulting, and insurance, and a strong focus on data analytics and reporting
• Proven track record of leading teams and delivering data-driven solutions
• Industry expertise in accounting (Tax, Audit, and Advisory) is preferred
• Expert knowledge of enterprise information / data repositories (such as Oracle), as well as Microsoft applications and Salesforce. Knowledge of audit and tax platforms that generate large volumes of client data annually is a huge plus.
• Expertise in data visualization techniques and best practices for presenting complex information
• Advanced hands-on proficiency in a wide range of data analytics and business intelligence tools, to design solutions and to oversee and mentor technical team members to ensure accuracy.
• Microsoft Power BI: Expert-level experience; for designing and creating interactive dashboards, implementing DAX measures, and developing complex data models.
• SQL: Proficient in writing complex queries, stored procedures, and optimizing database performance
• Python or R: Experience with data manipulation, statistical analysis, and machine learning libraries (e.g., pandas, scikit-learn, ggplot2)
• ETL Tools: Expertise in data integration and transformation using tools like SSIS, Alteryx, or Talend
• Cloud Platforms: Familiarity with cloud-based analytics services (e.g., Azure Synapse Analytics, AWS Redshift, Google BigQuery)
• Strong background in Microsoft Data analytics technologies, including:
• Azure Data Factory: for data integration and workflow orchestration
• Azure Databricks: for big data analytics and machine learning
• Power Apps and Power Automate: for creating custom business applications
• Proficiency in optimizing Oracle and other database management and analytics tools
• Knowledge of data integrations and reporting with Salesforce, including Salesforce Analytics (Einstein Analytics) and Salesforce Integration
• Experience with strategizing and leading data migration efforts
• Experience directing and driving data governance, data quality management, and data security best practices
• Extensive experience with Data Lake technologies and architectures, including:
• Data Lake storage solutions: Azure Data Lake Storage, Amazon S3, Google Cloud Storage
• Data processing frameworks: Apache Hadoop, Apache Spark, Apache Flink
• Data cataloging and metadata management tools: Azure Data Catalog, AWS Glue Data Catalog
• Data governance and security for Data Lakes: data encryption, access control, data lineage tracking
• Data Lake query engines: Apache Hive, Presto, Apache Drill
• Data Lake integration with BI tools and data warehouses
• Implementation of data lake best practices: data zoning (raw, cleaned, curated zones), data partitioning strategies, and optimization techniques
• Bachelors degree or higher, with a preference of Computer Science, Information Systems, Business Analytics, Data Science, Accounting, or a related field. Masters Degree is a plus
• Advanced certifications in data analytics and business intelligence are preferred, such as:
• Microsoft Certified: Data Analyst Associate
• Microsoft Certified: Azure Data Scientist Associate
• AWS Certified Big Data - Specialty
• Salesforce Certified Data Architect
• Certified Analytics Professional (CAP)
• Certified Information Systems Auditor (CISA)
• TDWI Certified Business Intelligence Professional
• Relevant accounting or tax certifications (e.g., CPA, EA) are highly desirable

Minimum Qualifications

• Bachelor's degree required
• 8 years of experience in public accounting or related field
• 6 years of supervisory experience
• Ability to manage deadlines, work on multiple assignments and prioritize each assignment as necessary
• Proficient use of applicable technology
• Demonstrated ability to communicate verbally and in writing throughout all levels of organization, both internally and externally
• Proven high level of business integrity, client service and leadership skills
• Must be able to travel based on client and business needs