Power BI Developer

Job ID: TX-70123035A Remote/Local Power BI Developer with SQL, SAS, Data warehousing, Crystal Reports, .Net/C#/ASP, and education experience Location: Austin TX (TEA) Duration: 5-41 months Remote work may be allowed and should be coordinated with the manager. Minimum Requirements: - Years Required/Preferred Experience - 7 Required Data analysis - 7 Required SQL - 4 Required Power BI report creation - 4 Required SAS base programming - 4 Required Dataset creation - 4 Required Data warehousing and testing - 4 Required Quality Assurance Testing - 4 Required Creating and documenting requirements specifications, business rules, and user help information - 4 Required Excel 4 Preferred Microsoft Office products 1 Preferred Crystal Reports 1 Preferred Web development tools (.Net, c#, ASP, Microsoft Visual Studio) 1 Preferred State educational data sources including PEIMS, teacher certification, Texas higher education, and STAAR OTHER SPECIAL REQUIREMENTS - Work Hours are Central Time - Ability to code, test, and debug SQL and SAS programs - Skill in gathering and creating requirements and other technical documentation - Skill in creating and maintaining formatted educational reports for public use - Meticulous attention to detail with the ability to produce high quality work in a dynamic environment - Must be able to read and understand existing coding and processing to troubleshoot and resolve issues as they arise - Highly organized, ability to work on multiple projects at once, and meet deadlines - Excellent written and oral communication skills - Ability to work with team members and stakeholders, engage in a collaborative, results-oriented environment, and maintain cooperative working relationships with a variety of individuals and professional groups across functional units - Must submit to a national criminal history record information review, including fingerprinting, prior to beginning work The 2019 Statewide Longitudinal Data System (SLDS) Outcome 5.4 Project is funded by a grant from the US Department of Education. This project has been developed to update and enhance current PreKindergarten Reports located on the Texas PK-16 Public Education Information Resource (TPEIR) website. The Power BI Programmer and Report Developer will report to the TPEIR Unit Manager in the Research & Analysis Division. This contract position performs highly complex SAS programming, data analysis, as well as report building and conversion for the TPEIR public website. Specific job responsibilities include converting existing reports to Power BI with SAS datasets as back-end; designing, developing, and creating SAS datasets and Power BI reports; and optimizing SAS code using best practices.