Franciscan Health Data Developer Senior in Beech Grove, Indiana
Data Developer Senior
Franciscan Alliance1500 Albany Street Beech Grove, IN 46107
WHAT WE NEED
WHO WE ARE LOOKING FOR
Our Senior Data Developer plays an integral part in IT Applications. They are the ones responsible for desiging and creating tables within data marts, data lakes and data warehouse and all related extraction, transformation and load of data functions. This person is also responsible for modeling, developing, and maintaining data storage and repositories. Think you've got what it takes?Do you love analyzing and reporting on data? Do you have experience with ETL tools and databases? Are you accurate and efficient in your work? We need your skills.
WHAT YOU WILL DO
Consult with data management teams to get a big-picture idea of the data storage needs.
Under the guidance of leadership, designs, implement and continuously expand data pipelines by performingextraction, transformation and loading activities.
Gather requirements and business process knowledge in order to transform the data in a way that’s geared towardsthe needs of end users.
Present data lakes, marts and warehousing options based on storage needs.
Ensure that the data architecture is scalable and maintainable.
Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions.
Conduct preliminary testing of the warehousing and database environment before data is extracted.
Extract data and transfers it into the warehousing environment, other databases or to files.
Define testing criteria and test the new system once all the data has been transferred.
Train and mentor less experienced team members.
WHAT IT TAKES TO SUCCEED
Experience with ETL Tools and/or Databases.
Knowledge of data warehousing and business intelligence best practices and standards.
Understand the fundamental concepts of database design and the need for database architectural strategies to fit business or industry requirements.
Knowledge of conceptual, logical, and physical data modeling.
Understand common software architectures, including layered and distributed architecture models.
Understanding of quality assurance principles.
SQL, SAS, SSRS expertise.
EPIC (Clarity / Caboodle) Expertise.
Understand team or organizational goals, efforts, and requirements sufficiently to be able to assess and understand the purpose and appropriateness of detailed work.
Proficient in Microsoft Office applications.
Effectively communicate verbally and in writing as appropriate for the needs of the audience.
WHAT WE'RE LOOKING FOR
5-10 Years Experience:
Informatica PowerCenter required
3 years SQL required
ETL Administration preferred
ITCS preferred, but not required
SAS preferred, but not required
Agile preferred, but not required
Epic, Clarity, and Caboodle preferred, but not required
Cloud Services preferred, but not required
Data Modeling preferred, but not required
Travel: Up to 20%
EQUAL OPPORTUNITY EMPLOYER
It is the policy of Franciscan Alliance to provide equal employment to its employees and qualified applicants for employment as otherwise required by an applicable local, state or Federal law.
Franciscan Alliance reserves a Right of Conscience objection in the event local, state or Federal ordinances that violate its values and the free exercise of its religious rights.
Franciscan Alliance is committed to equal employment opportunity.
Beech Grove, IN, US, 46107
Up to 20%
1500 Albany Street