Senior Datawarehouse Engineer - ETL/Power BI

Key Responsibilities :

- Data Warehouse Development: Responsible for managing a single version of the truth and turning data into critical information and knowledge that can be used to make sound business decisions.

- Dimensional Modeling: Convert business entities into facts and dimensions to provide a structured and efficient data model that supports accurate and insightful business analysis.

- Data Integration: Collaborate with cross-functional teams to integrate data from various source systems such as Oracle NetSuite, Salesforce, Ragic, SQL Server, MySQL, and Excel files.

- Data Transformation: Develop and maintain ETL processes using Microsoft SSIS, Python or similar ETL tools to load data into the data warehouse.

- Performance Optimization: Optimize queries, indexes, and database structures to improve efficiency.

- Requirement Analysis: Work closely with key users and business stakeholders to define requirements.

- Documentation: Maintain comprehensive technical documentation for data warehouse processes, data integration, and configurations.

- Team Collaboration: Mentor and guide junior team members, fostering a collaborative environment.

Required Skills :

Must have :

- Bachelors or Masters degree in Computer Science, Information Technology, or a related field.

- 7+ years of experience with Microsoft SQL Server.

- Expertise in building Data Warehouse using SQL Server.

- Hands-on experience Dimensional Modeling using Facts and Dimensions.

- Expertise in SSIS and Python for ETL development.

- Strong experience in Power BI for reporting and data visualization.

- Strong understanding of relational database design, indexing, and performance tuning.

- Ability to write complex SQL scripts, stored procedures and views.

- Experience with Git and JIRA.

- Problem-solving mindset and analytical skills.

- Excellent communication and documentation abilities.

Nice to Have :

- Experience with cloud-based SQL databases (e.g., Azure SQL, Azure Synapse).

- Experience with cloud-based ETL solutions (Azure Data Factory, Azure Databricks).

- Familiarity with CI/CD for database deployments and automation tools.

- Knowledge of big data technologies like Snowflake