BI Developer (remote)

Posted Date 2 weeks ago(9/16/2022 1:42 PM)
Job ID
2022-25023
Job City
Phoenix
Job State
Arizona

Overview

Knowledge Services is seeking a remote BI Developer for a 12 month contract (potential for extension) with the State of Arizona.  Applicants MUST BE CURRENTLY LOCAL TO THE GENERAL PHOENIX AREA.  The role will work 100% remotely.

Responsibilities

The BI Developer will design database structures, enforce good database practices, create SQL Server Data Tools deployment packages (DACPAC), create and deploy SSIS packages, improve monitoring capability error logging and error recovery capability of ETL jobs, develop reports.

• Develop database objects such as tables, views, common table expressions, dynamic SQL, foreign key constraints, and stored procedures.
• Designs logical and physical databases (OLAP and OLTP) or review description of changes to database design.
• Perform SQL query performance tuning, which may include index recommendations or hardware configuration considerations, in addition to query and database design
• Interview and collaborate with non-technical business users to collect requirements
• Proactively address technical production issues

Qualifications

BI Developer requirements:

• Experience as a Microsoft SQL Server Developer, Data Warehouse Developer is required
• Experience with developing and supporting SSIS and SSRS is required
• Experience with Azure DevOps pipelines is required
• Knowledge of database standards such as, object definition and naming, T-SQL best practices, etc.
• Knowledge of data warehouse design (Kimball and/or Inmon), OLAP and OLTP systems is a plus
• Experience with large data sets is desired
• Experience with Cognos 10.2 or higher and Framework Manager is a plus

• Knowledge and experience working with an operational DBA team will be helpful.

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.