- Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: Lead data engineer / dwh specialist – sql server | azure synapse | ssis | power bi.
Urgent! Lead data engineer / dwh specialist – sql server | azure synapse | ssis | power bi Job Opening In India, India – Now Hiring Asian Hires
Reporting RelationshipPosition Reports To: Senior Manager Application DevelopmentDepartment: Information TechnologyPosition Location: Vadodara, Gujarat, India (Hybrid)Budget: 20,00,000 -30,00,000 PA.Job SummaryWe are seeking a strategic and technically proficient Lead Data Warehouse Engineer to architect, manage, and evolve our enterprise data warehouse.
This role will lead the data engineering team, drive best practices in data modeling and ETL development, and ensure high-performance data solutions that support business intelligence and analytics across the organization.Key Responsibilities Data Warehouse Development: Design and setup data warehouse from scratch while ensuring scalability, reliability, and alignment with business goals. Dimensional Modeling & Data Governance: Lead the design of dimensional models (facts and dimensions) and enforce data governance standards to maintain a single version of truth. ETL Strategy & Development: Oversee the development and optimization of ETL pipelines using SSIS, Python, and cloud-native tools.
Ensure efficient data ingestion from systems like Oracle Net Suite, Salesforce, Ragic, SQL Server, My SQL, and Excel. Performance Optimization: Monitor and tune database performance, indexing strategies, and query execution plans to ensure optimal system responsiveness. Stakeholder Collaboration: Partner with business stakeholders to gather requirements, translate them into technical specifications, and deliver actionable insights. Team Mentorship & Project Oversight: Mentor junior engineers, conduct code reviews, and manage project timelines and deliverables within the data engineering team. Documentation & Compliance: Maintain comprehensive documentation for data flows, integration logic, and system configurations.
Ensure compliance with internal and external data standards.Required Skills & Qualifications Must haveo Bachelor’s or Master’s degree in computer science, Information Technology, or a related field.o 12+ years of experience with Microsoft SQL Server.o Expertise in building Data Warehouse using SQL Server.o Hands-on experience Dimensional Modeling using Facts and Dimensions.o Experience with cloud-based SQL databases like Azure SQL or Azure Synapse.o Expertise in SSIS and Python for ETL development.o Familiarity with Azure Data Factory.o Strong experience in Power BI for reporting and data visualization.o Strong understanding of relational database design, indexing, and performance tuning.o Ability to write complex SQL scripts, stored procedures and views.o Experience with Git and JIRA.o Problem-solving mindset and analytical skills.o Excellent communication and documentation abilities. Nice to Haveo Experience with Microsoft Fabric.o Experience with Azure Databricks.o Familiarity with CI/CD for database deployments and automation tools.o Knowledge of big data technologies like Snowflake
✨ Smart • Intelligent • Private • Secure
Practice for Any Interview Q&A (AI Enabled)
Predict interview Q&A (AI Supported)
Mock interview trainer (AI Supported)
Ace behavioral interviews (AI Powered)
Record interview questions (Confidential)
Master your interviews
Track your answers (Confidential)
Schedule your applications (Confidential)
Create perfect cover letters (AI Supported)
Analyze your resume (NLP Supported)
ATS compatibility check (AI Supported)
Optimize your applications (AI Supported)
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
European Union Recommended
Institution Recommended
Institution Recommended
Researcher Recommended
IT Savvy Recommended
Trades Recommended
O*NET Supported
Artist Recommended
Researchers Recommended
Create your account
Access your account
Create your professional profile
Preview your profile
Your saved opportunities
Reviews you've given
Companies you follow
Discover employers
O*NET Supported
Common questions answered
Help for job seekers
How matching works
Customized job suggestions
Fast application process
Manage alert settings
Understanding alerts
How we match resumes
Professional branding guide
Increase your visibility
Get verified status
Learn about our AI
How ATS ranks you
AI-powered matching
Join thousands of professionals who've advanced their careers with our platform
Unlock Your Lead data Potential: Insight & Career Growth Guide
Real-time Lead data Jobs Trends in India, India (Graphical Representation)
Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for Lead data in India, India using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 294955 jobs in India and 23766 jobs in India. This comprehensive analysis highlights market share and opportunities for professionals in Lead data roles. These dynamic trends provide a better understanding of the job market landscape in these regions.
Great news! Asian Hires is currently hiring and seeking a Lead data engineer / dwh specialist – sql server | azure synapse | ssis | power bi to join their team. Feel free to download the job details.
Wait no longer! Are you also interested in exploring similar jobs? Search now: Lead data engineer / dwh specialist – sql server | azure synapse | ssis | power bi Jobs India.
An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at Asian Hires adheres to the cultural norms as outlined by Expertini.
The fundamental ethical values are:The average salary range for a Lead data engineer / dwh specialist – sql server | azure synapse | ssis | power bi Jobs India varies, but the pay scale is rated "Standard" in India. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.
Key qualifications for Lead data engineer / dwh specialist – sql server | azure synapse | ssis | power bi typically include Architecture & Construction and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.
To improve your chances of getting hired for Lead data engineer / dwh specialist – sql server | azure synapse | ssis | power bi, consider enhancing your skills. Check your CV/Résumé Score with our free Resume Scoring Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.
Here are some tips to help you prepare for and ace your job interview:
Before the Interview:To prepare for your Lead data engineer / dwh specialist – sql server | azure synapse | ssis | power bi interview at Asian Hires, research the company, understand the job requirements, and practice common interview questions.
Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the Asian Hires's products or services and be prepared to discuss how you can contribute to their success.
By following these tips, you can increase your chances of making a positive impression and landing the job!
Setting up job alerts for Lead data engineer / dwh specialist – sql server | azure synapse | ssis | power bi is easy with India Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!