Data Analyst I

MIDFLORIDA Credit Union; Lakeland (FL); Vor Ort; USD 55.000 - 85.000; Vollzeit

Benefits dieser Stelle

Stability

Growth opportunities

Paid time off

401K with employer matching

Health, Dental, Vision insurance

Telehealth

Employee Assistance Program

Bonus programs

Zusammenfassung

MIDFLORIDA Credit Union in Lakeland, FL is seeking a Data Analyst to turn data into actionable insights. You will pull, validate, and model data from MSSQL and Oracle sources, build queries, and deliver timely reports to business units to support performance, compliance, and strategy.

Collaborate with owners and SMEs, manage ETL issues, and test datasets with tools like SAP Web Intelligence, SSRS, Tableau, and Web Intelligence.

Qualifikationen

• 2-3 years of experience in SQL programming, data transformation, and database reporting using reporting tools such as SAP Web Intelligence, Microsoft SSRS, or Tableau
• 4 year college degree with major in Data Analytics, Information Systems, Computer Science, or other related field (or equivalent experience)
• Experience using SQL Server Management Studio and Oracle SQL Developer
• Ability to write complex queries using Oracle and Microsoft SQL Server, including multi-table joins, CTEs, and analytical functions
• Understanding of relational database design and dimensional data models
• Experience with version control tools such as Git
• Ability to collaborate with both technical and business staff
• Ability to present information and relevant summaries to all levels of the organization
• Experience using Visual Studio/SSIS preferred but not required
• Previous financial services experience desired but not required

Aufgaben

• Deliver high quality, complex, and timely reports to all business units across the organization
• Work with business owners and SMEs on data requirements and validation
• Build queries to extract and transform data with Oracle SQL Developer and MS SQL Server Management Studio
• Create and test datasets and reports using Business Objects Web Intelligence
• Validate data, procedures, and processes with stakeholders
• Troubleshoot SSIS and other ETL related problems
• Manage code changes using version control and participate in peer code reviews
• Manage a pipeline of open requests and deliver results on time
• Assist with projects that include a data or reporting component

Kenntnisse

SQL

Data transformation

Data reporting

Complex SQL queries

Analytical thinking

Communication

Ausbildung

Bachelor's degree in Data Analytics/IS/CS

Tools

SQL Server Management Studio

Oracle SQL Developer

Git

SSIS

Tableau

Web Intelligence

Jobbeschreibung

# Data Analyst ILakeland, FL 33801## OverviewPosition TypeFull Time## DescriptionWhy have a job when you can build a career? We are proud to be defined by the excellent service and convenience offered to our members, as well as our diverse workforce and company culture. There are many reasons to work for MIDFLORIDA, which is probably why we were voted one of Florida Trend's \"Best Places to Work.\" MIDFLORIDA offers a positive team culture, an open-door management style, a commitment to diversity, stability, competitive benefits, and a career path with a growing, successful company! Join us in our mission to improve the financial well-being of our members! MIDFLORIDA Credit Union is looking for a data-driven problem solver that can discover, manipulate, and extract information from multiple MSSQL and Oracle data sources. The Data Analyst is responsible for delivering high quality, complex, and timely reports to all business units across the organization to support a wide range of initiatives, including performance improvement activities, compliance, regulatory reporting, and organizational strategies. As a Data Analyst, you will work with business owners and subject matter experts on data requirements and validation, building queries to extract and transform data with Oracle SQL Developer and Microsoft SQL Server Management Studio, and creating and testing datasets and reports using Business Objects Web Intelligence. The Data Analyst will enable management to make sound business decisions informed by accurate and reliable information. Additional duties include:* Working collaboratively to validate data, procedures, and processes* Performing problem determination and resolution for SSIS and other ETL related problems* Managing code changes using version control and participating in peer code reviews* Managing a pipeline of open requests and delivering results on time* Assisting with any projects that include a data or reporting component## QualificationsQualifications include:* 2-3 years of experience in SQL programming, data transformation, and database reporting using reporting tools such as SAP Web Intelligence, Microsoft SSRS, or Tableau* 4 year college degree with major in Data Analytics, Information Systems, Computer Science, or other related field (or equivalent experience)* Experience using SQL Server Management Studio and Oracle SQL Developer* Ability to write complex queries using Oracle and Microsoft SQL Server, including multi-table joins, CTEs, and analytical functions* Understanding of relational database design and dimensional data models* Experience with version control tools such as Git* Ability to collaborate with both technical and business staff* Ability to present information and relevant summaries to all levels of the organization* Experience using Visual Studio/SSIS preferred but not required* Previous financial services experience desired but not requiredMIDFLORIDA Perks:* Stability* Opportunity for growth* Paid time off* 401K Plan with employer matching* Health, Dental, and Vision Insurance - Telehealth plans for employees and family; Dental & Vision plans for employee only* Employee Assistance Program - No waiting period to access benefits.* Salary and Bonuses – Bonus programs and annual appraisals with salary increase opportunities.This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9.