Lead IT Data Engineer

Brookdale Senior Living•Brentwood, TN

About The Position

Recognized by Newsweek in 2024 and 2025 as one of America's Greatest Workplaces for Diversity Make Lives Better Including Your Own. If you want to work in an environment where you can become your best possible self, join us! You’ll earn more than a paycheck; you can find opportunities to grow your career through professional development, as well as ongoing programs catered to your overall health and wellness. Full suite of health insurance, life insurance and retirement plans are available and vary by employment status. Part and Full Time Benefits Eligibility Medical, Dental, Vision insurance 401(k) Associate assistance program Employee discounts Referral program Early access to earned wages for hourly associates (outside of CA) Optional voluntary benefits including ID theft protection and pet insurance Full Time Only Benefits Eligibility Paid Time Off Paid holidays Company provided life insurance Adoption benefit Disability (short and long term) Flexible Spending Accounts Health Savings Account Optional life and dependent life insurance Optional voluntary benefits including accident, critical illness and hospital indemnity Insurance, and legal plan Tuition reimbursement Base pay in range will be determined by applicant’s skills and experience. Role is also eligible for team based bonus opportunities. Temporary associates are not benefits eligible but may participate in the company’s 401(k) program. Veterans, transitioning active duty military personnel, and military spouses are encouraged to apply. To support our associates in their journey to become a U.S. citizen, Brookdale offers to advance fees for naturalization (Form N-400) application costs, up to $725, less applicable taxes and withholding, for qualified associates who have been with us for at least a year. The application window is anticipated to close within 30 days of the date of the posting.

Requirements

Bachelor’s degree in information systems, computer science or related field and a minimum of seven to ten years of Data Engineering related experience; or equivalent combination of education and experience.
Seven to ten years’ experience with standard development tools and languages with advanced proficiency in applicable technical platform is required (Informatica Power Center 10. ETL tool, DAC Scheduling, Oracle SQL/DDL, Python API Coding, Scripting, Admin Informatica and DAC on Linux operating system, etc.).
Seven to ten years’ experience in the design and development of complex business applications and solutions is required.
Proven experience in leading larger projects.
Able to mentor other team members.
Ability to manage tasks, set technology direction and delegate as necessary.
Knows how to manage issues and needs little to no manager involvement.
Needs minimal manager guidance to assist with priority setting and issue resolution.
Assists others with priority setting and issue resolution.
Uses independent judgment to make decisions based on precedents and established guidelines.
Solves problems using standard procedures and precedents.
Has full understanding of all relevant company and department procedures and standards and is able to assist others to meet compliance.
Has a working knowledge of a skill or discipline that requires basic analytic ability.
Has an overall understanding of the work environment and process.
Has a working knowledge of the organization.
Proficient with tools and techniques to assist with problem resolution.
Leads research, analysis, and translation of business drivers into business, information, and technical requirements.
Facilitates what-if / white-boarding sessions to explore and share data architecture concepts with peers and stakeholders.
Demonstrated ability in designing and implementing centralized modern data warehousing/platforms that support self-service analytics
Must be proficient in creating & maintaining data pipelines and have hands-on experience on Informatica Power Center 10. ETL Tool.
Scheduling ETL Scripts with Oracle DAC.
Experience with Oracle SQL, data manipulation with Oracle DDL, data profiling and data discovery, as well as Oracle Database Management Tools.
Experience with scripting and administration of Informatica and DAC on Linux operating system (i.e. Red Hat RHEL 8.).
Must have hands-on experience with various IT concepts of data management/engineering (ETL, data modeling, data warehousing, etc.) and have a strong understanding of data analytics and data wrangling.
Proficient in developing packages, stored procedures, functions, triggers, and complex SQL statements.
Conceptual and analytical thinker with the ability to define business requirements and extract, analyze, and synthesize complex business insights.
Good communication skills including conflict resolution, interfacing with end users/consultants; writing discussion Documents (Spreadsheet, Flows, etc.); Excel; Visio; Word.

Nice To Haves

Relevant certifications are preferable but not required.

Responsibilities

Leads and assists in the establishment, planning, coordination, analysis, architecture, development, configuration, implementation and support of data-based solutions that benefit Brookdale business.
Creates scripts for extracting, transforming and loading data throughout the operational and data warehouse structures.
Conceptualizes, develops and owns the data architecture, data pipelines and centralized data warehouse with trustworthy datasets.
Lead efforts involving analysis, design, development, testing, documenting, implementation and support of new and existing applications and solutions.
Assist in the administration and management of application/server infrastructure and performance.
Lead and conduct application/architecture design and development reviews as appropriate to ensure working within appropriate technology/standards.
Responsible for establishing best practices, standards, and architectures working with co-development leads/architects.
Support testing of application programs within the company’s development/unit test environments by ensuring that testing plans are developed according to the required methodology.
Defines problems and draws valid conclusions based on collected data and established facts.
Assist in the change management process.
Serve as a change management role model by adhering to process guidelines and standards.
Work directly with functional users and leaders as required to ensure support of business objectives.
Responsible for full technical knowledge of all phases of projects, also having a good understanding of related business functions.
Contribute skills to affect team’s success.
Support other project teams and co-team members as appropriate, and coordinate and participate in training for subject matter experts, technical and functional alike.
Lead the identification and resolution of application and technical issues while understanding and contributing to the architecture of systems.
Defines application/architecture request projects as appropriate including scope, approach, deliverables, and detailed work plans.
Prepares required resource estimates and/or aids in the estimation process to support project management.
Utilize appropriate project management techniques and methodologies.
Ensure that the appropriate documentation is completed for each project.
Communicate effectively, verbally and written, with manager, peers, business users and company leadership.
Understand and promote Brookdale culture and apply effectively when solving business problems.
Provide leadership and mentoring to other members of IT and be passionate about finding problems in and improving IT efficiency.
Work with other groups to help improve the knowledge, skills and efficiency of all teams.

Benefits

Full suite of health insurance, life insurance and retirement plans are available and vary by employment status.
Medical, Dental, Vision insurance
401(k)
Associate assistance program
Employee discounts
Referral program
Early access to earned wages for hourly associates (outside of CA)
Optional voluntary benefits including ID theft protection and pet insurance
Paid Time Off
Paid holidays
Company provided life insurance
Adoption benefit
Disability (short and long term)
Flexible Spending Accounts
Health Savings Account
Optional life and dependent life insurance
Optional voluntary benefits including accident, critical illness and hospital indemnity Insurance, and legal plan
Tuition reimbursement
Role is also eligible for team based bonus opportunities.
Brookdale offers to advance fees for naturalization (Form N-400) application costs, up to $725, less applicable taxes and withholding, for qualified associates who have been with us for at least a year.