Apply with hirly
SQL, DWH, Data Steward
Infosys · Pune, India
Upload your resume to see how well you match this job — free, in seconds, no account needed.
Your resume is used only to score it against this job. If you don't create an account, it is deleted within 24 hours.
Join a data-driven team where your expertise in SQL, data warehousing, and data stewardship directly shapes how the business trusts and uses data. In this role, you’ll lead efforts to organize, standardize, and protect critical datasets—turning complex data landscapes into reliable, well-governed assets that teams can confidently build on. You’ll collaborate closely with engineering, analytics, and business stakeholders to define data standards, improve data quality, and enable meaningful reporting through modern BI practices. If you enjoy solving data integrity challenges, building scalable warehouse solutions, and championing governance with a practical, collaborative mindset, this is a great opportunity to make a visible impact while working with teams that value clarity, ownership, and continuous improvement. Responsibilities Key Responsibilities:
- Lead SQL-driven analysis and development to support enterprise reporting, governance, and stewardship needs.
- Design, enhance, and maintain DWH structures (fact/dimension models), ensuring scalability, performance, and consistency.
- Own data stewardship activities including data definitions, business glossary alignment, metadata management, and stewardship workflows.
- Implement and monitor data quality rules, issue management processes, and remediation tracking with stakeholders.
- Partner with ETL teams to define source-to-target mappings, validate transformations, and ensure reliable data pipelines.
- Drive data governance practices including policy adherence, access controls, and standardization of key data elements.
- Develop and support Power BI datasets, semantic layers, and dashboards aligned to governed metrics and definitions.
- Conduct root-cause analysis for data issues across source systems, ETL, and warehouse layers; recommend corrective actions.
- Collaborate with business and technical teams to gather requirements and translate them into governed data solutions.
- Provide technical guidance and reviews for SQL, ETL logic, and DWH design to ensure best practices and consistency. Minimum Qualifications:
- BTECH, MTECH, MCA, or MSC.
- 5–8 years of experience working with SQL, data warehousing (DWH), and data stewardship in enterprise environments.
- Strong hands-on SQL skills for data profiling, validation, reconciliation, and performance tuning.
- Experience supporting ETL processes and validating end-to-end data movement into a warehouse.
- Working knowledge of data governance concepts, data quality practices, and stewardship operating models.
- Experience building or supporting Power BI reporting with a focus on consistent metrics and trusted datasets. Technical requirements
- Primary skills: DWH, Data Steward, SQL Additional responsibilities Preferred Qualifications:
- Proven experience defining and operationalizing data governance frameworks (standards, controls, stewardship processes).
- Strong understanding of dimensional modeling, data marts, and enterprise reporting patterns.
- Experience with data lineage, metadata management, and business glossary implementation in collaboration with stakeholders.
- Ability to lead cross-functional discussions, influence data standards adoption, and drive closure on data quality issues.
- Experience optimizing ETL workflows and improving reliability, auditability, and reconciliation of warehouse loads.
- Advanced Power BI experience including data modeling, DAX measures, and performance optimization of reports/datasets. Education MCA,MTech,Bachelor of Engineering,BTech