SQL Subject Matter Expert

Location: Harrisburg, PA
Date Posted: 12-22-2017
SQL Subject Matter Expert
Harrisburg, PA
6 Months
Complete Description:
  • Help design and analyze educational data sets to understand ecosystems, student behaviors, and long-term trends
  • Advocate for strong analytical methodologies and metadata standards across the organization
  • Assist with the definition, evaluation, and calculation of key educational performance metrics
  • Help foster a culture of data-informed analytical evaluation to improve education
  • Sit at the intersection between technology, policy, and executive leadership to inform, influence, and support data informed decisions on educational policy
  • Build complex data sets and visualizations to empower operational and exploratory analysis asking creative questions to expose hidden insights in the data and inform decisions impacting millions of students
Technology Expertise:
  • Expert level knowledge of SQL / T-SQL for Data Analysis, including Windowed Functions, Pivot/Unpivot operations, Query Execution Plan Optimization, Index Design, database-level descriptive statistics, and database introspection through system tables and views
  • SQL Server 2016
  • Tableau 10.2+ and experience with Data Visualization best practices and visual analysis
  • Scripting languages or ETL tools for automating data preparation tasks (e.g., Python, R, etc.)
  • Ability to interpret large amounts of data, multi-task, and produce results independently or collaboratively in a team environment
  • Capable of intaking and integrating large sets of information from multiple sources, formulate/validate hypotheses, make recommendations, and summarizing complex data nuances to senior stakeholders
  • Experience extracting data from a variety of sources, and a desire to expand those skills
  • Willing to learn new technologies and methods related to data analytics, data visualization and statistical analysis
  • Thinks holistically to create innovative scalable solutions to data analysis problems
Strongly Preferred:
  • Experience with education data standards, state/federal reporting requirements for K-12 educational entities or higher education
  • Experience with eScholar Complete Data Warehouse for Students
  • Business, technical, or integration consulting Required 10 Years
  • 4 year college degree or equivalent technical study with advanced study Highly desired
  • SQL / T-SQL Required 5 Years
  • SQL Server 2016 Required
  • Tableau 10.2 or greater Desired
  • Scripting languages or ETL tools for automating tasks (Python, R, etc) Nice to have
  • Experience with education data standards, state/federal reporting requirements for K-12 or higher education entities Nice to have
  • Excellent written and oral communication skills Required
  • Analytical thinking and creative problem solving Required
|| Office: 916 646 2080 Ext 222|| Fax: 916 646 2081 || Email: ashok@keybusinessglobal.com || Website: www.keybusinessglobal.com ||
Note: This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.
this job portal is powered by CATS