Data WarehouseCloud Architect

Data Warehouse/Cloud Architect

Location: Harrisburg PA (Remote)

Contract Duration: 12 months

Job Description:

In this position you will apply your skills to manage the existing cloud data platform to make it more scalable reliable and cost efficient. You will also work on additional projects that would leverage the existing architecture in some cases and use newer technologies where needed.

Primary Responsibilities:

• Define and align on strategic initiatives pertaining to Data and Analytics Architecture
• Design and develop data lakes manage data flows that integrate information from various sources into a common data lake platform through an ETL Tool and support near real time use cases as well.
• Design repeatable and reusable solution architectures and data ingestion pipelines for bringing in data from ERP source systems like SAP.
• Manage data integration with tools like Databricks and Snowflake or equivalent data lake and data warehouses.
• Design and Develop Data warehouses for Scale.
• Design and Evaluate Data Models (Star Snowflake and Flattened)
• Design data access patterns for OLTP and OLAP based transactions.
• Triage debug and fix technical issues related to Data Lakes and Data Warehouses
• Serve and Share data through modern data warehousing tools and practices.
• Coordinate with Business and Technical teams through all the phases in the software development life cycle.
• Participate in making major technical and architectural decisions.
• Handson prototyping of new technology solutions by working with cross teams

You Must Have:

• 5 Years of Experience operating on AWS Cloud with building Data Lake and data warehousing architectures.
• 5 Years of Experience building Data Warehouses on Snowflake Redshift HANA Teradata Exasol etc.
• 3 Years of Experience with AWS Data services like S3 Glue Lake Formation EMR Kinesis RDS DMS and others
• 3 Years of Experience with Data Modelling experience
• 3 Years of working knowledge in Spark or equivalent big data technologies.
• 3 Years of Experience in building Delta Lakes using technologies like Databricks.
• 3 Years of working experience in ETL tools like Talend Informatica SAP Data Services etc.
• 3 Years of Experience in any programming language (Python R Scala Java)
• 3 Years of Experience working with ERP systems like SAP focusing on data integration.
• Good understanding and implementation experience on GenAI models available with Cloud hyperscalers.
• AWS Bedrock experience is a plus but not required.
• Bachelors degree in computer science information technology data science data analytics or related field
• Experience working on Agile projects and Agile methodology in general.
• Excellent problem solving communications and teamwork skills.
• Exceptional presentation visualization and analysis skills

AWS Cloud with building Data Lake and data warehousing architectures,Data Warehouses on Snowflake, Redshift, HANA, Teradata, Exasol etc,AWS Data services like S3, Glue, Lake Formation, EMR, Kinesis, RDS, DMS and others,Data Modelling experience,Spark or equivalent big data technologies,ERP systems like SAP focusing on data integration