Desired Competencies (Technical / Behavioral Competency) :
Must-Have :
- 8+ years of experience and played the role of data architect at least 3 years on Data Warehouse and Analytics solutions
- 3+ years of experience with any of the cloud (AWS, Azure and GCP) and strong knowledge of Ingestion and consumption process in Data Lake
- 3+ years of experience in cloud based EDW platforms (Snowflake, Redshift, BiqQuery, Synapse etc.)
- 3+ years of building and launching new data models that provide intuitive analytics for the analysts and customers
- Strong experience working with and analyzing large datasets within the relevant domains of
enterprise data
Strong experience in Data Warehouse ETL design and development, methodologies, tools, processes and best practicesGood knowledge of RDBMS topics, ability to write complex SQL, PL / SQL, UNIX scripts etc.Understanding of performance tuning and troubleshooting aspectsCommunication and presentation experience with proven track record of using insights toinfluence executives and colleagues
Good-to-Have :
Awareness or expertise in data security and data access controls and design aspectsAwareness or expertise in DevOps tools like GitHub, Cloud DevOps, etc.Awareness or expertise in monitor the system performance by performing regular tests, troubleshooting and integrating new featuresExperience with development frameworks (SCRUM / Agile)Recommend solutions to improve cloud and existing Datawarehouse solutionsSN Role descriptions / Expectations from the Role :
Lead, analyze, design and deliver analytics solutions and applications including statistical data models, reports, and dashboards in cloud and corresponding cloud EDW database platformUse leadership abilities to drive cross functional development on new solutions from design through deliveryDemonstrate the new capabilities of advanced analytics to business and technology teams to show the potential of the Data platformWork with key stakeholders in product management and leadership to define strategy and requirementsContribute to high-level architecture and drives low-level designWork with all stakeholders to deliver supporting software and services in sync with timelinesOffer insight, guidance and direction on the usage of emerging data analytics trends and technical capabilitiesEducate junior colleagues through training and individual supportEmploy industry best practices to deliver world-class solutions.Ensure developed solutions remain compliant with standardsref : hirist.tech)