The role of the Applications Technical Specialist serving as a data analyst is to provide data analysis and data management support within the data management team in the CIO’s office for various projects and business needs for multiple special education data systems. This is a highly skilled position and familiarity with educational data and policies will be a plus.
This position will also require the resource to develop and maintain databases for reporting framework and storage of data. The Data Analyst shall have knowledge and strong competency with SQL, SQLDB design/development including stored procedures, understanding data structures and T-SQL. The role will involve working closely with application development teams and experience of supporting complex business rules for application needs in database is a must.
Develop analytical tools and reporting modules
Develop business rules in database to supports application requirements.
Refine and automate regular processes, track issues, and document changes
Assist developers with query tuning and schema refinement
Configure and maintain database processes
Analyze, solve, and correct issues in real time
Provide suggestions for solutions when troubleshooting
Provide 24x7 support for critical production systems and perform scheduled maintenance and support release deployment activities after hour as needed
Minimum Education/Certification Requirements:
Bachelor’s degree in Computer Science or related field.
At least 4 years and no more than 8 years of relevant work experience with strong competency with SQL, SQLDB design/development including stored procedures, T-SQL, understanding of data structures and experience with MS SSIS, MS SSRS, ETL processes and working with large datasets. Experience of working in critical production environments that rely heavily on data processes is a must.
Programming languages such as Stata/R will be a plus.
Experience of working with business stakeholders to support their data needs.
Data analysis and SQL Development
Bachelor’s degree in IT or related field or equivalent experience
Data and database management experience with SQL 2012 and above
Knowledge of business intelligence tools such as Tableau, Microstrategy, Qlik, or QuickBase applications
Experience with large complex data sets
Strong technical documentation skills
SQLDB design/development including stored procedures
Programming languages such as Stata/R
Understanding of data structures and experience with MS SSIS, MS SSRS, ETL processes and working with large datasets
Experience of working in critical production environments that rely heavily on data processes is a must
Strong verbal and written communication skills - must be able to articulate complex data to non-technical stakeholders