Data Analyst
Role Overview
The role seeks a SQL expert who understands accounting and financial systems and enjoys working with people.
This is a client-facing position requiring clear communication of technical information and practical solutions.
Work primarily involves Oracle databases, PL/SQL, reporting tools, and business applications.
Key Skills for This Role
Full Job Posting
About the Company
100X is a Miami-based managed IT services and software development firm established in 2009.
The company provides IT services, custom software development, and business process automation.
The Role
The role seeks a SQL expert who understands accounting and financial systems and enjoys working with people.
This is a client-facing position requiring clear communication of technical information and practical solutions.
Work primarily involves Oracle databases, PL/SQL, reporting tools, and business applications.
Key Responsibilities
- Develop, troubleshoot, and optimize complex SQL and Oracle PL/SQL queries, stored procedures, functions, and triggers.
- Analyze financial, accounting, and operational data in Oracle-based ERP and line-of-business systems.
- Develop and maintain reports and dashboards using Crystal Reports, Power BI, and other reporting tools.
- Work with general ledger, accounts receivable, accounts payable, and related business processes.
- Perform database extractions, data transformations, migrations, and reconciliations while maintaining data accuracy and integrity.
- Work directly with clients to understand business requirements, investigate issues, and develop data solutions.
- Troubleshoot database, reporting, and application issues, identify root causes, and implement lasting solutions.
- Document queries, processes, and technical solutions and communicate findings to technical and nontechnical audiences.
Required Qualifications
- Strong SQL proficiency for writing, debugging, and optimizing complex queries; hands-on Oracle PL/SQL experience is essential.
- Practical experience with accounting, financial reporting, ERP systems, or financial data; understanding of accounting concepts and transaction flows.
- Solid knowledge of relational databases, data structures, joins, stored procedures, database design, and query performance optimization.
- Strong interpersonal skills and ability to communicate directly with clients.
- Ability to investigate data issues, identify discrepancies, and develop accurate, efficient solutions.
- Ability to explain technical findings to nontechnical users and translate business requirements into technical solutions.
- Organized, detail-oriented, self-directed, and able to manage priorities independently while collaborating with a team.
Preferred Qualifications
- Experience with Oracle-based ERP or financial management systems.
- Experience with Crystal Reports and Power BI.
- Familiarity with financial reporting, data reconciliation, and accounting workflows.
- Experience with data integrations, ETL processes, SSIS, or database migrations.
- Familiarity with PowerApps, SharePoint, Azure, or related business technologies.
- Experience with C#, .NET, Python, or other programming languages.
- A degree in Computer Science, Information Systems, Accounting, Finance, or a related field.
Location and Employment Requirements
- This hybrid-remote position supports clients in the Miami area; occasional onsite client visits are required.
- Applicants must currently reside in Florida; Miami-Dade, Broward, and Palm Beach County candidates are strongly preferred.
- The description states that candidates must be able to travel to, but the sentence is truncated in the source.
Benefits
- The company advertises paid time off and holidays, health insurance, professional development, industry events, and team outings.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career