Senior ETL Developer

Job Description:

Role Overview:
As a Senior ETL Developer, you will be responsible for designing, developing, and managing ETL processes that integrate data into our data warehouse. You will lead a cross-functional team of developers and analysts to ensure data is transformed, loaded, and optimized to meet business intelligence needs. In this role, you will collaborate with various teams across different geographies, including India and US, to deliver effective data solutions that support business goals. You will also have ownership over the data warehouse and BI tools, ensuring accuracy, integrity, and high performance across all data-related processes.

Key Responsibilities:
ETL Development & Management:

• Lead the development and maintenance of ETL processes to extract, transform, and load data from multiple sources into the data warehouse.
• Collaborate with cross-functional teams across geographies (India, US) to
• identify the right data sources, structure data problems, and deliver integrated solutions.
• Ensure that data is transformed into the correct format for the data warehouse and loaded accurately.
• Monitor the performance of ETL processes and optimize them for efficiency and scalability.
• Take ownership of the data warehouse architecture, ensuring data integrity and accuracy.

Business Intelligence Solutions:

• Work with business stakeholders to understand and define business requirements and translate them into technical specifications for data integration and BI solutions.
• Operationalize business intelligence solutions and conduct advanced analytics to identify opportunities that align with business goals.
• Develop and maintain data visualizations and reports that communicate key metrics and performance measures to business partners in an actionable manner.
• Collaborate with data governance teams to ensure that data quality issues are addressed and solutions are implemented.
• Develop analytical products that drive business growth.

Leadership & Team Management:

• Lead and mentor a BI development team, ensuring effective delivery of BI tools and solutions for the business.
• Perform management functions such as conducting performance reviews, setting team objectives, and monitoring progress towards achieving them.
• Provide guidance and coaching to BI developers and analysts to enhance their skills and professional growth.
• Foster long-term, value-added relationships with business partners to improve analytic capabilities across the organization.

Data Warehouse Design & Maintenance:

• Design and implement data warehouse flows and schemas based on business analysis, including staging, fact tables, dimensions, and reporting models in the semantic layer.
• Ensure data is structured in a way that is optimized for business analytics and reporting.
• Take full responsibility for the integrity of the data warehouse and the quality of all information loaded into it.

Process Improvement & Reporting:

• Identify process inefficiencies and recommend improvements to enhance the effectiveness and efficiency of the ETL workflows.
• Continuously improve the ETL design, data quality, and BI processes.
• Ensure that operational support for BI processes is available and that technical issues are resolved in a timely manner.
• Conduct regular KPI discussions and performance reviews with the BI development team to track progress and drive improvements.

Key Requirements:

Experience & Skills:

• 10-15 years of experience in ETL development, data warehousing, and business intelligence.
• Proven track record in leading BI development teams and managing complex data integration and analytics projects.
• Extensive experience with ETL tools and technologies (e.g., SSIS, Talend, Informatica).
• Expertise in working with relational and NoSQL databases, such as SQL Server, Oracle, MongoDB, Hive, and PostgreSQL.
• Strong knowledge of BI tools such as Power BI, Tableau, QlikView, and reporting tools like SSRS and Crystal Reports.
• Experience with cloud platforms and Big Data technologies (e.g., Hadoop, Hive, HBase).
• Hands-on experience in designing and implementing data models, data warehousing, and reporting layers.

Technical Expertise:

• Advanced proficiency in SQL and PL/SQL.
• Strong understanding of ETL design patterns and data warehouse architecture.
• Familiarity with data governance, data quality management, and semantic layer creation for BI reporting.
• Experience with Microsoft BI stack (SSIS, SSAS, SSRS) and data visualization tools.

Personal Attributes:

• Strong leadership and team management skills with the ability to mentor and coach junior developers.
• Excellent communication skills, with the ability to convey complex technical information to non-technical stakeholders.
• Strong problem-solving and analytical skills.
• Proactive in identifying opportunities for process improvements and ensuring efficient data workflows.
• Ability to work independently while collaborating effectively with cross- functional teams.

Preferred Qualifications:

• BI Reporting & Data Visualization Expertise:
• Ability to design interactive dashboards and reports using tools like Tableau, Power BI, or QlikView.
• Experience in developing actionable insights from data visualizations to support business decision-making.

Leadership Experience:

• Prior experience leading cross-functional teams in multiple geographies (India, US) is a strong advantage.