Junior Data Analyst

Miller Kaplan is a CPA firm focused on delivering high-quality client services while supporting employee growth through mentorship, life-work integration, and community. The Junior Data Analyst supports client engagements and internal practice groups by gathering, managing, analyzing, and visualizing data, developing automated solutions, and delivering actionable insights.

What you'll do:

• 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

What they're looking for:

• Bachelor's degree in accounting, Finance, Economics, Data Science, Statistics, Mathematics, Computer Science, Quantitative Analysis, or related field
• Strong analytical thinking with high attention to detail and accuracy
• Effective communication and presentation skills for staff and stakeholders at all levels
• Excellent organizational and time management skills; able to work independently and proactively
• Proficient in Microsoft Excel (formulas, pivots, Power Query, Power Pivot, DAX, M Code) and the broader Microsoft Office Suite
• Proficient in programming with Python or SQL
• Proficient with data visualization tools such as Power BI or Tableau
• Understanding of database design, structure, and query languages
• Familiarity with statistical methods (e.g., linear regression, logistic regression)
• Respect for controls documentation and audit trails
• Ability to work in a fast-paced environment
• Prolonged periods sitting at a desk and working on a computer

Benefits:

• Generous Paid Time Off: Start with 20 days and watch it grow, plus 2 extra days annually for managers.
• Medical options include HMO, PPO, HDHP, with fully covered dental and vision for you.
• Flexible Spending Accounts & Health Savings Accounts: Manage healthcare expenses conveniently with a benefits debit card.
• Employee Assistance Program: Confidential support for personal or work-related challenges.
• Hybrid & Remote Flexibility: Work-life balance matters! Enjoy flexibility based on your role.
• Basic life insurance, voluntary life insurance, and long-term disability coverage.
• Dependent Care and Pet Insurance: Covering loved ones, furry or not, with flexible spending accounts and pet insurance.
• Bereavement Paid Time Off: Time to grieve and heal without work worries.
• Sabbatical and Personal Leave Options: Recharge and refocus with time off for personal needs.
• Social Events: Networking and unwinding at virtual and in-office firm social events.