It’s more than just numbers.
Miller Kaplan is a different kind of CPA firm; we believe in building a legacy—yours. We want to give our clients the very best, and we understand that begins with helping our employees be their best through professional mentorship, life-work integration, and a sense of community. That starts with you!
Job Summary:
The Junior Data Analyst in the Data Analytics Department supports both external client engagements and internal practice groups by delivering data-driven insights and solutions. This role offers the opportunity to contribute to high-impact projects, collaborate across teams, and develop analytical expertise within a fast-growing practice area. Success in this role requires the ability to prioritize effectively and perform in a fast paced, deadline driven environment while communicating with the team.
Supervisory Responsibilities:
Duties/Responsibilities:
- Examine collected data to identify trends, outliers, and patterns, providing actionable insights to enhance client efficiency, profitability, or other specified objectives.
- Gather and organize data from a variety of sources, including departmental heads, subject matter experts, reports, surveys, forecasts, and budgetary documentation, ensuring accuracy and completeness.
- Convert reports into structured databases.
- Design and implement secure, efficient, and accurate databases.
- Perform data cleaning, transformation, and normalization to ensure consistency and accuracy.
- Maintain data integrity and quality controls through validation checks and auditing.
- Assist with query development (SQL) to support reporting and analysis.
- Document database processes, definitions, and data dictionaries for transparency.
- Collaborate with senior analysts or IT teams to support database performance tuning and troubleshooting.
- Ensure compliance with data security, privacy, and access control.
- Assist in developing and maintaining Python scripts to automate recurring data tasks, reporting, and file processing.
- Support the development of ETL workflows that automate data cleaning, validation, and reconciliation to convert raw data into structured, reliable formats.
- Apply basic VBA scripting within Excel to streamline reports, calculations, and client deliverables.
- Document automation steps and maintain clear records for knowledge sharing and future improvements.
- Retrieve, organize, and analyze data from databases to produce accurate and actionable reports.
- Build and maintain interactive dashboards in Power BI, using visualization best practices to highlight key metrics and business