ShiftCode Analytics, Inc. · 2 days ago

SQL Developer (Data Analyst/Report Writer)

Austin, TX

Full-time

Hybrid

Entry, Mid Level

1+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

AnalyticsConsulting

Actively Hiring

Insider Connection @ShiftCode Analytics, Inc.

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Writing SQL reports that access data stored in databases such as SQL Server, DB2, and Oracle.

Developing procedures and views on SQL Server and Oracle databases.

Using dynamic grouping fields, dynamic group sorting, on-demand sub reports, drill down and summary reports, and creating crosstab reports highlighting key summary information.

Manipulating large data sets through statistical software or other methods.

Functional expertise developing front-end reporting solutions.

Manipulating large data sets through statistical software or other methods.

Developing front-end reporting solutions.

Knowledge of Microsoft Office Suite; with considerable knowledge of Excel pivot tables, formulas, formatting, and VLOOKUPS.

Knowledge with SQL, Python, or similar language.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLDatabase ManagementData ManipulationStatistical AnalysisMicrosoft OfficeExcelPivot TablesFormulasVLOOKUPSPythonComputer ScienceStatisticsMISIST

Required

Writing SQL reports that access data stored in databases such as SQL Server, DB2, and Oracle.

Developing procedures and views on SQL Server and Oracle databases

Using dynamic grouping fields, dynamic group sorting, on-demand sub reports, drill down and summary reports, and creating crosstab reports highlighting key summary information.

Manipulating large data sets through statistical software or other methods.

Functional expertise developing front-end reporting solutions

Manipulating large data sets through statistical software or other methods. Developing front-end reporting solutions.

Knowledge of Microsoft Office Suite; with considerable knowledge of Excel pivot tables, formulas, formatting, and VLOOKUPS.

Knowledge with SQL, Python, or similar language.