BI Database Developer

Toccata Inc; Boca Raton (FL); On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Health, Dental & Vision Insurance

401(k) with Company Matching

Short-Term & Long-Term Disability

Weekly Lunch Stipend

Job summary

SegPay is seeking an experienced Business Intelligence Database Developer to enhance our Operations team. This role involves database development, data integration, and reporting, focusing on payment processing systems.

You will collaborate using SQL Server, BI tools, and cloud platforms while ensuring data accuracy and security. You'll thrive in an Agile environment, maintaining key database functions and delivering actionable insights.

Qualifications

• 3-5 years of professional database development or BI experience.
• Strong experience with Microsoft SQL Server.
• Experience developing complex SQL queries and stored procedures.

Responsibilities

• Design and maintain database schemas.
• Develop complex SQL queries, stored procedures, and functions.
• Build and maintain ETL/ELT processes and data integrations.
• Develop reports and dashboards using BI tools.
• Collaborate with DevOps on deployments and production support.

Skills

Database development

SQL Server

ETL/ELT processes

Business Intelligence

Data integration

Reporting tools

Cloud data platforms

Agile development

Financial transaction data

Data security

Education

Bachelor's degree in Computer Science or related field

Tools

SSRS

Power BI

Tableau

Snowflake

BigQuery

Redshift

Job description

Turn complex transaction data into reliable, actionable information.

SegPay is looking for an experienced Business Intelligence (BI) Database Developer to join our Operations team and help design, develop, and maintain the database and business intelligence solutions supporting our payment-processing environment.

This role combines database development, data integration, reporting, and financial transaction data. You'll work with SQL Server, ETL/ELT processes, BI tools, and cloud data platforms while collaborating with Business Analysts, Product Owners, and DevOps.

If you enjoy working with complex data, optimizing performance, and transforming information into solutions the business can use, we'd love to hear from you.

What You'll Do

• Design and maintain database schemas to support business and reporting needs
• Develop complex SQL queries, stored procedures, functions, and triggers
• Build and maintain ETL/ELT processes and data integrations
• Develop reports and dashboards using tools such as SSRS, Power BI, or Tableau
• Work with cloud data warehouse technologies such as Snowflake, BigQuery, or Redshift
• Validate financial transaction data for accuracy and integrity
• Collaborate with DevOps on deployments and production support
• Participate in Agile development processes
• Monitor and improve database performance Troubleshoot production database and reporting issues
• Maintain appropriate data security and integrity controls
• Support documentation and PCI-related requirements

The position combines hands-on database development with BI, data integration, cloud data warehousing, and financial transaction data responsibilities.

What We're Looking For

• Bachelor's degree in Computer Science, Information Systems, or a related field
• 3-5 years of professional database development or BI experience
• Strong experience with Microsoft SQL Server
• Experience developing complex SQL queries, stored procedures, and database objects
• Experience with ETL/ELT processes and data connectors
• Experience with BI/reporting tools
• Knowledge of data warehouse or data lake concepts
• Experience working with cloud data technologies
• Experience with financial transaction or payment-processing data
• Understanding of PCI DSS requirements
• Experience working in an Agile development environment

The Kind of Developer Who Thrives Here

You enjoy getting into the details of data and figuring out how everything connects.

You can build the SQL behind the solution, troubleshoot performance issues, validate the accuracy of financial data, and translate complex datasets into reporting that people can actually use.

You also understand that when you're working with payment and financial transaction data, accuracy, security, and reliability matter.

Benefits & Perks

Our benefits package includes:

• Health, Dental & Vision Insurance
• 401(k) with Company Matching
• Short-Term & Long-Term Disability Insurance
• Weekly Lunch Stipend

Ready to Put Data to Work?

If you're an experienced database developer who enjoys working with SQL, BI, data integration, and financial transaction data, we want to hear from you.