Job description

THIS IS NOT A REMOTE POSITION.

The Business Analyst 1’s primary role is to contribute to organizational improvement by gathering and analyzing data, prepare reporting, and introducing process improvements. The ideal candidate should have a keen ability to determine specifications and standards for business reporting and maintaining data integrity. This position will have a focus on the creation and maintenance of relational databases. This position will report to the Manager of Operations.

Essential Duties and Responsibilities

Database Management:

• Responsible for the day-to-day operation, support, and maintenance of the business systems and their associated databases.
• Integration of ETL processes into the database.
• Identify, troubleshoot, and correct system related issues/areas of improvement.
• Create thorough documentation for all databases and queries.
• Will work directly with the Operations team to provide them required data and reporting.

Validate Data/General Data Handling:

• Acquire data from primary or secondary data sources and structure large data sets to find usable information.
• Creation and documentation of ETL processes for new data sets.
• Review and cleanse unstandardized client data to maintain internal data integrity standards, including validity, accuracy, completeness, and consistency.
• Regular bulk uploads to create and manage data files and databases.
• Manual data entry to resolve issues or make updates.

General Reporting:

• Ability to create complex reporting and dashboards for clients in a manner that is visually appealing and easy to understand.
• Day to day management of excel reporting and analysis for various projects.
• Use cleaned data to create reports and analyses for internal teams and external clients that are well documented and easy to comprehend.
• Assist other teams as needed in writing SQL queries to creating reporting.
• Identify, analyze, and interpret trends or patterns in complex data sets.

Other Duties:

• Assist other teams as needed in preparing or cleaning data or testing data in internal systems.
• As assigned, complete general data analysis duties as needed for specified clients.

Requirements

• Bachelor’s degree or greater preferred. Computer science, analytics, math, economics, or similar field.
• Advanced critical thinking skills.
• 2-5 years experience in SQL and working within a relational database
• Advanced Excel knowledge including Macros, pivot tables, x & v-lookup, and DAX functions.
• Strong ability to analyze, problem solve, and interpret data.

***You will be required to complete a proprietary SQL Database Skills Test on Excel we've created during Round II of our interviewing process.

Job Type: Full-time

Pay: From $85,000.00 per year

Benefits:

• 401(k) matching
• Dental insurance
• Health insurance
• Health savings account
• Paid time off
• Parental leave
• Vision insurance

Compensation package:

• Bonus pay
• Performance bonus

Schedule:

• 8 hour shift

Ability to commute/relocate:

• St. Petersburg, FL 33701: Reliably commute or planning to relocate before starting work (Required)

Application Question(s):

• Are you authorized to work in the United States without needing sponsorship now or in the future?

Experience:

• SQL: 2 years (Required)

Work Location: In person

seankuhnke.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, seankuhnke.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, seankuhnke.com is the ideal place to find your next job.