Location: Montpelier Vermont (Hybrid), so look for candidates from VT or nearby states
Duration: 6+ Months
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)
Soft skills like leading the team, taking ownership and accountability to successful engagement
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at Zortech Solutions by 2x