BI Engineer

SRS Business Solutions India is seeking a highly motivated and result-oriented BI Engineer to join our team. The ideal candidate will be a self-starter with expert data modeling skills, capable of developing robust Business Intelligence solutions for our Commercial Organizations (Finance, CRM, Sales, Sales Operations, Marketing). This role demands strong analytical abilities, a keen eye for data quality, and excellent communication skills to translate business needs into technical solutions.

Key Responsibilities

• Data Modeling & Solution Development: Possess expert data modeling skills, including conceptual, logical, and physical model design. Participate actively in the development of Business Intelligence solutions to meet the needs of various Commercial Organizations.
• Requirements Evaluation & Data Quality: Evaluate complex business requirements, conduct Proofs of Concept (POCs), and proactively identify and flag data anomalies within source systems. Perform end-to-end data validation for solutions, ensuring the delivery of high-quality data.
• SQL Development & Performance Tuning: Develop and performance-tune complex SQL (PL/SQL and/or T-SQL) queries and stored procedures.
• Automation & Scripting: Able to manage batch processes using any scripting language like Perl, Unix, or Python.
• Strategic Design & Communication: Create strategic designs and mappings of business requirements to system/technical requirements. Effectively communicate, translate, and simplify complex business requirements to ensure buy-in from all stakeholders.
• Project Management & Collaboration: Be well-versed with project tracking tools like Jira and Github. Work on ad-hoc requests and manage simultaneous projects or tasks effectively.

Requirements

• Database Development: 7-10 years of experience with Database Development using Packages/Stored Procedures/Triggers in SQL and PLSQL.
• Dimensional Modeling: 7-10 years of experience in Dimensional Modeling, Star and Snowflake Schemas design, and maintaining dimensions using Slowly Changing Dimensions (SCD).
• SQL Performance Tuning: 7+ years of experience in SQL performance tuning and optimization techniques.
• Source Systems (Plus): Experience with source systems like Salesforce (SOQL), NetSuite, or any other CRM is a plus.
• Soft Skills: Effective and positive communication and Team working skills.
• Work Ethic: Ability to work on ad-hoc requests and simultaneously on multiple projects or tasks. Result-oriented, self-starter, and self-motivated, capable of managing multiple time-sensitive assignments.