Overview
Accepts corp to corp applications
Contract - Contract
Skills
ERwin
Job Details
Position: Data Architect
Location: Philadelphia, PA (Remote)
Job Mode: Long term Contract
Job Description:
Required Skills: ERWin, Amazon S3, AWS Glue, Python, PostgreSQL, Amazon Redshift, Dimensional Data Modeling, Data Modelling, Data Modeler
Job Summary:
- As an Architect, you will be responsible for designing and implementing robust data solutions using advanced technologies.
- You will leverage your expertise in ERWin, Amazon S3, AWS Glue, Python, PostgreSQL, and Amazon Redshift to create efficient data models.
- Your role will involve collaborating with cross-functional teams to ensure seamless data integration and management, ultimately driving the companys data strategy forward.
Responsibilities:
- Design and maintain dimensional models using Star Schema and other best-practice techniques for analytical data marts.
- Work closely with business stakeholders and data engineers to define data requirements and translate them into physical and logical models.
- Conduct data analysis to convert OLTP (transactional) data into OLAP (analytical) structures.
- Develop and optimize complex SQL queries in Amazon Redshift and PostgreSQL to support ETL and reporting.
- Utilize Erwin Data Modeler to create, manage, and version data models. - Ensure data models support performance, scalability, data integrity, and compliance with enterprise data architecture standards.
- Participate in data governance activities and metadata documentation efforts. - Collaborate with Scrum team members and contribute to agile planning, story writing, and sprint execution.
Required Qualifications:
- 5+ years of experience in data modeling for enterprise-scale analytical environments.
- Proven expertise in dimensional modeling, including Star Schema, Snowflake Schema, and slowly changing dimensions (SCDs).
- Strong SQL development skills in Amazon Redshift and PostgreSQL.
- Proficiency in Erwin Data Modeler or a similar enterprise data modeling tool.
- Hands-on experience in data profiling, data lineage analysis, and source-to-target mapping.
- Deep understanding of the differences between OLTP and OLAP systems and the transformation required to convert between them.
- Familiarity with ETL design principles and data integration strategies.
Preferred Qualifications:
- Experience in Python for data transformation, scripting, or pipeline automation.
- Exposure to AWS data ecosystem (e.g., Glue, S3, Redshift Spectrum).
- Experience working in an Agile Scrum team setting.
- Understanding of data warehouse performance tuning and cost optimization in cloud environments.
- Certifications Required: AWS Certified Solutions Architect, Certified Data Management Professional (CDMP)
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.