Lead Software Engineer
- Gartner for HR
- 6 - 8 years
- Chennai
- 4 months ago
- Email to a friend
- Report this job
Job Description
- Provide technical leadership and guidance to software development teams, guaranteeing alignment with project objectives and adherence to industry best practices.
- Leading and mentoring a team of software engineers, delegating responsibilities, offering support, and promoting a collaborative environment.
- Collaborate with business stakeholders, design, build advanced analytic solutions for Gartner Conference Technology Business.
- Execution of our data strategy through design and development of Data platforms to deliver Reporting, BI and Advanced Analytics solutions.
- Design and development of key analytics capabilities using MS SQL Server, Azure SQL Managed Instance, T-SQL & ADF on Azure Platform.
- Consistently improving and optimizing T-SQL performance across the entire analytics platform.
- Create, build, and implement comprehensive data integration solutions utilizing Azure Data Factory.
- Development of reports and dashboards using Power BI.
- Analyzing and solving complex business problems, breaking down the work into actionable tasks.
- Develop, maintain, and document data dictionary and data flow diagrams
- Responsible for building and enhancing the regression test suite to monitor nightly ETL jobs and identify data issues.
- Work alongside project managers, cross teams to support fast paced Agile/Scrum environment.
- Build Optimized solutions and designs to handle Big Data.
- Follow coding standards, build appropriate unit tests, integration tests, deployment scripts and review project artifacts created by peers.
- Contribute to overall growth by suggesting improvements to the existing software architecture or introducing new technologies.
What you ll need:
Strong IT professional with high-end knowledge on Designing and Development of E2E BI & Analytics projects in a global enterprise environment. The candidate should have strong qualitative and quantitative problem-solving abilities and is expected to yield ownership and accountability.
Must have:
- Strong experience with SQL, including diagnosing and resolving load failures, constructing hierarchical queries, and efficiently analyzing existing SQL code to identify and resolve issues, using Microsoft Azure SQL Database, SQL Server, and Azure SQL Managed Instance.
- Ability to create and modifying various database objects such as stored procedures, views, tables, triggers, indexes using Microsoft Azure SQL Database, SQL Server, Azure SQL Managed Instance.
- Deep understanding in writing Advance SQL code (Analytic functions).
- Strong technical experience with Database performance and tuning, troubleshooting and query optimization.
- Strong technical experience with Azure Data Factory on Azure Platform.
- Create and manage complex ETL pipelines to extract, transform, and load data from various sources using Azure Data Factory.
- Monitor and troubleshoot data pipeline issues to ensure data integrity and availability.
- Extensive hands-on experience with Azure Data Factory, Databricks, Synapse Analytics, Azure SQL, and Data Lake.
- Experience working with dataset ingestion, data model creation, reports, dashboards using Power BI.
- In-depth understanding of Microsoft Fabric architecture, data integration, and its components (Data Engineering, Data Factory, Data Warehouse, etc.), with the capability to lead migration of existing ETL and analytics solutions to Microsoft Fabric.
- Enhance data workflows to improve performance, scalability, and cost-effectiveness.
- Establish best practices for data governance and security within data pipelines.
- Experience in Cloud Platforms, Azure technologies like Azure Analysis Services, Azure Blob Storage, Azure Data Lake, Azure Delta Lake etc.
- Experience with data modelling, database design, and data warehousing concepts and Data Lake.
- Ensure thorough documentation of data processes, configurations, and operational procedures.
Good to Have:
- Experience with Python and Azure Function for data processing.
- Demonstrated Ability to use GIT, Jenkins and other change management tools.
- Good knowledge of database performance and tuning, troubleshooting and query optimization.
Who you are:
- Graduate/Post-graduate in BE/Btech, ME/MTech or MCA is preferred.
- IT Professional with 6-8 yrs of experience in Data analytics, Cloud technologies and ETL development.
- Excellent communication and prioritization skills.
- Able to work independently or within a team proactively in a fast-paced AGILE-SCRUM environment.
- Strong desire to improve upon their skills in software development, frameworks, and technologies.
Job Classification
Industry: Analytics / KPO / ResearchFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse Architect / ConsultantEmployement Type: Full timeContact Details:
Company: Gartner for HRLocation(s): Chennai+ View Contact
Keyskills: MS SQL Change management GIT Coding Database design Stored procedures microsoft SQL Python Recruitment
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Gartner for HR
We deliver actionable, objective insight to executives and their teams. Our expert guidance and tools enable faster, smarter decisions and stronger performance on an organization's mission-critical priorities. Our unrivaled combination of expert-led, practitioner-sourced and data-driven researc...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in