Junior Data Analyst

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 is responsible for supporting the Data Analytics department with external client engagements and consulting with internal practice groups.

Supervisory Responsibilities:

• None

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.
• Develop and/or automate processes to maximize firm-wide efficiency using tools such as VBA, IDEAScript, Python, SQL, ensuring consistency and reliability.
• Retrieve, organize, and interpret data from databases to create clear and actionable reports.
• Respond to questions from upper management and clients with detailed analyses and insights.
• Identify potential strategies to address issues uncovered during data analysis and provide well-reasoned suggestions for improvement.
• Stay current on best practices and emerging trends in data storage, management, and analytics to ensure the firm utilizes state-of-the-art solutions.
• Participate in the planning, execution, and monitoring of data-driven projects, ensuring timely and successful completion.
• Work closely with team members, clients, and other stakeholders to support data-related initiatives and provide actionable recommendations.
• Make photocopies; mail, scan, and email documents; and perform other clerical functions.
• Perform other related duties and projects as assigned.

Education and Experience:

Required:

• Bachelor’s degree in Accounting, Finance, Economics, Mathematics, Computer Science, or Quantitative Analysis.

Preferred:

• Coding and programming skills (VBA, IDEAScript, Python, SQL, DAX).
• Experience with Microsoft Excel (formulas, pivots, power query, power pivot).
• Experience with visualization software such as Power BI or Tableau.
• Good understanding of statistical methods (linear Regression, logistic Regression).

Physical Requirements:

• Must be able to lift up to 15 pounds at times.
• Prolonged periods of sitting at a desk and working on a computer.

Benefits

LIFE:

• Competitive Salary: We value your dedication and hard work. We offer a competitive salary of $65,000 per year for this role.
• Generous Paid Time Off: Start with 20 days and watch it grow, plus 2 extra days annually for managers.
• Comprehensive Healthcare: 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.

FAMILY:

• Hybrid & Remote Flexibility: Work-life balance matters! Enjoy flexibility based on your role.
• Insurance Benefits: 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.

BUSINESS:

• Social Events: Networking and unwinding at virtual and in-office firm social events.
• Referral Bonuses: Earn rewards for growing our team and client base.
• Commuter Benefits: Funds for transit and parking to ease your daily commute.
• Professional Development: Reimbursement for licenses, memberships, CPE allowance, and access to classes through Becker.

DREAMS:

• Retirement Plans: Tailored 401(k) Profit Sharing Plan for your financial future.
• Support for Professional Certifications: Assistance on your journey to CPA or CFE, including study materials, exam reimbursements, and bonuses.
• Leadership Development and Mentorship: Personal and professional growth through mentorship programs.

Ready to embark on a fulfilling career journey with us? Join our team and unlock a world of opportunities and support!

Miller Kaplan does not intend to hire job seekers who will need, now or in the future, Miller Kaplan sponsorship through the H-1B lottery, unless otherwise stated on the job posting.

All qualified applicants will receive consideration for employment at Miller Kaplan without regard to race, religious creed, color, ancestry, national origin, sex, gender (including gender identity and gender expression), age, mental or physical disability, medical condition, genetic information, sexual orientation, marital status, reproductive health decisions, military/veteran status, or any other legally protected status in accordance with state and/or federal law.

Miller Kaplan does not accept unsolicited candidates, referrals, or resumes from any staffing agency, recruiting service, sourcing entity, or third-party paid service at any time. Any referrals, resumes, or candidates submitted to Miller Kaplan or any employee or owner of Miller Kaplan without a pre-existing agreement signed by both parties covering the submission will be considered the property of Miller Kaplan and not subject to any fees or charges. For existing agreements, a role must be approved and open to external search; otherwise, unsolicited and unapproved submittals and referrals will be considered Miller Kaplan property and free of fees. If you would like to inquire about referrals and or contracts, please reach out to careers@millerkaplan.com.

All qualified applicants will receive consideration for employment at Miller Kaplan in accordance with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance regarding applicants with criminal histories and the SF Fair Chance Ordinance regarding applicants with arrest and conviction records.