About the role
Key Responsibilities
• Design and develop subject-specific data marts based on business requirements
• Build and optimize ETL/ELT pipelines for data extraction, transformation, and loading
• Develop dimensional models (star/snowflake schemas) for reporting and analytics
• Ensure data quality, consistency, and integrity across data systems
• Collaborate with BI teams and stakeholders to deliver reporting solutions
• Monitor and optimize performance of data pipelines and queries
• Maintain documentation for data models, processes, and workflows
Required Skills:
• Strong SQL and data modeling expertise
• Experience with ETL tools (e.g., Informatica, Talend, or similar)
• Hands-on experience with data warehousing platforms (e.g., Snowflake, Redshift, BigQuery)
• Knowledge of dimensional modeling and data mart design principles
• Familiarity with scripting languages (Python preferred)
• Experience with BI tools (e.g., Power BI, Tableau)