It Data Engineer Iv - Local Remote - Informatica

IT Data Engineer IV - Local Remote – Informatica

Local Remote Position. Must live in the Milwaukee, WI or Nashville, TN Area.

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.

1. Lead efforts involving analysis, design, development, testing, documenting, implementation and support of new and existing applications and solutions.
2. Assist in the administration and management of application/server infrastructure and performance.
3. 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.
4. 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.
5. Defines problems and draws valid conclusions based on collected data and established facts.
6. Assist in the change management process. Serve as a change management role model by adhering to process guidelines and standards.
7. 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.
8. 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.
9. Lead the identification and resolution of application and technical issues while understanding and contributing to the architecture of systems.
10. 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.
11. Utilize appropriate project management techniques and methodologies. Ensure that the appropriate documentation is completed for each project.
12. Communicate effectively, verbally and written, with manager, peers, business users and company leadership.
13. Understand and promote Brookdale culture and apply effectively when solving business problems.
14. 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.

Qualifications

Education and Experience
 

1. 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.
2. Seven to ten years’ experience with standard development tools and languages with advanced proficiency in applicable technical platform is required (Any standard ETL tool, Oracle, SQL Server, XML, PeopleSoft OBIA, Python/R, RStudio, etc.).
3. Seven to ten years’ experience in the design and development of complex business applications and solutions is required.
4. Proven experience in leading larger projects.

Certifications, Licenses, and Other Special Requirements
 

1. Relevant certifications are preferable but not required.

Management/Decision Making
 

1. Able to mentor other team members.
2. Ability to manage tasks, set technology direction and delegate as necessary.
3. Knows how to manage issues and needs little to no manager involvement.
4. Needs minimal manager guidance to assist with priority setting and issue resolution.
5. Assists others with priority setting and issue resolution.
6. Uses independent judgment to make decisions based on precedents and established guidelines.
7. Solves problems using standard procedures and precedents.
8. Has full understanding of all relevant company and department procedures and standards and is able to assist others to meet compliance.

Knowledge and Skills

1. Has a working knowledge of a skill or discipline that requires basic analytic ability.
2. Has an overall understanding of the work environment and process.
3. Has a working knowledge of the organization.
4. Proficient with tools and techniques to assist with problem resolution. Leads research, analysis, and translation of business drivers into business, information, and technical requirements.
5. Facilitates what-if / white-boarding sessions to explore and share data architecture concepts with peers and stakeholders.
6. Demonstrated ability in designing and implementing centralized modern data warehousing/platforms that support self-service analytics
7. Must be proficient in creating & maintaining data pipelines and have hands-on experience on one of the ETL Tools – e.g. Informatica, Talend, Microsoft SSIS, or similar programs.
8. Experience with SQL, data manipulation, data profiling and data discovery, as well as Database Management Tools: e.g. Oracle, MySQL, Microsoft SQL Server, PostgreSQL, or similar.
9. 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.
10. Proficient in developing packages, stored procedures, functions, triggers, and complex SQL statements.
11. Conceptual and analytical thinker with the ability to define business requirements and extract, analyze, and synthesize complex business insights.
12. Good communication skills including conflict resolution, interfacing with end users/consultants; writing discussion Documents (Spreadsheet, Flows, etc.); Excel; Visio; Word.