Architect

Role Description (and additional job description) As a Business Intelligence (BI) Architect you will be instrumental in driving data-driven decision-making across our BICoE Vendor lead organisation. You will design, develop, and implement robust BI solutions that provide actionable insights to leadership. This involves architecting data marts, constructing robust data pipelines, and automating reporting processes. Your ability to transform complex data into compelling visualizations will be crucial in helping stakeholders understand the business impact of their decisions. You will collaborate closely with cross-functional teams to deliver high-quality data solutions that support our growth objectives. Responsibilities Develop robust data infrastructure, which includes building SQL scripts, creating data pipelines, data warehouses, crafting analytical models, and designing user-friendly dashboards. Transform data into actionable insights by developing data models, data marts, and automating reporting processes to provide leadership with a clear picture of key business and process performance. Lead solution design of assigned projects from conceptualization to delivery and ensure your data solutions offer relevant, high-quality data and insights to propel the growth of the business. Review codes prepared by the TPMs and analysts from the vendor organisation before it hits the queue of FTEs Revamp and look into the access control architecture and suggest changes needed for effective scale and reducing bad technical debt which would help FTEs to evaluate the codebase. Review Code change logs for implementation. Be the first point person for code approvers for the TVC team. Support the FTEs to evaluate long codes Minimum Qualifications (MQs) Bachelor's degree or equivalent practical experience. 12+

years of experience writing SQL queries and building data pipelines. 10+ years of Solution Design , Code review and optimisation of pipelines 10+ years of being a SME for a technical team and helping team build and design solutions end to end 10+ years using BI tools like Looker, Tableau, or Power BI to create simplified merging of data sources and source files to reduce complexity Skills Needed Expert level of SQL scripting / Expert level of Looker or PowerBI or Tableau / Expert in Code Review of Logs YAML/SQLM