Data Analyst 1 or Trainee

Austincc; City of Albany (NY); On-site; USD 59,000 - 66,000; Full time

Job summary

Austincc in Albany, NY is seeking a Data Analyst Trainee to join the Office of Data Analytics and support the Taxation and Finance department. The role will contribute to fraud detection, revenue forecasting, and performance analysis across programs, under supervision.

Two trainee tracks are offered: Analyst Trainee1 with up to 4 years in data visualization and modeling, and Trainee2 with up to 5 years. Onsite interview, eligibility to work in the United States required.

Qualifications

• Four years of experience in data visualization and statistical models and data mining tools.

Responsibilities

• Preparing data for analysis and reporting using data wrangling techniques (joining, merging, stacking, cleansing, transposing, aggregating, transforming).

Skills

Data Visualization

Statistical Modeling

Data Mining Tools

Programming (Python/R/SAS/SQL)

Education

Bachelor’s degree

Master’s degree

Ph.D. in data or computer science

Associate degree

Tools

SPSS Modeler

SPSS Statistics

SAS

Python

R

Stata

Tableau

SQL

GIS

Cognos

AQT

Job description

You are viewing a preview of this job. Log in or register to view more details about this job.

• Sixyearsofexperienceindatavisualization,andstatisticalmodelsanddataminingtools;OR
• AssociatesdegreeANDfouryearsofexperienceindatavisualization,andstatisticalmodelsanddataminingtools;OR
• Bachelor’sdegreeANDtwoyearsofexperienceindatavisualization,andstatisticalmodelsanddataminingtools;OR
• Master’sdegreeindataorcomputerscience,informatics,economics,statistics,mathematics,orarelatedfieldANDoneyearofexperienceindatavisualization,andstatisticalmodelsanddataminingtools;OR
• Ph.D.indataorcomputerscience,informatics,economics,statistics,mathematics,orarelatedfield.

TraineeshipQualifications:

Applicantswithlessthantherequiredexperiencemaybeconsideredforatwo-year(DataAnalystTrainee1)oroneyear(DataAnalystTrainee2)traineeshipleadingtoDataAnalyst1ifthefollowingminimumqualificationsaremet:

DataAnalystTrainee1

• Fouryearsofexperienceindatavisualization,andstatisticalmodelsanddataminingtools;OR
• AssociatesdegreeANDtwoyearsofexperienceindatavisualization,andstatisticalmodelsanddataminingtools;OR

DataAnalystTrainee2

• Fiveyearsofexperienceindatavisualization,andstatisticalmodelsanddataminingtools;OR
• AssociatesdegreeANDthreeyearsofexperienceindatavisualization,andstatisticalmodelsanddataminingtools;OR
• Bachelor’sdegreeANDoneyearofexperienceindatavisualization,andstatisticalmodelsanddataminingtools;OR
• Master’sdegreeindataorcomputerscience,informatics,economics,statistics,mathematics,orarelatedfield

PreferredQualifications:

• Candidateswithstrongdataanalysisskillsandprogrammingexperienceusingoneormoreofthefollowingtools:SPSSModeler,SPSSStatistics,SAS,Python,R,Stata,Tableau,SQL,AQT,Cognos,GISsystemsandadvancedknowledgeofstatisticsandmachinelearningarepreferred.

DutiesDescription

TheDataAnalyst1willworkintheOfficeofDataAnalytics(ODA)underthedirectionofasupervisorormanagertobuildbusinesssolutions,produceforecasts,andanswerquestionsacrossallareasoftheDepartmentofTaxationandFinance.Examplesofprojectsincludefrauddetection,revenueforecastingatthemicroandmacrolevel,andanalysisofprogramperformance.Dutiesmayinclude,butarenotlimitedto:

• Preparingdataforanalysisandreportingusingdatawranglingtechniques(joining,merging,stacking,cleansing,transposing,aggregating,transforming,etc.).
• Creatingandmaintainingdatadictionariesandspecificationsdocuments.
• Producingandinterpretingunivariateanalysestoidentifypatterns,outliers,anderrorsindata.
• Performingmultivariateanalysesusingcorrelations,regressionanalysis(linear,nonlinear,tree,etc.),andmultidimensionalgraphicaltechniques.
• Developingbasicpredictivemodelsandassessingtheresultstoensurevalidity,applicability,efficiency,andaccuracy.
• Summarizingandpresentinganalyticalresultsusingtables,graphs,dashboards,factsheets,andwrittenreports.
• Writingclearandconciseresultssummariesforpolicy,business,andtechnicalaudiences.
• MaintainingknowledgeoftheDepartment’sdatasetsanddatastorageareas.
• Assistinginthesystemsmanagement,datamanagement,andtestingofsystemsusedforanalysis;developingscriptsanddatapipelinestoautomatethesetasks.
• ComplyingwithOfficeofHumanResourcesManagement,AffirmativeAction,CodeofConduct,Ethics,andInternalControlpoliciesandprocedures.
• AdheringtoDepartment'stimeandattendancerulesandregulations.

AdditionalComments

• Fall,Winter,andSpringgraduateswillbeconsidered.
• ThispositionisonsiteinAlbany,NYandinterviewswillbescheduledinperson.
• Telecommutingwillbediscussedattheinterview.

SalariesforTrainees:ThehiringrateforDataAnalystTrainee1–M/Cis$59,204,andDataAnalystTrainee2–M/Cis$66,023.

AllcandidatesmustbeeligibleforemploymentintheUnitedStatesandmaintainthiseligibilitythroughouttheiremploymentwithNewYorkState.EmploymentiscontingentupontheprovisionofproofoftherighttoacceptemploymentintheUnitedStates.

AnycandidateselectedforthispositionwillbesubjecttoareviewoftheirtaxreturnsubmissionsbytheNewYorkStateDepartmentofTaxationandFinance.EmploymentofacandidateisconditioneduponafindingbytheNewYorkStateDepartmentofTaxationandFinancethatthecandidateisincompliancewithalllocal,state,andfederaltaxlaws.Inaccordancewithfederalgovernmentrequirements,theemploymentofanycandidateselectedforthispositionisconditioneduponcompletingabackgroundinvestigationincludingacriminalhistoryrecordcheck(fingerprintcheck).

NewYorkStateisanequalopportunityemployer.It’sthepolicyofthestateofNewYorktoprovideforandpromoteequalopportunityinemployment,compensation,andothertermsandconditionsofemploymentwithoutdiscriminationonthebasisofage,race,color,religion,disability,nationalorigin,gender,sexualorientation,maritalstatus,oranarrestorcriminalconvictionrecordunlessbasedonabonafideoccupationalqualificationorotherexception.