Business Analyst cum Developer

As a Business Analyst at our company, your role will be to maintain, optimize, and build database workflows, data pipelines, and automation scripts to support internal dashboards and operational tracking. You will work closely with the Business Excellence - Analytics team to ensure data-driven decision-making processes are in place. Key Responsibilities: - Design, write, and optimize complex MS SQL (MSSQL) queries, views, stored procedures, and functions to handle large datasets efficiently. - Identify database primary key constraints, handle data exceptions, and eliminate processing duplicate keys to maintain data integrity. - Develop and maintain basic automation scripts or data cleaning pipelines using Python (Pandas, NumPy, etc) for streamlined operations. - Collaborate with business excellence and engineering teams to map data requirements for analytics and visualization dashboards effectively. - Investigate data variances and performance bottlenecks in SQL databases to ensure accurate business reporting for informed decision-making. Technical Skills Required: - Advanced MS SQL Server: Strong proficiency in writing complex joins, subqueries, CTEs, window functions, stored procedures, and performance tuning for optimized database operations. - Basic Python: Familiarity with Python scripting for data manipulation, file handling, and basic automation tasks to enhance workflow efficiency. - Data Understanding: Experience working with structured data architectures and rules-engine database configurations to ensure data accuracy and reliability. Experience Education: - Graduate/Postgraduate with 2 years of core experience in data analytics or database operations to bring valuable insights and expertise to the role. Please note that this job posting has been aggregated from an external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying. As a Business Analyst at our company, your role will be to maintain, optimize, and build database workflows, data pipelines, and automation scripts to support internal dashboards and operational tracking. You will work closely with the Business Excellence - Analytics team to ensure data-driven decision-making processes are in place. Key Responsibilities: - Design, write, and optimize complex MS SQL (MSSQL) queries, views, stored procedures, and functions to handle large datasets efficiently. - Identify database primary key constraints, handle data exceptions, and eliminate processing duplicate keys to maintain data integrity. - Develop and maintain basic automation scripts or data cleaning pipelines using Python (Pandas, NumPy, etc) for streamlined operations. - Collaborate with business excellence and engineering teams to map data requirements for analytics and visualization dashboards effectively. - Investigate data variances and performance bottlenecks in SQL databases to ensure accurate business reporting for informed decision-making. Technical Skills Required: - Advanced MS SQL Server: Strong proficiency in writing complex joins, subqueries, CTEs, window functions, stored procedures, and performance tuning for optimized database operations. - Basic Python: Familiarity with Python scripting for data manipulation, file handling, and basic automation tasks to enhance workflow efficiency. - Data Understanding: Experience working with structured data architectures and rules-engine database configurations to ensure data accuracy and reliability. Experience Education: - Graduate/Postgraduate with 2 years of core experience in data analytics or database operations to bring valuable insights and expertise to the role. Please note that this job posting has been aggregated from an external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.