Technical Data Analyst or Jr. Data Scientist

Open Systems Technologies; Tampa (FL); On-site; USD 120,000 - 180,000; Full time

Job summary

Open Systems Technologies in Tampa is seeking a Senior Data Developer to bridge business and technology, delivering high quality insights from large financial datasets. You will drive data warehousing, analytics development, and adoption of AI tools in data projects.

The ideal candidate has hands-on Oracle SQL, Python, and data visualization experience, with leadership skills to mentor others and communicate findings to executives.

Qualifications

• 8-10 years of hands-on experience as Senior Data Developer or Analytics Lead.
• Expertise designing and maintaining Oracle PL/SQL queries.
• Expertise in Python programming.
• Strong relational database understanding and data profiling experience.
• Experience mentoring other data analysts and leading teams.

Responsibilities

• Analyze complex financial data and provide actionable insights to finance, risk and operations.
• Write and optimize complex SQL queries for data extraction and reporting.
• Develop stored procedures, triggers and functions in Oracle to automate data processes.
• Design and implement reporting solutions using SQL, Python and visualization tools.
• Automate manual tasks and develop data reconciliation and data quality checks.
• Collaborate with business and technology teams to define system scope and enhancements.
• Act as SME to senior stakeholders and guide communication of data solutions.

Skills

Oracle SQL

Performance queries

Python

AI/ML experience

Data modeling

Data analysis

Stakeholder communication

Education

Bachelor’s degree in business, Finance, Data Science or Analytics, Statistics, Engineering

Tools

Oracle PL/SQL

Tableau

Power BI

Job description

• Technical Data Analyst or Jr. Data Scientist
• Not seeking a BA since this is a technical role
• Advanced Oracle SQL skills required
• Must understand data model and vast data sets (billions of records in the table)
• Must know how to write performance-effective queries
• Python coding required
• AI experience - must know how to ask AI to how do complete a task
• Prior candidates have not had advanced querying or database skills so far

The Senior Data Developer is a senior-level position responsible for liaising between business users and technologists to exchange information in a concise, logical and understandable way in coordination with the Technology team. The ideal candidate will have hands-on experience in data warehousing and data analytics development, combined with a deep understanding of financial data and complex data scenarios. This role requires a combination of technical, functional, analytical and problem-solving skills to deliver high quality insights and support business decisions. Candidate will also be responsible for researching and evaluating emerging AI tools and techniques for potential application in data analysis projects.

Core Responsibilities

• Data analysis & Reporting
  • Analyze complex financial data, identify trends, patterns, anomalies to provide actionable insights to business units such as finance, risk and operations.
  • Write and optimize complex SQL queries for data extraction, reporting, analysis.
  • Develop stored procedure, triggers and functions in Oracle to automate datarelated processes.
  • Design and implement reporting solutions, utilizing SQL, scripting language (Python) and other data analytical tools to deliver meaningful and accurate data visualizations.
• Development & Automation
  • Leveraging programming languages(Python etc) to automate manual tasks, develop data reconciliation and data quality checks.
  • Develop data analytical reports/dashboards based on business requirement.
• Problem Solving & Troubleshooting
  • Address and resolve complex data-related issues, ensuring data integrity and accuracy.
  • Hunt for the right solutions – collaborate with team members, technology partners, and business partners to identify efficient and strategic solutions.
  • Communicate technical solutions and findings to both technical and non-technical stakeholders, ensuring clear understanding of application functions and financial data.
• Provide inputs during development and implementation phases, including formulation and definition of systems scope, objectives and necessary system enhancements for complex, high-impact projects
• Own the resolution of issues – manage multiple program sub-streams and aid in developing technology solutions based off analysis,
• Be organized and timely – have a strong appreciation for regulatory deadlines and be organized enough to manage multiple responsibilities at once,
• Be a change agent – review existing processes critically to identify inefficiencies and automation solutions,
• Communicate effectively – author artifacts such as architectural proposals and technical solutions, guide to navigate thru complex data issue, and communication materials for senior management and key business partners.
• Acts as SME to senior stakeholders and /or other team members.

Qualifications

• 8-10 years of relevant hands-on work experience as Senior Data Developer or Data Analytics Lead.
• Expertise in designing and maintaining Oracle PL/SQL queries
• Expertise in Python programming
• Strong understanding of relational databases
• Experience performing in-depth data analysis and data profiling activities
• Experience mentoring/leading other data analysts
• Strong interpersonal skills and techniques to solve dynamic problems; excellent teamwork skills
• Must have excellent written and verbal communication skills, along with strong consulting skills
• Experience identifying and implementing process improvement
• Solid skills effectively managing multiple small to large projects simultaneously in a cross-functional environment
• Awareness and understanding of AI/ML tools and techniques in data analytics (e.g., machine learning algorithms, natural language processing, predictive modeling).
• Practical experience applying AI/ML techniques in data analysis projects is a plus
• Exposure data visualization tools: Tableau, Power BI, etc (nice to have)

Education

• Bachelor’s degree in business, Finance, Data Science or Analytics, Statistics, Engineering, or other similar degrees.