Key Facts

Remote From:

Full time

English

Hard Skills

Data Warehouse Architectures Dimensional Modeling Microsoft SQL Server Data Engine (MSDE) Performance Systems Analysis Git (Version Control System) JIRA Database Design Python (Programming Language) Power BI Indexing Azure Databricks Data Visualization SQL Server Reporting Services Tableau (Business Intelligence Software) Stored Procedure Azure Data Factory Azure Data Lake ETL (Extract Transform Load) Internal Documentation

Other Skills

•
Problem Reporting
•
Analytical Skills
•
Communication
•
Problem Solving

Roles & Responsibilities

7+ years of experience with Microsoft SQL Server
Expertise in building Data Warehouse using SQL Server
Hands-on experience with Dimensional Modeling using Facts and Dimensions
Expertise in SSIS and Python for ETL development

Requirements:

Design and develop Data Warehouse solutions using SQL Server including dimensional modeling with facts and dimensions
Develop and maintain ETL processes using SSIS and Python
Create and optimize Power BI reports and dashboards for data visualization
Ensure robust relational database design, indexing, performance tuning, and write complex SQL scripts, stored procedures, and views

Kiash Solutions LLP

Human Resources, Staffing & Recruiting

About Kiash Solutions LLP

We are a staffing expert company with options to hire on C2H, Contract or Perm positions. We offer our clients to achieve their business goals with successfully outsourcing the business processes and functionalities. Our ability to offer high quality services in quick time makes us sustainable among the competitors. We believe in giving custom-fit, flexible and high quality solutions by deeply understanding the requirements. Mission- To Challenge Our Limits In Serving Our Valued Clients With The Finest Resources. We prioritize ethics more than everything else and create an environment where our employees are innovative and thrive success. Vision- An Inevitable Connecting Link Between The “Wants” And The “Needs”. We measure our success only by the value we deliver to our clients. The Quality of Staffing services. To focus on Nurturing our core values to shape our business. To let our work define our character.

Company type: Scaleup

Industry: Human Resources, Staffing & Recruiting

Founded: 2018

Company size: 51 - 200

Website LinkedIn See all jobs →

Job description

Location - Remote ((initially for 5 days the candidate needs to come down to our office in Vadodara) and then it would be work from office.

CTC upto 23 LPA

Must have skills mentioned on their resume:

SQL Server
Data Warehouse
Dimensional Modeling
Azure (Datalake, Data Factory, Data Bricks) ALL 3 Must
Power BI
SSIS
Python
Tableau
SSRS

Must have

Bachelors or Masters degree in Computer Science, Information Technology, or a related field.
7+ years of experience with Microsoft SQL Server.
Expertise in building Data Warehouse using SQL Server.
Hands-on experience Dimensional Modeling using Facts and Dimensions.
Expertise in SSIS and Python for ETL development.
Strong experience in Power BI for reporting and data visualization.
Strong understanding of relational database design, indexing, and performance tuning.
Ability to write complex SQL scripts, stored procedures and views.
Experience with Git and JIRA.
Problem-solving mindset and analytical skills.
Excellent communication and documentation abilities.