Create Alert

Data Audit Analyst

Apply now »

Date: Oct 3, 2024

Location: Dhaka, BD, 1212 BD

Company: Optimizely

At Optimizely, we're on a mission to help people unlock their digital potential. We do that by reinventing how marketing and product teams work to create and optimize digital experiences across all channels. With Optimizely One, our industry-first operating system for marketers, we offer teams flexibility and choice to build their stack their way with our fully SaaS, fully decoupled, and highly composable solution.   
We are proud to help more than 10,000 businesses, including H&M, PayPal, Zoom, and Toyota, enrich their customer lifetime value, increase revenue and grow their brands. Our innovation and excellence have earned us numerous recognitions as a leader by industry analysts such as Gartner, Forrester, and IDC, reinforcing our role as a trailblazer in MarTech.  
  

At our core, we believe work is about more than just numbers -- it's about the people. Our culture is dynamic and constantly evolving, shaped by every employee, their actions and their stories. With over 1500 Optimizers spread across 12 global locations, our diverse team embodies the "One Optimizely" spirit, emphasizing collaboration and continuous improvement, while fostering a culture where every voice is heard and valued.  
  

Join us and become part of a company that's empowering people to unlock their digital potential! 

Introduction

Optimizely is on the lookout for a Data Analyst who is deeply committed to maintaining high standards of data quality and has a keen eye for detail in audit reconciliation.  This role is a crucial part of our FP&A Team.  The ideal candidate will be proficient in Python and SQL, ensuring the reliability and precision of our financial and customer datasets.  Your role will involve collaborative efforts across various teams to facilitate our monthly and quarterly financial data reporting, which is pivotal for our strategic decision-making and adherence to compliance standards within our SaaS framework.  You’ll be instrumental in establishing the core data that will drive our advanced forecasting methodologies, ultimately leading to more precise budgeting and financial projections.

Job Responsibilities

  • Develop and refine automated reconciliation processes for tracking subscriptions, bookings, and order values across various systems like Salesforce, NetSuite, and the Data Warehouse.  Your role involves using Python and SQL to create scripts that automatically identify and rectify any inconsistencies across these platforms, ensuring data integrity.  This automation is key to streamlining audit procedures and bolstering the quality of data management, which supports the accuracy of financial reporting by providing reliable data analysis
  • Your role will be to ensure that the Annual Recurring Revenue (ARR) audit is completed efficiently and on schedule. This involves verifying that all necessary tasks are finished within the set audit timeframe. You’ll aim for perfect data quality, proactively identifying and resolving any data inconsistencies found during the audit, and documenting the corrective actions taken
  • Collaborate closely with key stakeholders from Go-to-Market (GTM), Order Management, Customer Success, and Data Services teams to ensure a thorough audit process. You’ll be actively involved in discussions with business stakeholders to address and reconcile discrepancies in customer data, aiming to reach a consensus on the accurate status of each case
  • Your technical task will be to architect and construct Snowflake database tables that will act as the core infrastructure for Financial Planning & Analysis (FP&A) operations. These tables will be centered around managing and analyzing data related to Billings, Revenue, ARR, and Deferred Revenue schedules, and they should be tailored for complex queries and analytics, which are standard in financial forecasting and reporting.

Key qualifications for this role include:

  • A solid grasp of audit reconciliation procedures and financial data management.
  • Advanced skills in Python and SQL for process automation and data analysis.
  • Knowledge of Snowflake and DBT.
  • Experience with financial systems such as Salesforce, NetSuite, and Data Warehouses.
  • Proficiency with PowerBI and Excel for data reporting and visualization.
  • Exceptional communication abilities, both in writing and speaking, with the capacity to manage deadlines effectively and collaborate across different functions.
  • Initiative and the ability to independently drive tasks to completion with minimal oversight.

Education

  • A Bachelor’s degree in Computer Science, Finance, Accounting, Data Science, or a related field, or an equivalent level of work experience.

Our new, cutting-edge office space in Dhaka is a testament to our dedication to enhancing your work experience. This state-of-the-art workspace features open workstations, a fully equipped kitchen, a nap room for relaxation, a tranquil zen garden, and an entertaining area, all designed to provide you with the ideal environment to thrive and grow.  

   

As part of our commitment to you, here are other benefits and perks you can expect:   

    

  • Best-in-class compensation plans   

  • Two annual festival bonuses   

  • Recognition and rewards programs   

  • Paid Maternity (4 months) & Paternity Leave (12 weeks)   

  • Flexible vacations days and working hours   

  • Annual Work/Service Anniversary Leave   

  • Comprehensive medical & life insurance for you and your dependants  

  • Volunteering opportunities to make a difference   

  • Chance to work alongside our incredible global team   

  • Monthly and quarterly regional and global team-building events   

  • Communal transport facilities inside Dhaka to and from the office   

  • Free catered lunch every day    

  • An agile performance review process that encourages ongoing transparency between managers and direct reports   

  • Enablement program and soft skill training to support internal career growth and development    

  
At Optimizely, our standardized language is English, and it is crucial to have good English communication skills to be successful in your global role. All our external and cross-location communication is done in US English (en-us), but internally you can speak in whichever native language you most identify with. 


Optimizely is committed to a diverse and inclusive workplace. Optimizely is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status.