DirectClient: Texas Education Agency(TEA)Solicitation#70124060Title: SSIS DeveloperLocation: Austin, Texas 78701Duration: Until 8/31/2024 with possible extensionLast date for submission: October 11, 2023 (2.00 PM-CST) Important Note: 100% remote work DESCRIPTION OF SERVICES-Plans, develops, tests, and documents computer programs, applying knowledge of programming techniques and computer systems. Consults with user to identify current operating procedures and clarify program objectives. Formulates plan outlining steps required to develop program, using methodologies such as structured analysis and design or object-oriented developmentThis contractor will be responsible for maintaining, developing, and updating the back-end processes that feed into PowerBI dashboards. Tools and environments include SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS The contractor will be responsible for creating deployment instructions when updates need to move into test and production environmentsThe developer will participate in requirements gathering process. Part of that process includes serving on a dashboard governance committee to provide feasibility and time estimates for updates to dashboards. Corresponding updates from the dashboard governance committee as well as departmentally required updates will be made by the contractor. CANDIDATE SKILLS AND QUALIFICATIONSMinimum Requirements:Years Required/Preferred Experience8 Required SQL Server Integration Services (SSIS)5 Required SQL Server Analysis Services (SSAS)5 Required SQL Server 20195 Required Microsoft .NET3 Required Technical Documentation3 Preferred MySQL3 Preferred Ed-Fi Data Standard1 Preferred Educator Preparation Data Model (EPDM)