Data Warehouse/BI Developer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Apetan Consulting, is seeking the following. Apply via Dice today!

Data Warehouse/BI Developer 100% Remote

Job Details-

stewards for the Investments Department. IDS connects data to investment analysis by overseeing all

aspects of the data management life cycle. They work closely with investment programs to understand

their business data and decision support requirements, develop tools to extract valuable and timely

information, and continuously improve processes and systems to ensure high levels of data integrity and

availability. The IDS team is seeking seasoned SQL development and testing expertise to successfully

assist with ongoing business initiatives.

Scope:

The Investment Decision Support team is seeking an experienced SQL Developer/Tester with strong

database, programming, and analytical skills to actively participate in the following scope of work:

Assist with overall SQL Support (development, performance tuning, testing, documentation) related to

quarterly projects and other efforts as needed. Activities may include:

Development - SQL Development support to include creation of stored procedures or underlying

queries. Provide support in the design, development, and implementation of ETL packages with

SQL Server Integration Services (SSIS).

Performance Tuning - Review existing SQL Queries, Execution Plans, etc. to determine

performance enhancements for long running queries.

Data Manipulation - Provide alternative options to existing data manipulation techniques.

Examples would be converting Excel manipulation activities into SSIS packages that reduce

process/cycle time of data preparation.