Sr SSRS PBI Developer

Overview

Full Time
Part Time
Accepts corp to corp applications
Contract - W2
Contract - Independent

Skills

DML
Data management
Data warehouse
Big data
Business rules
Extract
transform
load
Stored procedures
Microsoft Power BI
Microsoft SQL Server
Microsoft SSIS
Data flow
Control flow
Relational databases
Flat file
Web services
Data integration
Microsoft SSRS
LOS
CPT
Data
Streaming
SQL
Analytical skill
Metrics
Microsoft SQL Server Management Studio (SSMS)
Design
Database
Cloud computing
Storage

Job Details

Hi,

Role: Sr SSRS PBI Developer (need 60% in ssrs and 30% PBI)

Location: Los Angeles, CA (Onsite only Locals)

Visa : All except No h1b , opt and cpt

Job Description:

The desired profile should have hands-on experience in designing, establishing, and maintaining data management and storing systems. Skilled in collecting, processing, cleaning, and deploying large datasets, understanding ER data models, and integrating with multiple data sources. Efficient in analyzing, communicating, and proposing different ways of building Data Warehouses, Data Lakes, End-to-End Pipelines, and Big Data solutions to clients, either in batch or streaming strategies.

Technical Proficiencies:

SQL:

Data Definition Language, Data Manipulation Language, Intermediate/advanced queries for analytical purpose, Subqueries, CTEs, Data types, Joins with business rules applied, Grouping and Aggregates for business metrics, Indexing and optimizing queries for efficient ETL process, Stored Procedures for transforming and preparing data, SSMS, DBeaver

Power BI:

  • Design and develop ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various source systems into target databases.

  • Create, configure, and deploy SSIS packages, including data flow tasks, control flow tasks, and event handlers.

  • Perform data source integration from diverse platforms, such as relational databases, flat files, web services, and cloud-based storage

  • Strong knowledge in Power BI

  • Optimize data integration processes for performance, identifying and resolving bottlenecks, and utilizing best practices.

  • Provide expertise in troubleshooting and resolving data integration issues, ensuring data accuracy and consistency.