Business Intelligence Database Developer

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

Benefits offered by this job

Health Insurance

401(k) with Company Matching

Short-Term & Long-Term Disability

Weekly Lunch Stipend

Job summary

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

This role blends database development, data integration, reporting, and cloud data warehousing, working with SQL Server, ETL/ELT, and BI tools to transform complex financial data into actionable insights for the business.

Qualifications

• Bachelor's degree in CS, IT, or 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.
• ETL/ELT processes and data connectors.
• BI/reporting tools experience.
• Knowledge of data warehouse concepts.
• Experience with cloud data technologies.
• Experience with financial transaction or payment data.
• Understanding of PCI DSS requirements.
• Experience in Agile development.

Responsibilities

• 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.

Skills

Data analysis

Data modeling

SQL scripting

Performance tuning

Education

Bachelor's degree in Computer Science or related field

Tools

Microsoft SQL Server

ETL/ELT tools

Power BI / SSRS / Tableau

Cloud data platforms (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.