Business Data Analyst

AI overview

Design and optimize SQL applications within the accounting domain, collaborating cross-functionally to enhance data solutions and ensure compliance with financial standards.

Hi there :)

Thanks for checking in to find out about our open position. We´ll provide as much information as possible, but please feel free to reach us if you have further questions. We´ll be happy to see your application, even if there are skills you don't quite master!

About Us

We engage top-performing Software Developers and Data Analysts from Latin America to join our clients' teams worldwide. We build amazing products and sustain long-term relationships with our counterparts. We pride ourselves on being a socially responsible company. The results are seen in the performance of our teams and the bond we hold with each of our clients.

About the Client

Our client is a leading financial services company in the United States, specializing in providing comprehensive accounting and data-driven solutions to streamline business processes. Their innovative approach to automating financial transactions enables greater accuracy, efficiency, and compliance for their partners.

About the Role

We are seeking a seasoned Business Data Analyst to join our team and will be responsible for designing, developing, maintaining, and optimizing SQL, pipelines, databases, and related applications within the accounting domain. This role will collaborate cross-functionally with stakeholders and team members to analyze requirements, suggest process methodologies, and deliver scalable and high-performing data solutions.

Key Responsibilities

  • Translate accounting policies (e.g., ASC 606, AP/AR flows) into detailed data requirements to support journal entry automation via the Revenue Subledger and similar systems.

  • Build accounting data models and schemas that support revenue recognition and subledger automation, ensuring compliance with US GAAP (ASC 606) and internal control requirements.

  • Implement data models and schemas to support business requirements and ensure data consistency and integrity.

  • Write and optimize complex SQL queries, stored procedures, and views for data extraction, transformation, loading, and reporting.

  • Develop and maintain ETL pipelines to ensure efficient and reliable data flow between systems.

  • Collaborate with analysts and stakeholders to understand data needs and provide data engineering support for analytics initiatives.

  • Ensure data quality, validation, and cleansing to maintain accuracy and reliability.

  • Troubleshoot and resolve data-related issues, ensuring data accuracy and availability.

  • Create and maintain technical documentation, including data flow diagrams, data dictionaries, and process documentation.

What You Need to Succeed in This Role

  • Strong knowledge of SQL, with experience writing and optimizing complex queries, stored procedures, and views.

  • Proven experience using Python and working with JSON files for data transformation and integration.

  • Hands-on experience in ETL development, including building, maintaining, and optimizing data pipelines.

  • Solid background in data modeling and analysis based on business requirements.

  • Professional experience in the Financial Accounting and Reporting domain and/or regulated industries.

  • Familiarity with journal entry automation and subledger systems within accounting workflows.

  • Deep understanding of accounting principles and standards (US GAAP, ASC 606); certifications in GAAP or IFRS are a plus.

  • Proficiency in Snowflake development tools and architecture is a plus.

  • Knowledge of data warehousing concepts and dimensional data modeling is a plus.

  • Strong customer-facing, problem-solving, and analytical skills.

  • Excellent communication skills and the ability to collaborate cross-functionally.

  • Bachelor’s degree in Accounting, Economics, Business Administration, Information Systems, or a related field.

  • Availability to work aligned with Pacific Time (UTC -8 or -7).

Our Team

We strive to create an inspiring and growth-oriented environment where everyone feels valued, heard, and empowered. We promote both personal and professional development, with individualized support for your needs and concerns. We aim to build a space where everyone can thrive.

What We Offer

  • Long-term projects

  • 100% remote work

  • Payment in USD

  • Paid Time Off (PTO)

  • Work from Home (WFH) & Training reimbursement

  • English lessons

  • Technical training

  • Career coaching

Note: This position is available for candidates based in LATAM.

Perks & Benefits Extracted with AI

  • Home Office Stipend: Work from Home (WFH) & Training reimbursement
  • Other Benefit: Career coaching
  • Paid Time Off: Paid Time Off (PTO)
Get hired quicker

Be the first to apply. Receive an email whenever similar jobs are posted.

Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Data Analyst Q&A's
Report this job
Apply for this job