Sr Data Architect - Remote

$91,000 - $136,600/Yr

NiSource - Canonsburg, PA

posted 3 months ago

Full-time - Mid Level
Remote - Canonsburg, PA
Utilities

About the position

The Senior Data Architect plays a crucial role in the Enterprise Data Strategy department, which is responsible for the data strategy of the enterprise data lake house. This position is pivotal in creating high-quality data models and structures that support downstream analytics, reporting, and application requirements. The Senior Data Architect collaborates closely with business, IT, and analytics colleagues to understand data needs and design optimized structures that reduce redundancy, streamline data flow, and enhance enterprise data management. By leveraging best practices, the Senior Data Architect is tasked with creating timely, reliable, and scalable data products. As a recognized subject matter expert, this role involves tackling complex problems with a broad perspective, ensuring that the data architecture aligns with the overall business strategy. In this role, you will be responsible for assembling large, complex data sets that align with business requirements and analyzing and translating these needs into long-term solution data models. You will design and implement effective database solutions and models for storing and retrieving company data, collaborating with the development team to create conceptual data models and data flows. Additionally, you will implement data strategies and develop physical data models, leading the data modeling strategy for complex projects from start to finish. Your responsibilities will also include updating and optimizing local and metadata models, as well as identifying database structural necessities by evaluating business operations, applications, and programming.

Responsibilities

  • Assemble large, complex data sets that align with business requirements.
  • Analyze and translate business needs into long-term solution data models.
  • Design & implement effective database solutions and models for storing and retrieving company data.
  • Collaborate with the development team to create conceptual data models and data flows.
  • Implement data strategies and develop physical data models.
  • Lead data modeling strategy for complex projects from start to finish.
  • Update and optimize local and metadata models.
  • Identify database structural necessities by evaluating business operations, applications, and programming.

Requirements

  • 2+ years of experience designing and implementing database solutions
  • 2+ years of experience in physical and relational data modeling
  • 2+ years of experience in data warehousing and data lake architecture.

Nice-to-haves

  • Experience building and optimizing big-data pipelines, architectures and data sets.
  • Excellent organizational and analytical abilities.
  • Outstanding problem solving skills.
  • Understanding of best practices in Data Warehousing and Data Lake architecture.
  • Strong knowledge of database structure systems and data mining.
  • Understanding of agile methodologies and experience on a cross-functional agile team.
  • Expert knowledge of metadata management and related tools.
  • Experience deploying and maintaining code with version control tools.

Benefits

  • Annual bonus
  • Remote work flexibility
  • Opportunities for professional growth and development
  • Inclusive work environment
  • Employee safety program participation
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service