Senior PowerBI/SQL Server Developer/Architect

Hello,

Zenosys is looking for Senior PowerBI/SQL Server Developer/Architect  a client Wilmington, DE If you are available and interested in the below opportunity, please send me updated resume. Thanks

Job Title Senior PowerBI/SQL Server Developer/Architect

Location- Wilmington, DE

Duration 12 Months Contracts Highly Chance to Extend

If you are interested, please provide the following details along with the updated resume to speed up the interview process.

Full Legal Name as mentioned in Drivers' license:

Current Location:

Willing to relocate to the specified work location:

Currently on a project or actively looking:

Availability for interview:

Availability to join the project:

Date of Birth (Month/Date):

Visa Status:

Since how long the candidate has been in US

Need Education details with University Name, Location & Passing year in resume.:

LinkedIn address

•  
• High-level Position/Job Description:
• Create, maintain, and tune quality SQL Server reporting deliverables using PowerBI
• Create, maintain, and tune complex T-SLQ SQL Server based custom reports and stored procedures
• Maintain and extend complex MS SQL Server data models
• Accurately develop MS SQL Server T-SQL database queries, reports, data loads/extracts in a logical manner from scratch.

• Job Description:

We are seeking a Senior Data/SQL Server Database Analyst with strong skills in the Microsoft Data Analytics tools suite, including PowerBI and SSIS. The candidate must also have strong SQL developer experience and can quickly come up to speed on a complex database 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, who is in the process of modernizing their platform. Included in the modernization effort is a migration of technology from a locally maintained Oracle database to a SQL Server database resident in a Microsoft Azure cloud. We are seeking an individual who is a quick study and able to gain a deep knowledge of a COTS product s SQL Server database data models. The SQL Server data model is an integral component of a leading financially based COTS product used to process income tax. The product is Revenue Premier Enterprise (RPE)

Working in a very dynamic environment, you will have the opportunity to participate in the support of the new SQL Server platform. Additionally, building out new functionality on the new SQL Server platform will also be involved.

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 PowerBI

Create new and maintain/tune existing T-SQL queries and procedures

Create and maintain existing T-SQL based custom reports

Maintain and extend complex MS SQL Server data models

Create and maintain interfaces leveraging the Microsoft SSIS

Analyze existing T-SQL queries for performance improvements

Review and interpret ongoing business report and interface requirements

Create and maintain stored procedures

Strong analytical skills. 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

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 at least one of the following: T-SQL programming.

5-7 years of experience with SQL Server PowerBI

Extensive experience working with large sets of data and resolving data-oriented issues.

Extensive experience in tuning queries for optimal performance

Ability to work directly with business users to translate business reporting requests/requirements into a backend database design that clearly identifies database object impacts

Possesses excellent communication skills

Ability to investigate and identify query performance related issues

Critical thinker and problem-solving skills

Team player

Good time-management skills

Great interpersonal and communication skills

Sense of ownership and pride in your performance and its impact on team s success

Preferred Background, Skills, and Competencies:

Experience with creating interfaces using SQL Server Integration Services (SSIS) ETL Tool or another ETL product

Experience in data warehouse architecture / design / support

Required/Preferred Education

• BS/MS degree in Computer Science, Engineering, or a related subject

If interested Please send me your resume at