Job Description :
Role: BI Solution Architect with AWS expertise (Jr/Mid-level) Location: Carlsbad, CA Job Description: Drive BI solutions and develop technical designs that support business requirements and follows the enterprise architecture strategy. Align software solutions with application and infrastructure teams to meet business goals. Create and maintain standards and templates pertaining to specific BI related solutions in partnership with the Enterprise Architect and Data Architect across all businesses and functions. Oversee and lead the BI projects delivery. Own ensuring our business intelligence footprint is leveraged across the enterprise to facilitate value creation and forward-looking strategy Lead work with application and infrastructure development teams to collaboratively complete business initiatives Design standard solution templates using reference architectures for applications, data, and technology that use/re-use common technology platforms Facilitate design workshops with stakeholders and secure sign offs needed to finalize the solution design Identify opportunities to standardize and simplify any related solution architecture across the divisions to reduce operational cost and increase efficiency Develop, maintain, and execute processes for enforcement of technology standards, policies, and procedures by the solution team. Review and approve all updates to the project design deliverables. Remain current regarding IT industry trends, emerging technologies, and best practices in the industry. Promote awareness of new/emerging technologies. Teach others on how to leverage these technologies to create meaningful and sustainable business value Developing technology specifications and ensuring that new technology solutions are designed for optimal access and usefulness, and leveraging existing technologies when possible Applying architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability Identifying the technologies to employ based on price, performance, service agreements and organization constraints Required Skill Set: 5+ years of experience delivering business intelligence solutions 2+ years of experience in architecting, planning, implementing and maintaining AWS Cloud solutions Thorough understanding of data warehousing concepts required Experience working with AWS data lakes & streaming data is a plus Capabilities to provide deployment guidance and best practices Strong experience with SQL (preferred) Good analytical and problem solving skills Must be knowledgeable in software development lifecycles/methodologies i.e. agile Has strong presentation and collaboration skills and can communicate all aspects of the job requirements, including the creation of formal documentation Fluent in relational database concepts and flat file processing concepts Experience working with databases SQL Server, Oracle & AWS Redshift