Job Code: BID6

​

• Participate in requirements definition, solution development and the implementation phases of software application development and design;

• Assist SMEs in designing, testing, and aggregating results from SQL queries;

• Create and maintain ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows);

• Configure and tune ETL infrastructure to optimize the data warehousing architecture;

• Design, implement and maintain a reporting, monitoring and dashboard framework;

• Develop aggregation, monitoring and alerting tools/modules;

• Use BI and data analysis software (SQL Server Management Studio, SQL Server Reporting Services) in regular course of work.

• Additional related tasks as needed.

 

Knowledge, Skills, and Abilities:
 

Use Business Intelligence (BI) tools and instrumentalities such as SSAS, SSRS, SSIS packages, Tableau, Power BI, or related.  Knowledge of development environments and process such as Microsoft SQL Server and ETL.

 

Minimum Requirements to Hold Position:
 

A bachelor’s degree or higher specific fields of Computer Science, Information Systems, or closely related field is required to perform the duties of this position.