Data architect / architect
Location
Harrisburg, PA | United States
Job description
Overview:
We strongly believe that data and analytics are strategic drivers for future success. We are building a world class advanced analytics team that will solve some of the most complex strategic problems and deliver topline growth and operational efficiencies across our business The Analytics team is responsible for driving organic growth by leveraging big data and advanced analytics. The team reports to the VP and Chief Data Officer, works closely with the SVP of Corporate Strategy, and has regular interactions with the company s C-Suite.
We are on an exciting journey to build and scale our advanced analytics practice. We are looking for a Senior Solutions Architect that has experience in building data lake and data warehouse architectures using On-Prem and Cloud technologies.
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 usecases 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.
- Hands-on prototyping of new technology solutions by working with cross teams
Must Have:
- Experience operating on AWS Cloud with building Data Lake and data warehousing architectures.
- Experience building Data Warehouses on Snowflake, Redshift, HANA, Teradata, Exasol etc.
- Experience with AWS Data services like S3, Glue, Lake Formation, EMR, Kinesis, RDS, DMS and others
- Experience with Data Modelling experience
- Working knowledge in Spark or equivalent big data technologies.
- Experience in building Delta Lakes using technologies like Databricks.
- Working experience in ETL tools like Talend, Informatica, SAP Data Services etc.
- Experience in any programming language (Python, R, Scala, Java)
- Experience working with ERP systems like SAP focusing on data integration.
- Bachelor s 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
Nice to Have
AWS and other cloud related certifications are a big plus.
SAP functional experience is a big plus.
Report this job
- Dice Id: 91140303
- Position Id: 8194433
Job tags
Salary