Solutions Architect

Solutions Architect

Madison, WI, United States and 1 more

Job Description

As a hands-on Solutions Architect, you will be responsible for designing and implementing solutions that leverage AWS services, Data Lakes, and Data Warehouses to solve complex business problems. You will work closely with our clients and internal teams to deliver scalable, high-performance architecture that meets business objectives.

RESPONSIBILITIES

• Design and implement robust, scalable, and high-quality data solutions on AWS.
• Collaborate with stakeholders to understand business requirements and translate them into technical specifications.
• Provide leadership and expertise in the development of standards, architectural governance, design patterns, and best practices.
• Ensure security, integrity, and consistency of critical user and business data.
• Conduct system performance analysis, tuning, and capacity planning.
• Define migration strategies for moving legacy systems to AWS-based solutions.
• Provide training and mentorship to other team members on AWS solutions, data lake management, and data warehousing concepts.
• Implement custom code solutions in places of the data pipelines where the tooling has gaps e.g. custom lambda implementations etc.
• Stay abreast of new AWS services and other technologies relevant to data architectures.
• Design, implement, and manage security measures to protect AWS-based cloud systems.
• Monitor and analyze security events and incidents and respond to threats in a timely manner.
• Conduct security assessments, vulnerability scans, and penetration tests.
• Develop and enforce security policies, procedures, and standards
• Work with DevOps and development teams to integrate security into the SDLC as well as CI/CD pipelines.
• Ensure compliance with relevant regulations and industry standards (e.g., GDPR, HIPAA, PCI-DSS).
• Implement and manage identity and access management (IAM) controls.
• Stay current with emerging security threats and technologies and provide recommendations for improvement.
• Collaborate with Data Lakes, and Data Warehouses teams

REQUIREMENTS

• Strong communication and interpersonal skills, with the ability to convey complex concepts to non-technical stakeholders, as well as discuss and design advanced concepts with senior technical engineers and architects
• Knowledge of data modeling, data access, and data storage techniques, including data lifecycles.
• Excellent problem-solving skills and the ability to think analytically
• Solid experience in designing and implementing data lakes and data warehouse solutions.
• Strong understanding of advanced AWS services related to computing, storage, database, networking, analytics, and security
• Must have extensive Terraform experience, including managing entire clouds in IaC, this role will include hands-on design and implementation
• Hands-on experience with AWS services such as Lambda, Fargate, S3, RDS, DMS, Glue, Athena, EMR, SNS/SQS/EventBridge, Databricks
• Expert in IAM, multi-account clouds, Control Tower & AWS security (config, security hub, etc.)
• Proficiency in SQL (MySQL, Redshift, Snowflake) and experience with scripting languages (PySpark, Python, Bash)
• Experience managing CI/CD practices, tools, related environments and pipelines
• Hands on development experience with software development using Python or TypeScript to create custom code solutions for customized data pipelines
• Hands on experience with NoSQL (DocumentDB/MongoDB)
• Solid understanding of Data Lakes, Delta Lakes, Data Warehouse, Data Mart and able to contribute to the design and implementation of analytic pipelines and platforms

EDUCATION & EXPERIENCE

• Bachelor's degree in computer science, engineering, information technology, or related experience on cloud platforms.
• AWS Solutions Architect Certificate preferred