AWS Data Warehouse Architect (769)

**Axtria, Inc.****AWS Data Warehouse Architect (769)****BIM - Berkeley Heights, NJ - Full Time**Axtria is a global provider of cloud software and data analytics to the Life Sciences industry. We help Life Sciences companies transform the product commercialization journey to drive sales growth and improve healthcare outcomes for patients. We are acutely aware that our work impacts millions of patients and lead passionately to improve their lives.Since our founding in 2010, technology innovation has been our winning differentiation, and we continue to leapfrog competition with platforms that deploy Artificial Intelligence and Machine Learning. Our cloud-based platforms - Axtria DataMax, Axtria InsightsMax, Axtria SalesIQ, and Axtria MarketingIQ - enable customers to efficiently manage data, leverage data science to deliver insights for sales and marketing planning and manage end-to-end commercial operations.With customers in over 75 countries, Axtria is one of the largest global commercial solutions providers in the Life Sciences industry. We continue to win industry recognition for growth and are featured in some of the most aspirational lists - INC 5000, Deloitte FAST 500, NJBiz FAST 50, SmartCEO Future 50, Red Herring 100, and several other growth and technology awards.**Objective -** Overall 12-15 years of experience in ETL, Data warehousing and AWS Solution/technology. Understanding of commercial Data Landscape and its functional use cases.**Responsibilities :*** Design & Build Cloud infrastructure, and data management processes to move the organization to a more sophisticated, Agile, and robust target state data architecture* Develop systems that ingest, cleanse, and normalize diverse datasets, develop ETL/ELT data pipelines from various internal and external data sources* Develop understanding of how data will flow & stored through an organization across multiple applications* Design & develop data management and data persistence solutions for application use cases leveraging relational, non-relational databases and enhancing our data processing capabilities* Develop POCs to influence platform architects, Business Stakeholders, and software engineers to validate solution proposals and migrate* Work with data and analytics experts to strive for greater functionality in our data systems.* Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.* Constantly assist other writers in developing knowledge and sharing expertise* Identify data engineering needs and implement optimal solutions.* Develop data sets for specific analysis projects, dashboards and applications, and general reuse.* Automation of data management processes* CI/CD Pipelines for automated deployment* Migration of on-premise systems to cloud using Big Data Technologies* Project planning & execution using Agile methodologies. Design & Build Cloud infrastructure, and data management processes to move the organization to a more sophisticated, Agile and robust target state data architecture* Develop systems that ingest, cleanse, and normalize diverse datasets, develop data pipelines from various internal and external sources* Develop good understanding of how data will flow & stored through an organization across multiple applications* Design & develop data management and data persistence solutions for application use cases leveraging relational, non-relational databases and enhancing our data processing capabilities* Develop POCs to influence platform architects, Business Stakeholders, and software engineers to validate solution proposals and migrate* Work with data and analytics experts to strive for greater functionality in our data systems.* Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.* Constantly assist other writers in developing knowledge and sharing expertise* Identify data engineering needs and implement optimal solutions.* Develop data sets for specific analysis projects, dashboards and applications, and general reuse.* Automation of data management processes. Optimize the existing processes with creative and innovative ideas* Migration of on-premises systems to cloud using Big Data Technologies* Project planning & execution using Agile methodologies. Provide timely status reporting with management and business partners.* Process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.* Enable Data Scientist & Business users to run their processes efficiently* Process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.* Enable Data Scientist & Business users to run their processes efficiently* Build environment to support development, System Testing, UAT and Production, cycle phases using SDLC methodologies.* Manage and maintain the overall project tasks and timeline. Ensure all project milestone dates are agreed upon and achieved.* Experience in deploying application on Docker and Containers* Experience in deploying and managing various AWS services EC2, EMR, S3, ECR, ECS, Redshift and No SQL DB* Automated Deployment and code versioning tools like Jenkins, Git etc.