Finance Analyst

Financeroles; United States; Remote; USD 70,000 - 110,000; Full time

Job summary

CEO Lawyer is seeking a Financial Analyst / Power BI Specialist to join its finance and operations team. You will develop dashboards, perform financial reporting, and model data to support strategic decisions in a fast-paced, remote environment.

The role requires 4+ years in financial analysis or BI, strong Power BI and Excel skills, SQL proficiency, and the ability to work independently while collaborating with cross-functional teams across the organization.

Qualifications

• 4+ years of experience in Financial Analysis, BI, or Data Analytics.
• Proven Power BI dashboard development experience.
• Strong Excel skills with pivot tables and data modeling.
• Strong SQL skills and experience with relational databases.
• Coding skills (Python, SQL, VBA, R) are a plus.
• Excellent communication and organizational skills.
• Ability to work independently and manage multiple tasks.

Responsibilities

• Develop and maintain Power BI dashboards to visualize financial and operational data.
• Perform advanced Excel modeling and analysis to support decision-making.
• Gather, transform, and analyze data from multiple sources.
• Design and maintain data models to ensure reporting accuracy and consistency.
• Write and optimize SQL queries to extract, manipulate, and validate data.
• Support automation of reporting processes and operational analytics.
• Ensure accuracy and consistency in financial and operational reporting.
• Collaborate with cross-functional teams to gather and validate data.
• Provide insights and recommendations based on financial and operational analysis.
• Maintain data integrity across reporting systems and databases.

Skills

Power BI

Excel modeling

SQL

Coding (Python/SQL)

Data analysis

Communication

Job description

CEO Lawyer

The CEO Lawyer Personal Injury Law Firm is dedicated to educating, empowering, and fighting for victims. With offices across the country, no matter where you are injured, our team of experienced lawyers is here to help you.

CEO Lawyer is a rapidly growing personal injury law firm headquartered in downtown Atlanta. We are known for our innovative approach to legal services and our commitment to operational excellence.

As we expand, we are seeking a detail-oriented and analytical Financial Analyst / Power BI Specialist to support our finance and operations team. This role will assist with dashboard development, financial reporting, and data modeling, while also taking on operational tasks.

Our Core Values

We are guided by a strong set of values that shape our culture, decisions, and the way we work together:

• Trust – We build strong relationships through honesty, transparency, and reliability.
• Humility – We stay open to learning, feedback, and continuous improvement.
• Ethics – We act with integrity and always do what’s right.
• Hunger – We are driven, ambitious, and committed to excellence.
• Education – We value growth, development, and knowledge-sharing.
• Accountability – We take ownership of our actions and deliver on our commitments.
• Respect – We treat everyone with professionalism, empathy, and fairness.
• Teamwork – We collaborate and support each other to achieve shared success.

Key Responsibilities

• Develop and maintain Power BI dashboards to visualize financial and operational data
• Perform advanced Excel modeling and analysis to support decision-making
• Gather, transform, and analyze data from multiple sources
• Design and maintain data models to ensure reporting accuracy and consistency
• Write and optimize SQL queries to extract, manipulate, and validate data
• Support automation of reporting processes and operational analytics
• Ensure accuracy and consistency in financial and operational reporting
• Collaborate with cross-functional teams to gather and validate data
• Provide insights and recommendations based on financial and operational analysis
• Maintain data integrity across reporting systems and databases

Required Qualifications

• 4+ years of experience in Financial Analysis, Business Intelligence, Data Analytics, or a related field
• Proven experience with Power BI dashboard development
• Strong proficiency in Microsoft Excel, including pivot tables, formulas, and data modeling
• Strong SQL skills and experience working with relational databases are a plus.
• Experience with database management and data analysis
• Coding skills (Python, SQL, VBA, R, or similar analytical/programming languages) are a plus.
• Ability to perform mathematical and quantitative analysis with attention to detail
• Excellent communication and organizational skills
• Ability to work independently and manage multiple tasks

Preferred Attributes

• Proactive and self-motivated
• Comfortable working in a fast-paced, remote environment
• Eager to learn and take on new challenges
• Strong problem-solving skills and analytical mindset