• Focus on source system knowledge, data analysis, business requirements and providing conceptual, logical and physical data model designs to support various initiatives in an agile environment.
• Review existing data models to understand the current environment and recommend changes to optimize data requirements.
• Work closely with the upstream data owners, business stakeholders, and analysts to understand reporting and analytics end state in order to drive the creation of scalable and documented data design solutions.
• Work with the development team to implement data strategies, build data flows, and develop conceptual data models.
• Act as a Subject Matter Expert in Data Architecture and Database design using AWS services including Redshift and PostgreSQL, specializing in designing high-efficiency, scalable, and reusable architectures.
• Conduct programming and querying using SQL and Spark.
• Mentor junior developers and analysts to adopt best practices in query design and performance optimization.
• Build logical and physical data models utilizing industry best practices.
• Work closely with the business intelligence team to implement/publish a data access layer in the data lake that is optimized for reporting and analytical needs based on business requirements.
• Support and evolving standards for all cycles of visual product development including requirements, prototyping, code development, versioning, documentation, and maintenance.
• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
• Collaborate with product owners, scrum masters, program manager and team members in a Scaled Agile framework.