Get Into Energy Jobs

Job Information

NiSource Lead MDM Architect in Canonsburg, Pennsylvania

Lead MDM Architect

Full Time Perm

Way of Work : Remote

Salary Range : $107,000 - $160,500, plus annual bonus

The Lead Master and Reference Data Architect will be a member of a dynamic team responsible for creating and maintaining a Master and Reference Data system. This person will play a crucial role in creating high-quality data models and structures to support downstream analytics, reporting, and applications. Collaborating with Data Governance Activation Team, Business Analyst and Data Scientist, the Lead Architect will understand data needs and will design optimized structures pertaining to Reference Data Management. As a recognized subject matter expert, the Lead Architect tackles complex problems with a broad perspective, while also coaching, reviewing, and delegating tasks to less experienced professionals.

Your responsibilities may include, but are not limited to:

  • Lead the reference data architecture strategy for complex projects from start to finish.

  • Create data management policies and best practices to support MDM/RDM data structures.

  • Collaborate with Data Governance Activation Team, Business Analyst, Data Scientist, and other Business Partners & stakeholders to align data models and programming development with business needs.

  • Development of conceptual, logical, and physical data models for the Reference Data Architecture.

  • Coordinate and develop system integration designs for reference and master data within projects, including high-level and detailed system, application, and technology diagrams.

  • Design & implement effective database solutions and models for storing and retrieving company data.

  • Implement complex and efficient SQL queries to insert data along with data manipulation and retrieval.

  • Optimize query performance to ensure scalability and efficiency.

  • Troubleshoot data-related issues, identify variances and recommended improvements.

Required Qualifications

  • 5+ years working with Master Data Management/Reference Data Management.

  • 5+ years developing conceptual, logical, and physical data models.

  • 5+ years working in data lake, data warehousing and business intelligence environments.

  • 5 + years writing complex queries and optimizing data retrieval.

  • 5+ years of experience extracting, transforming, and loading data (ETL).

  • 3+ years of experience modeling Reference Data Hierarchies.

  • 3+ years of experience working with Cloud compute platforms.

  • 3+ years of experience working with metadata management and related tools.

Preferred Qualifications

  • Understanding of agile methodologies and experience on a cross-functional agile team.

  • Experience deploying and maintaining code with version control tools.

  • Strong knowledge of database structure systems and data mining.

  • Understanding of best practices in Data Warehousing and Data Lake architecture


The preceding description is not designed to be a complete list of all duties and responsibilities required of the position.

#Remote #MDM

Work Authorization

Authorized to work in the United States without requiring sponsorship.

Inclusion & Diversity

Value inclusion within your day to day responsibilities by respecting others perspectives/convictions, engaging others opinions, creating a safe environment where people, ideas, and opinions are valued within your Team/Customers and external partners.

Respect and take into consideration diversity within your Team/Customers and external work partners by valuing different world views, challenges, and cultures that represent all walks of life and all backgrounds.

Treat others with respect and consideration. Actively participate in creating and contributing to a positive work environment.

Equal Employment Opportunity

NiSource is committed to providing equal employment opportunities in each of its companies to all employees and applicants for employment without regard to race, color, religion, national origin or ancestry, veteran status, disability, gender, age, marital status, sexual orientation, gender identity, genetic information, or any protected group status as defined by law. Each employee is expected to abide by this principle.

By applying, you may be considered for other job opportunities.

Safety Statement

Promote a safe work environment by actively participating in all aspects of our employee safety program. Report any unsafe conditions and take actions to prevent personal injuries. Support our interdependent safety culture by ensuring the safety of your co-workers. Stay focused on the task at hand and promote productivity through good work habits.

Salary Range:

$107,000.00 - $160,500.00

Posting Start Date:


Posting End Date (if applicable):

Please note that the job posting will close on the day before the posting end date.

At NiSource, you'll be part of the team serving nearly four million customers throughout the Midwest and Mid-Atlantic, who count on us to energize their homes and businesses. Whether speaking with customers by phone, analyzing financial data or installing new gas lines in a neighborhood, you’ll meet exciting challenges each day and make the most of your skills and talents. And you’ll be part of a company that was named by Forbes magazine as one of America’s Best Large Employers.

We're looking for talent from all backgrounds. We invite candidates of all abilities to come as they are and do what they love. Through our years of successful growth, we’ve stayed true to our roots by making a difference in the lives of millions of our customers. If you’re interested in joining an inclusive, innovative company that fosters opportunity for growth, NiSource might be the place for you.