Overview

Allied Consultants, Inc is a proudly Austin based firm with over 34 years of experience delivering top-tier technical and business professionals within Texas State Agencies. We are currently seeking an experience SQL Server Developer to play a key role within a high-impact technical services team. At Allied Consultants, we value our consultants and are committed to providing an exceptional experience including: Highly competitive pay rates Local support staff for responsive, personal service Comprehensive benefits package, including: Medical insurance (with employer cost sharing) Life insurance A 401(K) plan with company match Flexible spending through a cafeteria plan Candidates selected for interviews will be subject to a criminal background check and may be required to pass a drug screening, in compliance with federal and state regulations. All offers of employment are contingent upon successful completion of these checks. Allied Consultants is a proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Responsibilities

This 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 environments. The 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. 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 development.

Location of job: Remote

Qualifications

Minimum Requirements:Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. Years Required/Preferred Experience 10 Required SQL Server Integration Services (SSIS) 10 Required SQL Server Analysis Services (SSAS) 6 Required SQL Server 2019-2022 5 Required Microsoft .NET 5 Required Technical Documentation 5 Required Ed-Fi Data Standard 5 Required Educator Preparation Data Model (EPDM) 2 Preferred PowerBI