Senior Business Intelligence Developer

Opportunity Overview

We are seeking a highly skilled Senior Data Modeler with extensive experience in designing and optimizing data models across various environments. The ideal candidate will possess expertise in conceptual, logical, and physical data modeling, as well as knowledge of metadata management and modern data architecture concepts.

The successful applicant will collaborate with ETL and BI teams to ensure efficient data integration, governance, and performance tuning. This role requires strong analytical skills, attention to detail, and the ability to work effectively in an agile environment.

• Database Design & SQL
• Strong Expertise in SQL (DDL, DML, DCL)
• Deep understanding of RDBMS platforms (e.g., SQL Server, Oracle, PostgreSQL, MySQL)
• Experience with cloud databases such as Azure Synapse, Snowflake, Amazon Redshift etc.
• Knowledge of NoSQL systems (MongoDB, Cassandra) and modeling for semi-structured data (JSON, Parquet)
• Data Modeling Tools & Techniques
• Proficiency with tools such as Lucidchart, Erwin, Toad Data Modeler
• Strong command of conceptual, logical, and physical data modeling
• Ability to model for OLTP (transactional) systems and OLAP (analytical / data warehouse) environments
• Familiarity with dimensional modeling (star / snowflake schemas) for BI / analytics
• ETL / Data Integration
• Understanding of ETL pipelines and data ingestion processes
• Collaboration experience with ETL developers to align data flows with models
• Familiarity with tools like Azure Data Factory, Informatica, Talend, dbt, SSIS
• Metadata, Data Governance & Lineage
• Experience defining data dictionaries, business glossaries, and metadata repositories
• Awareness of data quality, governance, and master data management (MDM) principles
• Understanding of data lineage and impact analysis
• Performance Optimization
• Knowledge of indexing, partitioning, normalization / denormalization
• Ability to optimize query performance through model design and database tuning
• Analytical & Business Skills
• Ability to translate business requirements into data structures
• Experience working with business analysts and stakeholders to understand KPIs and reporting needs
• Strong analytical mindset with attention to data accuracy and consistency
• Understanding of domain data (e.g., finance, supply chain, healthcare)
• Cloud, Modern Data Stack & Emerging Skills
• Familiarity with modern data architectures — data lakes, lakehouses, and data mesh concepts
• Exposure to data integration patterns
• Exposure to data catalog tools (e.g., Collibra)
• Understanding of data modeling for BI / Analytics tools like Power BI, or Tableau
• Knowledge of Python / SQL for data transformations is increasingly valuable
• Experience with CI / CD for data models (e.g., dbt or Git-based version control)
• Soft Skills
• Excellent communication — able to explain technical models to non-technical stakeholders
• Collaboration with data engineers, analysts, and architects
• Strong documentation and attention to detail
• Ability to work in agile environments with iterative delivery
• Education
• Bachelor's or Master's in Computer Science, Information Systems, or a related field