The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.

MS BI Developer (100% Remote)

Job Description

Description:

TEKsystems has a need for a MS BI developer with extensive experience with SSAS. This individual will be helping with performance tuning and helping to improve scalability issues . This individual is responsible for the design, implementation and maintenance of data warehouse and data marts. ETL development skills using Microsoft SSIS, expertise in relational structures, dimensional data modeling, and T-SQL skills are a must. Must be a self-starter who enjoys problem solving researching techniques and methodologies to produce effective, complete and reliable solutions.

Required Knowledge, Skills and Abilities:

Advanced knowledge and experience with MS SQL Server 2014/2016.

Solid understanding of Relational and Dimensional Modeling.

Experience in enhancing/developing complex stored procedures.

Experience in SSAS

Performance tuning stored procedures and ETL processes.

Advanced knowledge of Tabular and DAX

Desired Knowledge, Skills and Abilities:

Experience with Data Mining

Working knowledge MDX query language.

Key Responsibilities

• Build, maintain, and optimize OLAP cubes using Microsoft SSAS.

• Work with BI tools like Power Pivot, Power View, and PowerBI to build decision support systems

• Enhance and support data warehousing and data management projects with ETL development.

• Develop data models and architectural designs to build data warehouse using Kimball methodologies.

• Responsible for query optimizations and performance tuning of various MS BI objectsTop Skills Details:

-Build/maintain/optimize OLAP cubes using SSAS

-SSIS, T-SQL, and PowerBI

-Tabular

-DAX

About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

Job Requirements

 

Job Snapshot

Location US-OR-Remote
Employment Type Contractor
Pay Type Year
Pay Rate N/A
Store Type Other
Apply

Company Overview

TEKsystems, Inc

We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company. Learn More

Contact Information

US-OR-Remote
Snapshot
TEKsystems, Inc
Company:
US-OR-Remote
Location:
Contractor
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
Other
Store Type:

Job Description

Description:

TEKsystems has a need for a MS BI developer with extensive experience with SSAS. This individual will be helping with performance tuning and helping to improve scalability issues . This individual is responsible for the design, implementation and maintenance of data warehouse and data marts. ETL development skills using Microsoft SSIS, expertise in relational structures, dimensional data modeling, and T-SQL skills are a must. Must be a self-starter who enjoys problem solving researching techniques and methodologies to produce effective, complete and reliable solutions.

Required Knowledge, Skills and Abilities:

Advanced knowledge and experience with MS SQL Server 2014/2016.

Solid understanding of Relational and Dimensional Modeling.

Experience in enhancing/developing complex stored procedures.

Experience in SSAS

Performance tuning stored procedures and ETL processes.

Advanced knowledge of Tabular and DAX

Desired Knowledge, Skills and Abilities:

Experience with Data Mining

Working knowledge MDX query language.

Key Responsibilities

• Build, maintain, and optimize OLAP cubes using Microsoft SSAS.

• Work with BI tools like Power Pivot, Power View, and PowerBI to build decision support systems

• Enhance and support data warehousing and data management projects with ETL development.

• Develop data models and architectural designs to build data warehouse using Kimball methodologies.

• Responsible for query optimizations and performance tuning of various MS BI objectsTop Skills Details:

-Build/maintain/optimize OLAP cubes using SSAS

-SSIS, T-SQL, and PowerBI

-Tabular

-DAX

About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

Job Requirements

 
?response_id=18c0448fdc8ab7eb36b78241309ce184&view&dt=62135526699
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
MS BI Developer (100% Remote) Apply now