SQL Data Analyst

Oscillas Technologies Inc.; Chicago (IL); Remote; USD 70,000 - 90,000; Full time

Job summary

A rapidly advancing software consulting firm based in Chicago is seeking an experienced SQL-focused Data Analyst / Developer for immediate contract engagement, transitioning to full-time. The successful candidate will handle complex SQL querying, data integration tasks, and data analysis, while collaborating with internal teams on enhanced methodologies.

Qualifications

• Proven mastery of SQL querying and optimization, especially PostgreSQL and SQL Server.
• Strong analytical problem-solving skills with the ability to work independently.
• Familiarity with at least one scripting language, particularly Python.

Responsibilities

• Develop and maintain complex SQL queries for client reporting and analytics.
• Diagnose and resolve performance issues related to data integrity.
• Collaborate with internal teams on project requirements and data quality.

Skills

SQL querying

Query optimization

Relational data modeling

Analytical problem-solving

Data analysis

Troubleshooting

Python

Tools

PostgreSQL

SQL Server

Amazon Web Services (AWS)

Job description

About Oscillas:

We are a rapidly growing software consulting firm based in Chicago, specializing in custom data analytics and automation solutions primarily for industrial/manufacturing firms, as well as a wide array of other clients. Our flagship software, Artemis Cloud, connects seamlessly to client ERP, accounting, payroll, and other core business systems, delivering unified insights, automation capabilities, and advanced analytical reporting.

Position Overview:

We seek an experienced, independent, and motivatedSQL-focused Data Analyst / Developer to immediately join our team on a contract basis, with the opportunity for full-time employment thereafter. The ideal candidate will confidently spearhead complexSQLquerying and analytical responsibilities, requiring minimal oversight. Our current project demand is unprecedented, so your expertise and quick adaptation are essential.

Engagement Type:

• Initial contract engagement with opportunity to move to a full-time role contingent upon performance and company growth.

Responsibilities:

• Develop, optimize, and maintain complexSQLqueries for client reporting, analytics, and data integration tasks.
• Extract, transform, and analyze data primarily using PostgreSQL,SQLServer, and other relational database systems.
• Independently diagnose and resolve performance or quality issues relating to data integrity, consistency, and speed.
• Work collaboratively with internal teams on project requirements, data quality initiatives, and analytical deliverables.
• Assist in refining and expanding our data integration and analytical methodologies.

Location:

• Remote position with preference for candidates in Chicago or surrounding regions.

We have an immediate need and look forward to quickly integrating a strong, self-sufficientSQL-focused data analyst into our growing team. If stepping into exciting challenges in data analytics and integration fits your expertise, we invite you to apply!

Required Qualifications:

• Proven mastery ofSQLquerying, query optimization, and relational data modeling (particularly PostgreSQL andSQLServer).
• Strong analytical problem-solving and troubleshooting skills.
• Proven ability to deliver high-quality work rapidly and independently.
• Familiarity with at least one scripting language, especially Python, for data analysis or ETL purposes.
• Practical understanding of cloud deployments, preferably within Amazon Web Services (AWS).

Preferred Skills (Bonus):

Familiarity or experience with at least some of the following technologies/tools:

• ERP systems, specifically SAP, NetSuite, or similar platforms.
• Additional database technologies, including MySQL and MariaDB.
• PHP frameworks (Laravel, Laravel Nova).
• CI/CD processes and platforms (GitHub, GitHub Actions).
• Monitoring and analytical platforms (Apache Superset, Prometheus, Sentry).
• Prior experience handling sensitive payroll, financial, and accounting data is highly advantageous.