Offer summary

Qualifications:

Bachelor's or Master's degree in Computer Science, Information Technology, or a related field., 7+ years of experience with Microsoft SQL Server and building Data Warehouses., Expertise in SSIS and Python for ETL development, along with strong skills in Power BI for reporting., Strong understanding of relational database design, indexing, and performance tuning..

Key responsabilities:

Manage a single version of the truth and turn data into critical information for business decisions.

Collaborate with cross-functional teams to integrate data from various source systems.

Develop and maintain ETL processes to load data into the data warehouse and optimize performance.

Mentor junior team members and maintain comprehensive technical documentation for data warehouse processes.

Job description

Exp 7+ yrs

Location - Remote (Initially the person has to come down at our Vadodara office for 5 days - Travel and hotel stay provided) and then its remote.

CTC upto 23 LPA

Shift - 3PM to 12 (midnight)

Key Responsibilities

Data Warehouse Development: Responsible for managing a single version of the truth and turning data into critical information and knowledge that can be used to make sound business decisions.

Dimensional Modeling: Convert business entities into facts and dimensions to provide a structured and efficient data model that supports accurate and insightful business analysis.

Data Integration: Collaborate with cross-functional teams to integrate data from various source systems such as Oracle NetSuite, Salesforce, Ragic, SQL Server, MySQL, and Excel files.

Data Transformation: Develop and maintain ETL processes using Microsoft SSIS, Python or similar ETL tools to load data into the data warehouse.

Performance Optimization: Optimize queries, indexes, and database structures to improve efficiency.

Requirement Analysis: Work closely with key users and business stakeholders to define requirements.

Documentation: Maintain comprehensive technical documentation for data warehouse processes, data integration, and configurations.

Team Collaboration: Mentor and guide junior team members, fostering a collaborative environment.

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.