Senior Data & Business Intelligence Engineer - ETL/T-SQL

Role Responsibilities: - Capture technical specifications, design, develop, test, implement, and support optimal data solutions including data warehouses, data stores, data lakes, dashboards and reports. - Examine sources of data through user interviews and data object analysis. - Craft optimal strategies for data integration process. - Responsible for development and deployment of new data platforms - Develop queries, views and stored procedures for ETL processes and pipelines. - Document data mappings, data dictionaries/definitions, processes, programs and solutions as per established standards for data governance. - Create, execute, and document unit test plans for data processes and programs. - Responsible for creating reusable and scalable data pipelines - Design and develop API solutions using data integration tools for interfacing between ERP source applications and Enterprise Data sources. - Oversee the Enterprise Data Management (EDM) governance process to ensure "a streamlined, standardized system for the company to find, manage, access, store, and secure their data". - Document and organize results and solutions for leadership and stakeholders, and address questions. - Implement data integration through the development of shared databases, modification and optimization of current systems, managing the exchange and storing of data, and making recommendations when upgrades or changes are needed to maintain smooth operations. - Responsible for creating reusable components for rapid development of data platform - Make improvements to the Data warehouse processes by crafting and assessing new formats for data interchange, rewriting expectations and procedures as needed, and improving logical and physical design. - Optimize data lake performance by dealing with any data conflicts that arise and keeping data definitions up to date. - Share & implement best practices by keeping track of new technologies and strategies for DW/data API/ETL, partaking in workshops and other educational opportunities, widening personal networks and reading industry publications. Qualifications & Skills: - Bachelor's degree in mathematics, statistics, computer science, data science, information technology, engineering or related field - 4 years of working experience in ETL, data warehousing, data lakes, reporting and operational data store. - Expertise in Microsoft SQL Server database and T-SQL is a must - Experience in creating complex stored procedures, materialized views - Experience in creating data pipelines using Azure Data Factory and T-SQL - Hands-on experience in implementing Azure cloud Data warehouse with hybrid data ingestion scenario's - Good understanding of OLAP data models design - Must have strong knowledge in Data warehouse design, modelling, ETL. - Must have strong knowledge in Azure cloud technologies and services - Hands on Experience in implementing Azure DevOps/ Git Hub for code versioning and deployments - Knowledge of Power shell scripting - Hands-on experience in Enterprise architecture to understand/change the downstream applications as needed. - Microsoft Power BI, No SQL, Synapse, Databricks experience a plus. - Experience in other cloud platforms like AWS a plus - Exposure with Big Data design, development and related technologies: AWS/Redshift, Hadoop, HDFS, along with reporting/analytical tools like Tableau and Alteryx. - Proven experience in creating, maintaining and collectively facilitating an Enterprise Data Management (EDM) governance process with the business data stewards. - Python, Java, and Scala programming languages a plus. - Must possess strong communication, collaboration, and presentation soft skills. - Strong analytical problem solving skills (ref:hirist.tech)

Location: Nagpur, IN

Posted Date: 4/24/2024