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 Architect plays 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 [email protected] or 1-888-640-3320
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
NiSource participates 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-11-11Posting End Date (if applicable):
Please note that the job posting will close on the day before the posting end date.Top Skills
What We Do
NiSource (NYSE: NI) helps energize the lives of its nearly 4 million natural gas and electric customers across six states. Our local utilities – Columbia Gas and NIPSCO – ensure that customers receive safe, reliable and affordable natural gas and electric service each and every day. Our business plan is focused on proactively investing in our energy infrastructure – approximately $1.4 billion a year – to ensure we meet and improve upon our customer commitments for the next 100 years.
We employ more than 7,000 of our neighbors who are actively engaged in the communities we’re privileged to serve, making them great places to live and call home. NiSource is headquartered in Merrillville, Indiana – about 35 miles from Chicago – and we maintain a significant corporate presence in Columbus, Ohio. Our utility operations also span Kentucky, Maryland, Pennsylvania and Virginia
