Job Description

Job Summary:

The Business Data Analyst provides advanced expertise in data management, automation, and analytics to support strategic decision-making across the CMC. This role is responsible for designing and maintaining automated data pipelines, ensuring data quality and governance, and delivering actionable insights through statistical analysis and business intelligence tools.

The analyst leverages programming languages such as Python and SQL, integrates data from multiple enterprise systems, and develops dynamic dashboards and reports using platforms like Power BI. In addition to technical proficiency, the role requires strong communication and collaboration skills to translate complex data into meaningful recommendations for stakeholders.

The analyst also contributes to continuous improvement initiatives, promotes data literacy, and ensures compliance with institutional and regulatory standards.

Specific Responsibilities:

Strategic Planning

Partners with clients to define requirements based on business objectives.
Identifies opportunities for automation, data integration, and advanced analytics to support strategic initiatives.
Collaborates with stakeholders to align data solutions with institutional goals and continuously improve data-driven decision-making.
Incorporates financial planning and budget forecasting into strategic data initiatives to ensure alignment with fiscal goals.
Administration

Develops standardized templates, policies, and procedures for internal and external reporting to ensure consistency and compliance.
Designs and prepares documentation for both qualitative and quantitative data analysis, including process documentation for automated workflows.
Discusses findings with management and provides actionable recommendations based on data insights.
Maintains documentation for data governance, ensuring adherence to privacy, security, and compliance standards.
Tracks and reconciles departmental processing of payments and adherence to financial policies.
Development

Develops and maintains complex queries, quality metrics, and automated ETL pipelines to support scalable data operations.
Interprets results using a variety of techniques, from simple aggregation to advanced statistical models.
Manages and optimizes relational and non-relational databases, ensuring data integrity, performance, and accessibility.
Builds dashboards and tools to monitor expenditures, encumbrances, and payment workflows.
Performance

Completes data cleaning and organizes data files for analysis using tools such as Python, SQL, and Excel.
Reviews data for quality issues and implements automated validation checks to ensure accuracy and reliability.
Presents findings through Power BI dashboards, reports, and visualizations tailored to technical and non-technical audiences.
Supervises

Provides work direction and/or supervises staff such as team members, subordinates, contractors, vendors, and student workers.
Mentors staff and student workers. Fosters a collaborative environment that supports professional development and continuous learning.
Oversees allocations for projects and ensures timely approval and processing of vendor and contractor payments.
Miscellaneous

Performs other duties as assigned.

Minimum Qualifications:

Successful completion of a full 4-year course of study in an accredited college or university leading to a bachelor's or higher degree in Data Science, Statistics, Computer Science, Information Systems, Business Analytics, or a related field; OR an equivalent combination of education and experience.
Minimum of 2 years of professional experience in data analysis, business intelligence, or a related field, including experience with data reporting, visualization, and automation.
Demonstrated proficiency in tools and technologies such as Python, SQL, Power BI, and Microsoft Excel.
Experience working with enterprise data systems and reporting platforms (e.g., PeopleSoft, Cognos BI, or similar).
Familiarity with data governance, data quality assurance, and compliance standards.
Strong communication skills with the ability to translate technical findings into actionable insights for diverse audiences.
Experience with workflow automation tools (e.g., Power Automate) and collaborative platforms (e.g., Microsoft Lists, SharePoint) is preferred.
Minimum Competencies: (Skills, knowledge, and abilities.)

Strong analytical and critical thinking skills with the ability to interpret complex data sets and derive actionable insights.
Proficiency in data management, including data cleaning, transformation, and validation using tools such as Python, SQL, and Excel.
Experience with business intelligence tools (e.g., Power BI, Tableau, or Cognos BI) for data visualization and reporting.
Familiarity with Microsoft Power Automate for streamlining workflows and automating repetitive tasks.
Knowledge of statistical analysis techniques and the ability to apply them to real-world business problems.
Excellent written and verbal communication skills, with the ability to present technical information to non-technical audiences.
Strong organizational and project management skills, including the ability to manage multiple priorities and meet deadlines.
Ability to work independently and collaboratively in a cross-functional team environment.
Commitment to data integrity, security, and compliance with institutional and regulatory standards.
Preferred Qualifications:

Bachelor’s degree in Data Science, Statistics, Computer Science, Business Analytics, or a related field.
Minimum of 2 years of experience in a data analyst, business intelligence, or similar role.
Demonstrated experience in building and maintaining automated ETL pipelines and workflow automation using tools like Power Automate.
Experience working in higher education or a similarly complex organizational environment.
Prior experience with institutional research, employment reporting, or career services data is a plus.
Preferred Competencies: (Skills, knowledge, and abilities)

Proficiency in Python or Java for data automation, including scripting, web scraping, and API integration.
Experience with cloud-based data platforms (e.g., Azure) and version control systems (e.g., Git).
Ability to design and implement automated reporting solutions and dashboards.
Proficiency in Microsoft Power Automate for automating business processes and integrating data systems.
Knowledge of data governance principles and best practices.
Strong attention to detail and a proactive approach to identifying and solving problems.
Ability to mentor staff or student workers and contribute to a culture of continuous improvement.