Data Architect, Professional Services, Insights Team

Key Skills

Java Programming, Design of Experiment, Python Programming, SQL, AWS, PowerBI, Apache Hadoop, Scala Programming, Machine learning techniques, Perl Programming, ETL/ELT technologies, NoSQL, Amazon Athena, Amazon RedShift, CSS3, SPARK Programming, Lambda, Bash scripting

Job Description

Job summary

Are you a Data Warehousing (DW) specialist? Do you want to have an impact in the development and use of new Analytics technologies? Come join us! Amazon Web Services (AWS) offers a comprehensive set of services to handle every step of the analytics process chain including data warehousing, business intelligence, batch processing, stream processing, machine learning, and data workflow orchestration. Amazon Redshift offers a fully managed, petabyte-scale data warehouse that integrates cleanly with existing business intelligence tools. Amazon QuickSight delivers fast, easy-to-use business analytics and visualization for customers looking to build new applications. In combination with other AWS services, these core DW tools allow customers to extract the maximum business value from their operational and transactional data.

We are looking for a Data Architect, who will be the Subject Matter Expert (SME) for helping AWS Professional Services (ProServe) leverage the analytics services on AWS to solve their data warehouse needs. This role will specifically focus on data warehousing and data warehouse modernization. The role is to help ProServe to eliminate technical and economic constraints from their legacy operational data store and help them to leverage their data to develop business insights. The candidate will focus on customer solutions such as data warehousing, data governance, business intelligence and advanced analytics, as well as helping customers to define, develop and implement the data architecture for enterprise data.

Key job responsibilities

• Architect, implement and maintain robust enterprise level data warehouse, data lake
• Develop an architecture to deploy machine learning models
• Develop and optimize data tables using best practices for partitioning, compression, parallelization, etc.
• Build robust and scalable data integration (ETL/ELT) pipelines using SQL, Python and AWS services such as Data Pipelines, Glue, Lambda, S3, Athena, Redshift
• Implement data structures using best practices in data modeling, ETL/ELT processes
• Establish the roadmap for enterprise data governance based upon strategic business objectives, existing capabilities, cultural considerations and a general understanding of emerging technologies and governance models.
• Interface with business customers, gathering requirements and architect complete reporting solutions
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers
• Work closely with business owners, analysts, Business Intelligence Engineers to explore new data sources and deliver the data for decision making

A day in the life

This role's primary focus is working with analysts and business leaders across the world to improve the data infrastructure that leads to better decision making. This role will meet with customers, understand their data needs, and work backwards to develop new data capabilities as the organization scales.

About the team

Inclusive Team Culture

Here at AWS, we embrace our differences. We are committed to furthering our culture of inclusion. We have ten employee-led affinity groups, reaching 40,000 employees in over 190 chapters globally. We have innovative benefit offerings, and host annual and ongoing learning experiences, including our Conversations on Race and Ethnicity (CORE) and AmazeCon (gender diversity) conferences. Amazon’s culture of inclusion is reinforced within our 16 Leadership Principles, which remind team members to seek diverse perspectives, learn and be curious, and earn trust.

Work/Life Balance

Our team puts a high value on work-life balance. It isn’t about how many hours you spend at home or at work; it’s about the flow you establish that brings energy to both parts of your life. We believe striking the right balance between your personal and professional life is critical to life-long happiness and fulfillment. We offer flexibility in working hours and encourage you to find your own balance between your work and personal lives.

Mentorship & Career Growth

Our team is dedicated to supporting new members. We have a broad mix of experience levels and tenures, and we’re building an environment that celebrates knowledge sharing and mentorship. We care about your career growth and strive to assign projects based on what will help each team member develop into a better-rounded professional and enable them to take on more complex tasks in the future.

BASIC QUALIFICATIONS

• Bachelor’s degree, or 7+ of relevant work experience, in Computer Science, Engineering, Mathematics or a related field
• 5+ years Hands-on experience in the design, development and deployment of enterprise data lakes or traditional data warehouse at scale
• Hands on experience in data warehousing design, tuning and ETL/ELT process development
• Knowledge of data landscape including the DWH/Spark/Hadoop Ecosystem
• Extensive experience leading in large-scale global data warehousing, analytics full-cycle data lake projects
• Experience with SQL and scripting (bash, perl, scala or python) ability
• Experience leading enterprise data strategies including data governance, data warehouse, BI architecture
• Hands on experience in leading large-scale enterprise data warehousing (EDW) projects

PREFERRED QUALIFICATIONS

• An advanced degree in computer science, MIS, engineering or related discipline
• Experience in a Chief Architect role or similar with AWS Certification, e.g. AWS Solutions Architect, Developer, or SysOps Associate/Professional
• Understanding of database and analytical technologies in the industry including NoSQL storage, Data Lake design, BI reporting and Dashboard development
• Strong organizational and project management skills with an ability to manage numerous, competing demands from internal and external stakeholders and Customers
• Ability to think strategically about business, product, and technical challenges of data analytics in an enterprise environment
• Ability to communicate complex topics to an audience with various functional knowledge
• Demonstrated industry leadership in the fields of Data Warehousing, Data Science and Big Data related technologies

Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.