Description

You will design and implement end-to-end Business Intelligence solutions to support commercial organizations including Finance, CRM, Sales, and Marketing.

Responsibilities

• Design conceptual, logical, and physical data models including Star and Snowflake schemas.
• Develop and performance tune complex SQL, PL/SQL, and T-SQL queries and stored procedures.
• Evaluate business requirements, conduct POCs, and map them to technical system requirements.
• Perform end-to-end data validation and proactively identify data anomalies within source systems.
• Manage multiple time-sensitive assignments and ad-hoc requests simultaneously.

Required Skills

• 10+ years of experience in database development using packages, stored procedures, and triggers.
• 7-10 years of experience in dimensional modeling and maintaining dimensions using Slowly Changing Dimensions (SCD).
• 7+ years of experience in SQL performance tuning and optimization techniques.
• Expertise in SQL and PL/SQL.
• Proficiency with scripting languages such as Python, Unix, or Perl for batch processing.
• Experience using Jira and GitHub for project tracking.
• Ability to translate complex business requirements for stakeholder buy-in.

Preferred Skills

• Experience with Salesforce (SOQL) or other CRM source systems.

Key Skills

Education

Any Gradute