Required Skills

SQL DBA Prepares reports tables charts and graphs.

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 13th Jan 2021

JOB DETAIL

10 exp required

Thisposition within the Bureau of Education, Outreach, and Marketing will gather,organize, mine, analyze, and present data from several databases.  Theseinclude; the Pennsylvania Automated License System (PALS), Boat Registrationand Titling System (RATS), Event Management System, email management anddistribution system, and public survey systems.  Results of analysis willbe used to guide Bureau efforts to increase the number of fishing licensebuyers, boat registrants/launch permit buyers, and other marketing and outreachactivities.  
Description of tasks.
•    Build and maintain databases used to describe and predictcustomer behavior
•    Utilizes database, spreadsheet, and statistical software,including developing custom statistical software queries, to process,manipulate, and statistically analyze data.
•    Applies financial, statistical, and/or mathematical methodsto analyze data.  Routinely carry out basic levels of analysis, such asdescriptive statistics and simple tests of significance.
•    Analyzes data collection, organization, and processingmethods and recommends revisions to improve data validity, reliability, andrelevance.
•    Develop reports summarizing data at the populationlevel.  Presents summary-level information through regularly scheduledreports.
•    Develop queries to identify individuals meeting specificcriteria (or multiple criteria), such as prior license purchase history ordemographic variables, and provide that data for use in marketing campaigns and communication efforts.
•    Develop custom queries and reports upon request.
•    Prepares reports, tables, charts, and graphs.
•    Develops and/or maintains documentation such as planningdocuments, procedures, and forms.
•    Organize, maintain, and manage customer informationutilized in marketing and communication campaigns, and provide data to programmanagers for use in these campaigns.
•    Assist in the development of strategies to evaluate R3actions and determine most appropriate means to carry out analysis and presentthe results.
•    Organize, analyze, and present data collected throughpublic surveys conducted internally or by third-party vendors.
•    Gather, organize, analyze, and present data on userexperiences from media platforms and services such as Google Analytics andsocial media management systems.
•    Proficient in Microsoft SQL, Jaspersoft, Tableau, R, andother data/analytic platforms.
•    Experience in HTML and other web application codingpreferred, but not required.
Experience and Training
Four-year college degree in computer science or a related field with advancedstudy preferred; certifications specific to database design and managementpreferred.  Ten or more years of relevant experience in construction,design, and utilization of database and analytical systems.  Five or moreyears of experience providing consulting services to government.

Company Information