Vacancy expired!
We are looking for Sr. Data Analyst (with SQL, ETL and .NET exp) (3 openings) (Min 11 Yrs exp) (Hybrid 1-3 days on site) (LOCAL Candidates highly preferred) (Webcam interviews) POSITION DESCRIPTION DIRECT CLIENT Position Number of positions: 3 (THREE) Length: 17 Months + Location: Washington, DC 20002 Immediate interviews either Webcam or In-person interviews Please note that this position requires 1 or 2 days onsite and rest REMOTE. 11-15 years of experience. Senior Data Analyst is to provide data analysis and data management support within the data management team in the Clients office for various projects and business needs for multiple education data systems. The role of the Applications Technical Specialist serving as a Senior Data Analyst is to provide data analysis and data management support within the data management team for various projects and business needs for multiple education data systems. This is a highly skilled position and this resource needs to be familiar with educational data requirements and policies as outlined by state and federal regulations for data reporting. This position will also require the resource to develop and maintain databases for reporting framework and storage of data. The Senior Data Analyst shall have knowledge and strong competency with SQL, SQLDB design/development including stored procedures, understanding data structures and cross-functional hierarchies to address the needs of the business and strong communication skills to communicate data hierarchy management procedures and rules to non- technical stakeholders. Duties:
Develop analytical tools and reporting modules Manage SQL Server databases Configure and maintain database servers and processes Analyze, solve, and correct issues in real time Provide suggestions for solutions when troubleshooting Refine and automate regular processes, track issues, and document changes Assist developers with query tuning and schema refinement Provide 24x7 support for critical production systems Perform scheduled maintenance and support release deployment activities after hour Qualifications: Minimum Education/Certification Requirements: Bachelor's degree in Information Technology or related field. Knowledge and skills in managing large complex data sets proficiency in programming languages such as C#, JavaScript, AJAX and MVC. The Applications Technical Specialist shall have 15+ years of relevant work experience with strong competency with SQL, SQLDB design/development including stored procedures, understanding data structures and cross-functional hierarchies to address the needs of the business and strong communication skills to communicate data hierarchy management procedures and rules to non-technical stakeholders. The Application Technical Specialist shall have 10+ years of experience with MS SSIS, MS SSRS, ETL processes and working with large datasets. The candidate should have experience of working in critical production environments that rely heavily on data processes. Experience of working with business stakeholders to support their analytics needs. Proficiency with angular 6.0, ASP.NET, and Web API data set management Proficiency with Data Modeling and ER Studio Candidates must have ALL the "Required" skills in order to be considered for the position. "Desired" or "Highly Desired" skills are a PLUS but may NOT be required. Skill Matrix Experience with Business workflow processes Required / Desired Amount of Experience 11-15 yrs Data analysis and SQL development Required 11 Years Bachelor's degree in IT or related field or equivalent experience Required 4 Years Data and database management experience with SQL 2012 and above Required 5 Years Experience with angular 6.0, ASP.NET, and Web API data set management Required 5 Years Experience with data structures in MS SSIS, MS SSRS, ETL Processes and working with large data sets Required 5 Years SQLDB Design/development including stored processes Required 5 Years Experience with large complex data sets and data modeling Required 5 Years Experience with business intelligence tools such as Power BI, Qlik, MicroStrategy, Tableau, etc Highly desired 5 Years Proficiency in programming languages such as C#, JavaScript, AJAX and MVC. Desired 5 Years Experience of working with business stakeholders to support their analytics needs. Required 11 Years Experience working in critical production environments that rely heavily on data processes Required 5 Years Strong verbal and written communication skills - must be able to communicate complex data to non technical stakeholders. Required 11 Years