Lead Data Architect

Lead Data Architect

Full Time Perm

Way of Work: Hybrid - three days on location

Salary Range:$125,000 - $188,600, plus 10% annual bonus

Location:Columbus, OH

Relocation assistance provided

The NiSource IT organization is accountable for all NiSource systems, including all Customer, Corp, and Technology Domains.

The Lead Data Architectplays a crucial role in creating high-quality data assets to support business requirements. In this role you will collaborate with business, IT, and data & analytics teams to understand their data needs and designs optimized structures.

Ideally the Lead Data Architect's models reduce redundancy, streamline data flow, and enhance enterprise data management. While leveraging best practices, you will create timely, reliable, and scalable data products.

Overall the Lead Data Architect will also work with EA leadership, business leaders, and service providers to develop and implement data architecture strategies, as well as developing methodologies and processes to ensure compliance to those strategies.

Your responsibilities may include, but are not limited to:

Translate business requirements into technology requirements and define data standards and principles.

Design the enterprise data management framework.

Analyze and translate business needs into long-term solution data models.

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

Implement data strategies and developing physical data models.

Lead data modeling strategy for complex projects from start to finish.

Identify database structural necessities by evaluating business operations, applications, and programming.

Provide architectural leadership on the design and development of a solution for the NiSource enterprise.

Drive the translation of the business client's complex business problems into the selected technology solutions by designing complete solutions that leverage various IT services components.

Create architecture documentation and deliverables throughout the project lifecycle of the solutions.

You must possess the below minimum qualifications to be initially considered for this position. Preferred qualifications are in addition to the minimum requirements and are considered a plus factor in identifying top candidates.

Minimum Qualifications

Bachelor's degree or equivalent work experience

8+ years of experience functioning as a Data Architect

5+ years of experience designing and implementing database solutions.

5+ years of experience physical and relational data modeling

5+ years of experience in data warehousing and data lake architecture

Preferred Qualifications

Experience building and optimizing big-data pipelines, architectures, and data sets.

Excellent organizational and analytical abilities.

Outstanding problem solving.

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.

Familiarity with the standards and best practices bodies i.e. ITIL, CoBIT, CMMi, Six Sigma/LEAN etc.

As a public utility, NiSource is required to provide continuous service to customers at all times. To ensure we fulfill that obligation, employees may be required to work outside their normal work hours and perform tasks outside of their normal responsibilities in support of emergency operations.

Work Authorization

Authorized to work in the United States without requiring sponsorship.

Workplace Connection

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 the unique lived experiences within your Team/Customers and external work partners by valuing different world views, challenges, and cultures that represents 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, sex (including pregnancy, lactation, childbirth or related medical conditions), genetic information, citizenship status, 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.

ADA Accommodations

If you need a reasonable accommodation to participate in any part of the hiring process or to perform the essential functions of the position, please contact OneHR at

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.

E-Verify

NiSourceparticipates in the U.S. Department of Homeland Security's E-Verify program. As part of this process, we provide the following notices to all job applicants: These documents inform you of your rights and responsibilities under U.S. law. You can view or download them using the links below:

E-Verify Poster(English and Spanish) E-Verify Participation Poster English and Spanish

Right to Work Poster(English and Spanish) If you have the right to work, don't let anyone take it away

Salary Range*: $129,500.00 - $194,300.00

*The salary offered to a candidate is based on several factors including but not limited to the candidate's skills, job-related knowledge, and relevant experience, as well as internal pay equity.

Posting Start Date: 2025-10-23

Posting End Date (if applicable): 2025-11-06Please note that the job posting will close on the day before the posting end date.