As a Data Warehouse and Analytics Architect, your role involves designing, developing, and maintaining the data warehouse and analytics architecture to meet business analysis and reporting needs. This includes ensuring the scale and reliability of a modern distributed system is at the core of your work. Your key responsibilities will include: - Successfully delivering client engagements and initiatives. - Providing subject matter expert input and advisory role input to client engagements, such as strategy and solution advisory, technical resource management, client workshop facilitation, and overall engagement management. - Writing stored procedures, functions, views, and triggers for various database systems. - Reviewing and evaluating existing stored procedures for performance improvements. - Collaborating with other development teams and analysts to support prototype solutions, demonstrating flexibility and accountability to ensure project progression. It is essential to always be learning and expanding the breadth of your expertise beyond your comfort zone to stay current with the evolving business landscape.,
As a Lead Data Analyst, you will be responsible for the technical implementation of current and future solutions in the Business Intelligence domain. Your proficiency in designing database architectures, data warehouses, data migrations, data marts, business intelligence packages, and implementing user reporting solutions based upon business requirements with a strong exposure to SQL is crucial for the success of the role. - Design, develop, and maintain the data warehouse and analytics architecture to meet business analysis and reporting needs, with a focus on the scale and reliability of a modern distributed system. - Lead the successful delivery of client engagements and initiatives. - Provide subject matter expert input and advisory role in client engagements including strategy and solution advisory, technical resource management, client workshop facilitation, and overall engagement management. - Write stored procedures, functions, views, and triggers for various database systems. - Review and evaluate existing stored procedures for performance improvements. - Collaborate with other development teams and analysts to support prototype solutions, ensuring project progression. - Stay updated with evolving technologies and continuously expand your expertise beyond your comfort zone to adapt to the changing business landscape. Essential Skills: - 6+ years of work experience in utilizing SQL in Analytics Deployment. - Domain knowledge of digital marketing is preferred. - Strong adaptability to unpredictable scenarios, logical and analytical thinking, and quick learning ability. - Profound knowledge of SQL, particularly in Business Intelligence and Analytics solutions. - Proficient scripting skills for data/file manipulation. - Solid background in Data Warehousing and Business Analytics environment. - Ability to interpret data schemas and work with various data sources such as Web Services, application API, XML, Relational Databases, Document-Oriented NoSQL databases, etc. - A degree in Computer Science or related technical field is preferred. Additional education in business or statistics is a plus. - Experience with AWS cloud-based services like S3, EC2, RDS, Redshift, Snowflake. - Excellent verbal and written communication skills. (Note: No additional company details were mentioned in the provided Job Description),