Contract Senior SQL Server / PowerBI Developer Hybrid position

20 Feb 2025

Vacancy expired!

Hybrid Position

High-level Position/Job Description: o Create, maintain, and

tune quality SQL Server reporting deliverables using PowerBI and SSRSo Create, maintain, and tune complex

T-SLQ SQL Server based custom reports and stored procedureso Create, maintain, and tune interfaces with

SSIS based interfaces and stored procedureso Accurately

develop MS SQL Server T-SQL database queries, reports, data loads/extracts in a logical manner from scratch.

Job Description:CAI is seeking a Senior Data/SQL Server Database Developer with strong skills in PowerBI, SSRS (SQL Server Report Services), and SSIS (SQL Server Integration Services). The candidate must also have strong SQL developer experience and can quickly come up to speed on a complex data model and immediately contribute to development and support of MS SQL Server business-requested reports, extracts, loads, stored procedures, and interfaces.This individual will be working with one of our government partners. We are seeking an individual who is a quick study and able to gain a deep knowledge of a COTS product’s SQL Server data model. The SQL Server data model is an integral component of a leading financially based COTS product used to process income tax.Working in a very dynamic environment, you will have the opportunity to participate in the support and enhancements of a SQL Server platform. Leveraging your strong problem-solving and analytical skills, organizational abilities, and attention to detail, you will work with the client and team members to gather and validate requirements, validate designs, and develop database application solutions.

Specific responsibilities may include:
  • Create and maintain quality reporting deliverables using Microsoft PowerBI
  • Create and maintain quality reporting deliverables using Microsoft SSRS
  • Create new and maintain/tune existing T-SQL queries and procedures
  • Create and maintain existing T-SQL based custom reports
  • Create and maintain interfaces leveraging Microsoft SSIS
  • Analyze existing T-SQL queries for performance improvements
  • Review and interpret ongoing business report and interface requirements
  • Create and maintain stored procedures
  • Analyze existing data structures and queries and develop/update reports, queries, data loads, and interfaces.
  • Accurately develop T-SQL database queries, reports, data loads/extracts in a logical manner from scratch.

Minimum Background, Skills, and Competencies:
  • 7 years of experience as a MS Server T-SQL Developer or similar role
  • Strong experience with MS Server Power BI, SSRS, and SSIS
  • BS/MS degree in Computer Science, Engineering, or a related subject
  • A strong MS Server T-SQL developer who can quickly come up to speed on an existing and complex SQL Server database underlying a leading income tax processing COTS product
  • Extensive experience in all aspects of T-SQL programming.
  • 5-7 years of experience with SQL Server PowerBI
  • 3-5 years of experience with creating/maintaining interfaces using SQL Server Integration Services (SSIS) ETL Tool or another ETL product
  • Extensive experience working with large sets of data and resolving data-oriented issues.
  • Extensive experience in tuning queries for optimal performance
  • Able to work independently with minimal direction
  • Ability to work directly with business users to translate business requests/requirements into appropriate designs
  • Possesses excellent communication skills
  • Ability to investigate and identify query performance related issues
  • Possess Critical thinking and problem-solving skills
  • Team player
  • Good time-management skills
  • Sense of ownership and pride in your performance and its impact on team’s success

Preferred Background, Skills, and Competencies:
  • Experience in data warehouse architecture/design / support

Required/Preferred Education:
  • BS/MS degree in Computer Science, Engineering, or a related subject

  • ID: #49313816
  • State: Delaware Wilmington 19801 Wilmington USA
  • City: Wilmington
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2023-02-20
  • Deadline: 2023-04-19
  • Category: Et cetera