Key Facts

Remote From:

Full time

English

Hard Skills

Data Warehouse Architectures Azure Data Lake Microsoft SQL Server Data Engine (MSDE) Dimensional Modeling Performance Systems Analysis Git (Version Control System) Dimensional Modeling JIRA Database Design Python (Programming Language) Power BI Indexing Data Visualization SQL Server Integration Services (SSIS) SQL Server Reporting Services Tableau (Business Intelligence Software) Stored Procedure 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 and expertise in building Data Warehouses using SQL Server
Hands-on experience with Dimensional Modeling using Facts and Dimensions
Proficiency in ETL development with SSIS and Python, and Azure data services (Data Lake, Data Factory, Databricks)
Bachelor's or Master's degree in Computer Science, Information Technology, or a related field; strong communication and documentation skills; experience with Git and JIRA

Requirements:

Design, develop, and maintain data warehouses on SQL Server
Implement ETL processes using SSIS and Python and apply dimensional modeling techniques (facts and dimensions)
Develop and maintain Power BI reports and dashboards for data visualization and insights; ensure data accuracy and performance
Collaborate with cross-functional teams; document architecture, processes, and best practices; manage version control with Git and issue tracking with JIRA

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.