AWS Data Architect

AWS Data Architect

Location: Montpelier Vermont or Dublin Ohio (100% Onsite)

Duration: FTE Only

Job Description:

As AWS Architect, you are responsible for the design and implementation of data warehouse solutions for all the reporting and analytical needs for our customers. This includes supporting traditional reporting and more advanced analyses based on artificial intelligence and machine learning. You start by developing a solution blueprint for the architecture.

Expertise Required:

• Overall 12+ years of Total IT experience with Minimum of 5 years of AWS cloud exp
• Expert in AWS cloud technologies (AWS Services such as Redshift, AWS Glue, AWS Lambda, SQS/SNS, Network setup, IAM and Integration with Active directory, masking and encryption, Governance tools – Lineage, Catalog, classifications. Infrastructure setup, Snowflake)
• Experience implementing AWS services in a variety of distributed computing, enterprise environments
• Understanding of database and analytical technologies in the industry including Data lake, Data Warehouse design, BI reporting, Dashboard development.
• Extensive hands-on experience in data warehousing design, tuning and ETL/ELT process development along with excellent Change Data Capture methodologies understanding
• Strong experience with designing and engineering performance with Relational Databases, SQL and ETL/ELT tools/processes
• Strong experience with Data modeling to create Relational Data Warehouse model
• Seasoned Python programming skills
• One of the AWS Associate level certifications or AWS Certified Cloud Practitioner.
• Certified Scrum Master

Responsibilities:

• Facilitate daily call with team to discuss status, questions, knowledge transfer. Assist with documenting needs, actions items. Manage each project’s scope and timeline
• Coordinate daily stand-ups, planning, and retrospective meetings
• Mentor team members in Agile frameworks
• Facilitate internal communication with various stakeholders and effective collaboration
• Be the point of contact for external communications (e.g. from end customers or stakeholders) as required
• Work with product owners to handle & prioritize backlogs and new requests
• Resolve conflicts and remove blockers that occur. Help teams implement changes effectively
• Ensure deliverables are up to quality standards at the end of each sprint.
• Guide development teams to higher scrum maturity. Help build a productive environment where team members ‘own’ the product and enjoy working on it
• Assist with creation of a robust, sustainable architecture that supports requirements and provides for expansion with secured access
• Work with customers, end users, technical architects, and application designers to define the data requirements and data structure for BI/Analytical solutions
• Managing customer expectation and business user interactions would be a key responsibility
• Designs conceptual and logical models for the data warehouse or data mart (data structure, storage, and integration). Lead the database analysis, design, and implementation effort
• Communicates physical database designs to lead data architect / database administrator
• Evolves models to meet new and changing business requirements
• Work with business analysts to identify and understand requirements and source data systems
• Design maps of source system data to data warehouse models
• Develop and test extraction, transformation, and loading (ETL) processes
• Define and capture metadata and rules associated with ETL/ELT processes
• Ensure that the database designs fulfill the requirements, including data volume, frequency, and long-term BI/Analytics growth requirements
• Work with other architects to ensure that all components work together to meet objectives and performance goals as defined in the requirements
• Participate in code and quality management reviews
• Provide operational support for Management Information Systems (MIS)