ETL Developer

ETL Reports Developer

LOCATION:

Pierre, SD or Remote DURATION:
April 1, 2021 through May 31, 2022

• With 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 Micro Strategy dossiers or dashboards
• Create 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.

The 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 Micro Strategy reports and dashboards;
• 2+ years of experience developing PowerBI dashboards
• Experience 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); and
• Ability 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 Micro Strategy dossiers and dashboards;
• Knowledgeable in the use of Azure Dev Ops (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; and

Ability to perform these functions with minimal supervision.