Data Analyst, SQL Reporting Specialist

Posted 16 Days Ago
India
Mid level
Software
The Role
The SQL Reporting Specialist will deliver accurate data reports and analyses to support various business units. Responsibilities include building and maintaining SQL queries, conducting variance analysis, optimizing Denodo queries, and collaborating with departments to manage data across systems. The ideal candidate will have a strong SQL background and experience in data reporting and ETL processes.
Summary Generated by Built In
Why Choose Bottomline?

Are you ready to transform the way businesses pay and get paid? Bottomline is a global leader in business payments and cash management, with over 30 years of experience and moving more than $10 trillion in payments annually. We're looking for passionate individuals to join our team and help drive impactful results for our customers. If you're dedicated to delighting customers and promoting growth and innovation - we want you on our team!

Job Title: SQL Reporting Specialist 
Location: India (Hybrid) 
Company: Bottomline Technologies 
Type: Full-time 

About Bottomline 
Bottomline is at the forefront of digital transformation. We are a global market leader in how businesses pay and get paid, committed to delighting our customers. Our culture thrives on collaboration, ownership, and innovation, empowering our teams to grow their businesses and win in the markets. 

We are looking for an experienced SQL Reporting Specialist to join our dynamic and fast-paced Paymode Revenue Operations team. This role focuses on delivering accurate, actionable data reports and analyses that empower various business units across the organization. The ideal candidate is a SQL expert with a deep understanding of data analysis, data standardization and aggregation, and ETL pipelines and is comfortable creating and maintaining clear and concise technical documentation. 

Key Responsibilities: 

  • Build, maintain, and troubleshoot SQL queries for data extraction and reporting. 
  • Provide one-off data reporting pulls for ad-hoc analysis and source system data  
  • Conduct regular variance analysis between source systems and reporting layers. 
  • Maintain and optimize Denodo server queries and diagnose timeout errors, working with data engineering teams to mitigate risk and optimize performance. 
  • Support report and KPI refreshes on both regular and ad-hoc cadences 
  • Collaborate with various departments (Salesforce, IT) to update and manage business-critical data across systems including Salesforce, Paymode, and our custom internal CRM, ROC.  

Qualifications: 

  • 4+ years Proven experience in SQL development and data reporting, ideally within a financial or technical environment. 
  • Strong understanding of SQL performance optimization techniques. 
  • Experience with Salesforce data management is a plus. 
  • Experience building standardized data views and ETL pipelines for Power BI consumption 
  • Experience with Denodo or other data virtualization tools is a plus. 
  • Ability to manage security protocols within Power BI, including row-level security and permissions. 
  • Experience with Oracle and Postgres is a plus. 
  • Ability to create and maintain clear, concise, and accurate technical and functional documentation 
  • Ability to troubleshoot and diagnose server errors and timeout issues. 
  • Excellent communication and collaboration skills across cross-functional teams. 
  • Ability to manage multiple tasks in a fast-paced environment, including ad-hoc projects. 

 

We welcome talent at all career stages and are dedicated to understanding and supporting additional needs. We're proud to be an equal opportunity employer, committed to creating an inclusive and open environment for everyone.

Top Skills

Denodo
Oracle
Postgres
Power BI
Salesforce
SQL
The Company
HQ: Portsmouth, NH
5,395 Employees
On-site Workplace
Year Founded: 1989

What We Do

Bottomline (NASDAQ: EPAY) makes complex business payments simple, smart, and secure.

Corporations and banks rely on Bottomline for domestic and international payments, efficient cash management, automated workflows for payment processing and bill review, and state of the art fraud detection, behavioral analytics and regulatory compliance solutions. Thousands of corporations around the world benefit from Bottomline solutions.

Headquartered in Portsmouth, NH, Bottomline delights customers through offices across the U.S., Europe, and Asia-Pacific.

Jobs at Similar Companies

Emerge Logo Emerge

IT Compliance Analyst (Tarrytown, NY)

Logistics • Productivity • Software • Transportation • Business Intelligence
Tarrytown, NY, USA
200 Employees

Cove Logo Cove

Software Architect

Mobile • Productivity • Real Estate • Software
Remote
United States
39 Employees

Merge Logo Merge

Sr. Business Analyst (Adobe Workfront)

Edtech • Hardware • Information Technology • Mobile • Virtual Reality
Atlanta, GA, USA
29 Employees

Merge Logo Merge

Sr. Business Analyst (Adobe Workfront)

Edtech • Hardware • Information Technology • Mobile • Virtual Reality
Chicago, IL, USA
29 Employees

Similar Companies Hiring

CSC Thumbnail
Software • Legal Tech • Fintech • Financial Services • Data Privacy • Cybersecurity
Wilmington, DE
8000 Employees
FourKites Thumbnail
Transportation • Software • Logistics • Big Data • Artificial Intelligence
Chicago, IL
550 Employees
Toast Thumbnail
Software • Information Technology • Hospitality • Food • Fintech • Cloud
Boston, MA
4500 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account