Finance Analyst

CEO Lawyer Personal Injury Law Firm; Colombia; A distancia; COP 60.000.000 - 100.000.000; Jornada completa

Descripción de la vacante

CEO Lawyer Personal Injury Law Firm is seeking a detail-oriented Financial Analyst / Power BI Specialist to join our finance and operations team. The role emphasizes dashboard development, financial reporting, and data modeling within a fast-paced, remote environment.

You will gather data from multiple sources, build scalable data models, and deliver actionable insights to drive strategic decisions. Ideal candidates have 4+ years of analytics experience, strong Power BI, Excel, and SQL skills,

Formación

• 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

Responsabilidades

• 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

Conocimientos

Power BI dashboard development

Advanced Excel

SQL skills

Data analysis

Coding (Python, VBA, R)

Data modeling

Attention to detail

Communication

Herramientas

Power BI

SQL

Python

Descripción del empleo

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

• 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