If you're looking for a career change or you're in search of talent...

Explore New Job Opportunities Here

Director, Data Architecture



Westlake, TX, USA · Boston, MA, USA · Merrimack, NH, USA · smithfield, ri, usa
Posted on Wednesday, May 8, 2024

Job Description:

The Role

  • As the Data Architect supporting APS, you blend deep data Integration knowledge to create Data architecture and Data modeling for multiple Key initiatives in the Analytics space. In an agile structure you will collaborate with other leaders to establish the standards for your CoE, influence the strategic decisions and build solutions to help scale our business. You are committed to staying hands on, developing your own expertise and knowledge to bring the latest thinking to your role. You will drive a spirit of innovation and data strategy by building and improving the data Integration. modeling and database design practice primarily Analytics systems, with a goal to stretch into Transactional systems as needed. You will work closely with the business and technical teams and create or assist in the creation of scalable, flexible, and well documented data architecture that enable database designs that will enhance the APS time to market. You will help to drive conformance to the APS data strategy and Enterprise Data Taxonomy.

The Expertise and Skills You Bring

  • Demonstrated experience in ETL/ELT tools (preferred Python, Informatica and Snaplogic), Data Integration frameworks and best practices (SME)
  • Expertise in relational database technologies such as Oracle, Postgres and Snowflake; cloud native databases such as Yugabyte DB and Cockroach DB; and NoSQL databases such as Aerospike, DynamoDB. Understand the enterprise decision matrix for databases, including diff between RDS and Aurora DB deployments
  • Support on Data replication, ingestion pipelines, DR, AWS infrastructure
  • Demonstrated technology and personal leadership experience in architecting, designing, and building highly scalable data pipelines in analytical, and reporting systems
  • Ability to formulate data strategy, conceptual architecture, and work with development teams to execute the strategy
  • Expertise in data management standard methodologies such as data integration, data security, data warehousing, data analytics, Data Governance, metadata management and data quality.
  • Understanding of Reporting tools (Tableau, PowerBI), Alation and Collibra is a plus.
  • Ability to evaluate, prototype and recommend emerging data technologies and platforms
  • Strong understanding of Data Modeling concepts esp. dimensional modeling
  • Experience with data processing concepts such as Change Data Capture, Eventing, and Streaming technologies.
  • Strong understanding of cloud concepts, specifically transactional resiliency, scalability, and performance from a data/database perspective
  • Understanding of Reporting tools and AI/ML nice to have
  • Bachelor's degree in computer science, Information Technology, or a related field
  • Ability to explain Data structures to a nontechnical audience
  • Results oriented with demonstrable ability to work independently
  • Good interpersonal, negotiating, and influencing skills

The Value You Deliver

  • Overall Data architecture support with a focus on ETL/ELT, and data integration architecture
  • Responsible for the Oversight of Data Integration practices and Analytics tech stack across diff groups in APS
  • SME knowledge in Analytics and snowflake along with RBAC and Data Tokenization concepts
  • Work with other data architects and application architects in formulating Data Strategy, esp. data Integration and Data Analytics Strategy for APS
  • Work across different groups of team members, along with the ability to influence inside and outside of your team.
  • Able to work in a matrix team environment that presents significant change and tight timeframes.
  • Superb communication skills (both written and verbal)
  • Strong analytical and problem-solving skills.
  • Strong prioritization skills and ability to focus on high impact activities.
  • Help to drive conformance to the APS and Enterprise data strategy

The Team

The Team APS data architecture team partners with the project teams to deliver practical & resilient data solutions and database designs that meet business needs while adhering to key standards and methodologies. We drive adoption of enterprise and standard methodologies, and promote changes in process, standards, or technologies when necessary.