Sr. Consultant, Data Architecture

Date: Jul 10, 2019

Location: Omaha, NE, US

Company: Lincoln Financial

Alternate Locations: Dover, NH (New Hampshire); Omaha, NE (Nebraska)

Relocation assistance is not available for this opportunity.

Requisition #59766

About the Company

Lincoln Financial Group, a Fortune 250 company with over 10,000 employees, provides advice and solutions that help empower Americans to take charge of their financial lives with confidence. Our core business areas — Life Insurance, Annuities, Retirement Plan Services and Group Protection — focus on supporting, preserving and enhancing over 17 million customer’s lifestyles and retirement outcomes.

Headquartered in Radnor, Pennsylvania, Lincoln Financial Group is the marketing name for Lincoln National Corporation (NYSE: LNC) and its affiliates. The company had $238 billion in assets under management as of December 31, 2018.

Ranked one of the Best Large Employers in America by Forbes magazine, Lincoln Financial Group makes a serious investment in our employees’ futures through a broad range of wealth accumulation and protection plans, health and wellness programs, and career development resources designed to help each individual reach their personal and professional goals.


The Role

Responsible to lead in the design, development, and management of transactional databases, operational data stores, data marts, data warehouses and the processes required to maintain and update those databases.




  • Develops plans for data warehouse implementation following industry best practice (Inmon or Kimball), creating conceptual, logical and physical models for implementation.
  • Demonstrates expertise in a variety of the data warehouse concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals.
  • Evaluates new data sources to assess quality and determine integration approach. Performs data analysis on source system data as needed. 
  • Analyzes operational and analytical data requirements by working with cross functional business and application development teams 
  • Drives data architecture and data modeling best practices within the team • Maintains knowledge on current and emerging developments/trends for assigned area(s) of responsibility, assess the impact, and collaborates with senior management to incorporate new trends and developments in current and future solutions.
  • Directs and enhances organizational initiatives by positively influencing and supporting change management and/or departmental/enterprise initiatives within assigned area(s) of responsibility. 
  • Identifies and directs the implementation of process improvements that significantly improve quality across the team, department and/or business unit for his/her assigned area(s) of responsibility. 
  • Provides subject matter expertise to team members and applicable internal/external stakeholders on complex assignments/projects for his/her assigned area(s) of responsibility. 
  • Provides direction on complex assignments, projects, and/or initiatives to build and enhance the capability of his/her assigned area(s) of responsibility. 
  • Consult and collaborate to ensure project designs comply with the Enterprise Data Strategy while solving for business requirements. Consult and collaborate in engagements regarding new and existing applications, environments or processes. 
  • Lead collaboration efforts with development teams to review, update and approve the data portion of project designs, participate in cost/benefit analysis and preparation of project plans.  
  • Lead the design, development and delivery data centric IT solutions, including large scale data staging and orchestration, integration and provisioning mechanisms. 
  • Mentors junior data architects and data modelers.


Education & Experience

  • 4 Year/Bachelors Degree or equivalent work experience (4 years of experience in lieu of Bachelors) in Computer Science, Computer Information Systems, Information Systems, Information Technology, Engineering or Business Administration 
  • 5-7+ Years experience in IT application development (Required) 
  • 5-7+ Years experience implementing relational database designs, data warehousing, data architecture, & data modeling, including strong knowledge of various data modeling approaches and practices (experience with 3NF, star schemas, and multi-dimensional designs) (Required) 
  • 5-7+ Years experience with ERwin Enterprise Data Modeler Suite or equivalent modeling software (Required) 
  • Experience with ETL tools, ETL mapping specifications, and building repeatable ETL processes (Informatica PowerCenter preferred) 
  • Experience with data quality management and metadata management 
  • Strong working knowledge of various SDLC practices in both waterfall and agile team environments 
  • Hands-on experience with large, transactional databases (Oracle 11g or 12c) including strong SQL & PL/SQL skills
  • Good communication and interpersonal skills for interacting and collaborating with developers, analysts, and business staff throughout the organization.
  • Ability to express complex technical information in a user friendly language and style and present information effectively in 1-on-1 and small group settings  
  • Ability to communicate clearly in writing to document data requirements and translate into technical solutions



"There is no Certification or Licensure Listed"


Travel Information

  • Travel Type : Regional Domestic
  • Travel Amount : up to 10%


This position may be subject to Lincoln’s Political Contribution Policy.  An offer of employment may be contingent upon disclosing to Lincoln the details of certain political contributions. Lincoln may decline to extend an offer or terminate employment for this role if it determines political contributions made could have an adverse impact on Lincoln’s current or future business interests, misrepresentations were made, or for failure to fully disclose applicable political contributions and or fundraising activities.

Any unsolicited resumes/candidate profiles submitted through our web site or to personal e-mail accounts of employees of Lincoln Financial Group are considered property of Lincoln Financial Group and are not subject to payment of agency fees.

Lincoln Financial Group (“LFG”) is an Equal Opportunity employer and, as such, is committed in policy and practice to recruit, hire, compensate, train and promote, in all job classifications, without regard to race, color, religion, sex (including pregnancy), age, national origin, disability, sexual orientation, gender identity and expression, veterans status, or genetic information.  Applicants are evaluated on the basis of job qualifications.  If you are a person with a disability that impedes your ability to express your interest for a position through our online application process, or require TTY/TDD assistance, contact us by calling 260-455-2558.


Nearest Major Market: Omaha
Nearest Secondary Market: Council Bluffs

Job Segment: Data Architect, Database, Oracle, Information Systems, ERP, Data, Technology