Sr. Snowflake Data Engineer with Power BI

Key Responsibilities: • Design, develop, and implement data solutions using Snowflake and Power BI for the market risk platform, which includes VaR (Value-at-Risk), sensitivities, and stress testing data. • Enhance and maintain existing Power BI models and cubes to ensure data accuracy, performance, and user accessibility (via Excel and Power BI Service). • Contribute to migrating the legacy credit risk platform (SQL Server, SSIS, SSAS, and SSRS) to the new Snowflake/Power BI architecture. • Develop and optimize ELT/ETL pipelines to ingest, transform, and load data into Snowflake, ensuring data quality and performance. • Collaborate with risk managers and other stakeholders to gather requirements, estimate project scope, and translate business needs into technical specifications. • Employ dbt (data build tool) for data modeling and transformation within Snowflake, ensuring data quality, lineage, and version control. • Develop custom solutions using Python for data analysis, transformation, and integration tasks. • Implement and maintain CI/CD pipelines for automated testing, deployment and monitoring of data solutions. • Participate in troubleshooting and resolving data-related issues, performance bottlenecks, and system errors within the Snowflake and Power BI environment. • Stay informed about industry trends and best practices in data warehousing, BI, and financial risk management. • Communicate effectively with non-technical stakeholders and manage expectations regarding project deliverables and timelines. • The capacity to plan, manage, and mentor junior developers, fostering their growth within the team. Functional / Technical Competencies: Essential: • Experience as a BI Developer or Data Engineer with a focus on Snowflake and Power BI. • Expertise in Snowflake, including data modeling (star/snowflake schemas), query optimization, and Snowflake-specific features (e.g., virtual warehouses, time travel). • Experience designing and developing data pipelines using ADF (Azure Data Factory). • Practical experience with dbt (data build tool) for data transformation and modeling in Snowflake. • Proficiency in Power BI, including dashboard and report creation, data visualization best practices, and DAX (Data Analysis Expressions). • Excellent SQL skills for data extraction, manipulation, and optimization. • Hands-on experience with Python for data processing, scripting, and automation. • Experience in the financial services industry, particularly with market risk concepts (VaR, sensitivities, stress testing). • Proficiency in writing high-quality Technical Scope documents and Test Plans. Preferred: • Experience with Control-M or other job scheduling tools for orchestrating data pipelines. • Experience with Streamlit for building interactive web applications for data visualization. • Experience with migrating legacy data platforms (SQL Server, SSIS, SSAS, SSRS) to cloud-based solutions like Snowflake/Power BI. • Experience reverse engineering Excel EUCs and implementing robust ELT processes to replace them. • Experience with Azure containers (e.g., Blob Storage) and Azure Data Lake Storage (Gen2). Personal Requirements: • Strong analytical and problem-solving skills, coupled with meticulous attention to detail and a commitment to accuracy. • Exceptional communication and interpersonal skills, enabling effective collaboration within a large, international team and with diverse stakeholders. • A proactive and results-driven approach, taking full responsibility for development tasks, testing, and debugging, and consistently delivering high-quality results in a fast-paced environment. • Excellent organizational skills and a disciplined, structured approach to working independently and under tight deadlines. • The ability to manage expectations and thrive in a dynamic environment, adapting quickly to change and prioritizing workload effectively. • Strong decision-making capabilities, consistently demonstrating sound judgment. • A fast-learning aptitude, quickly grasping and applying new information in a complex domain. • Strong English language speaking and writing skills for clear and effective communication.