SQL Server Developer

Allied Consultants, Inc.•Austin, TX

2d•Remote

About The Position

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.

Requirements

10 years of experience with SQL Server Integration Services (SSIS)
10 years of experience with SQL Server Analysis Services (SSAS)
6 years of experience with SQL Server 2019-2022
5 years of experience with Microsoft .NET
5 years of experience with Technical Documentation
5 years of experience with Ed-Fi Data Standard
5 years of experience with Educator Preparation Data Model (EPDM)

Nice To Haves

2 years of experience with PowerBI

Responsibilities

Maintaining, developing, and updating the back-end processes that feed into PowerBI dashboards using SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
Creating deployment instructions for updates moving into test and production environments.
Participating in the requirements gathering process, including serving on a dashboard governance committee to provide feasibility and time estimates for dashboard updates.
Making corresponding updates based on decisions from the dashboard governance committee and departmentally required updates.
Planning, developing, testing, and documenting computer programs, applying knowledge of programming techniques and computer systems.
Consulting with users to identify current operating procedures and clarify program objectives.
Formulating plans outlining steps required to develop programs, using methodologies such as structured analysis and design or object-oriented development.