ETL Reports DeveloperLOCATION: Pierre, SD or Remote DURATION: April 1, 2021 through May 31, 2022Specific DutiesWith incumbent vendor, facilitate ETL processes of a longitudinal data warehouse with a data lake, including but not limited to rolling the system into the new school year, loading data, and maintaining current ETL code.Perform data validation to ensure data display accurately in the backend tables as well as published reports.Create ad hoc SQL queries to answer a wide range of inquiries of the system, from troubleshooting problems to formal data requests.Monitor the system, including but not limited to the nightly jobs and load performance; utilize the vendor-created solution to monitor processes and applications of the system.Perform organizational tasks that keep the system and documentation up to date, including but not limited to managing security, updating technical documentation, identifying systemic problems, and utilizing a vendor-created metadata management application as well as maintaining reports, jobs, and stored procedures.Develop MicroStrategy dossiers or dashboardsCreate and update existing SQL Reporting Services (SSRS) reports.Load assessment files into the database using a vendor-created solution.Monitor the vendor-created identity management solution.Maintain SD-STARS security for users by monitoring the jobs and processes, raising possible concerns, and implementing security for reports and dashboards.As a member of the technical team, participate in planning and status meetings.As a member of the technical team, assist other team members on the system when needed.QualificationsThe successful candidate must have the following knowledge and experience for this position:Bachelor’s degree plus 3+ years of experience in systems development with emphasis on data conversion and ETL;3+ years of experience programming in Transactional SQL (TSQL);3+ years of experience in ETL development ;2+ years of experience in SSRS;2+ years of experience developing MicroStrategy reports and dashboards;2+ years of experience developing PowerBI dashboardsExperience in identifying and communicating complex and technical issues followed by developing recommendations and facilitating resolution with stakeholders;Working knowledge of data modeling in data warehouses, cubes, etc;Working knowledge of effective data conversion methods and approach;Working knowledge of data conversion complexities;High level of attention to detail – thoroughness and accuracy when accomplishing tasks;Excellent communications skills, both verbal and written;Professional demeanor – communicates with stakeholders in a friendly, unbiased, and professional manner;Ability to maintain effective working relationships with BIT, DOE, and vendor staff;Ability to work within a demanding project environment;Ability to follow, update, and create documentation of work processes;Ability to keep information confidential and abide by security standards and laws (ex: FERPA); andAbility to pass background security check (including fingerprinting).The successful candidate should have the following knowledge and experience for this position:Proficient in relational database and data warehouse – design, creation, optimization, and refactoring SQL databases;Proficient in the development of stored procedures, triggers, functions, SSIS and SSRS;Proficient in the development of MicroStrategy dossiers and dashboards;Knowledgeable in the use of Azure DevOps (ADOS) source control including branching and merging;Knowledgeable in SQL performance tuning, including use of the query store;Knowledgeable in SQL replication technologies;Experience in translating non-technical client requirements into information technology solutions;Experience in unit and functional testing on developed applications;Familiar with Software Development Life Cycle (SDLC) concepts;Familiar with Agile and/or Scrum development methodologies; andAbility to perform these functions with minimal supervision.