The Sr. Engineer App Dev will work as part of the Enterprise Data Integration team under the direction of the Enterprise Data Integration Manager.  The position relies on experience and judgment to support, enhance and create ETL processes, requiring a broad degree of independence, knowledge and problem solving skills.
The ideal candidate for the Sr. Engineer is a technical resource that has experience building comprehensive data integration solutions representing data from relational and analytical source systems or models, analyzing complex SQL code, and creating and optimizing Control-M batch application workloads.  This role is required to transform data according to Business Rules and MDM and to work with the Enterprise Data Management team to assure attributes are properly governed and also loaded into operational models.  The role is  also required to analyze sources of data, determine optimal data integration methodologies, map and model to relational and analytical layer data models, identify enhancements, and other needs relative to the Enterprise Data Integration space.
The role additionally has input into the Enterprise Data Integration architecture, procedures and workflow.  The role is expected to have a strong business acumen in order to provide effective and efficient solutions.  Individuals in this role are expected to have a strong ability to multitask on various projects and priorities and keep them all moving forward.  The role influences others in IT through sharing of specialized technical knowledge and mentors junior developers and reporting analysts in proper techniques, procedures and code performance adjustments. This role is expected to support and expand a culture of operational excellence.
This position requires a highly technical individual that has the ability to communicate clearly with Enterprise Data Services (EDS) Management, Enterprise Business and Data Analysts, Enterprise Data Operations Support, Enterprise Information Delivery Developers and other IT professionals using technically sound terminology and excellent communication skills.
The ideal candidate will be a strong leader and self starter working in a fairly autonomous environment.  They will need to have a high level of experience coding technically sound solutions following industry best practices specifically around Enterprise Data Integration solutions, while exhibiting the ability to communicate in a non-technical or business manner.  This candidate will have leadership qualities that will be utilized to mentor junior developers and the ability to simultaneously address multiple units of work within a given timeframe to ensure timeline is adhered to, quality requirements are documented and followed, as well as acceptance criteria is met .
The candidate will possess strong institutional knowledge of the insurance and Enterprise Data Integration industries in order to craft the most effective and efficient solutions for the business.  The ability to understand complex business needs, logical problem solving skills, and strong written and verbal communication skills are required.  Additionally, an expert level understanding of database methodology, the MS BI Stack and other industry solutions are required.

Responsibilities

  • Simultaneously address multiple units of work within a given timeframe/sprint to ensure timeline is adhered to, quality requirements are followed and acceptance criteria is met.
  • Use Microsoft BI stack (SQL, SSIS) to develop Data Integration solutions as part of the continued development and maturation of the Enterprise Data assets
  • Work with the Enterprise Data Management team to assure attributes are properly managed and governed via the Enterprise Data Governance process
  • Assure Data Integration solutions follow the department’s software development lifecycle processes and that all required artifacts and documentation have been created to support a seamless migration to the Enterprise Data Operations Support team
  • Demonstrate advanced experience with ETL Methodologies, Incident Management, Change Management, Problem Management and Project Management Disciplines
  • Deploy solutions with written implementation, test and back-out plans according to the change control process
  • Drive and own the necessary development tasks to support functional specifications
  • Provide tier 4 support for Enterprise Data Assets and other legacy data stores/solutions. (Note: Tier 1 support is our NOC, tier 2 support is off shore, tier 3 support is onshore and tier 4 support are our Sr. and Lead Data Integration developers)
  • Demonstrate advanced understanding of Enterprise Data Assets and other legacy data stores/solutions architecture, processes and flow, and operate as a subject matter expert (SME) within the group
  • Apply Protective Enterprise Data Services standards in all development to ensure consistency and quality of work product
  • Work within an agile environment following sprint commitments and release schedules
  • Provide peer reviews for assigned team developers in order to ensure adherence to industry and Protective specific standards as it relates to Integration code, Workflow Management and documentation
  • Work, in conjunction with Team Lead and utilize technical understanding and leadership abilities to mentor junior developers

Additional Duties

  • Actively participate in team meetings to support the group
  • Actively participate in the culture of excellence as part of the Enterprise Data Services team
  • Actively participate in team design reviews and co-operative architecture design sessions
  • Work directly with Sr Enterprise Information Delivery Developers, Enterprise Data Integration Developers and Enterprise Business/Data Analysts on data requirements and quality assurance
  • Work efficiently and Effectively to ensure successful and timely completion of assigned project deliverables
  • Work with team lead and manager to effectively define and manage toward goals that impact personal, team and company related objectives

Work Experience, Education, Certification / Training Required

  • Bachelor’s degree or equivalent certifications / experience required
  • 5+ years IT development experience required.  Operational and/or Incident management experience required
  • 3+ years of Business Intelligence application delivery using the Microsoft Business Intelligence stack (SSIS, SSAS, SSRS, SQL Server, Power BI) required
  • Strong experience in relational and dimensional data modeling required
  • Strong database and SQL experience required.  Microsoft T-SQL preferred
  • Experience working on a project team using a waterfall and/or agile SDLC methodology required (Agile preferred)
  • Strong experience with Microsoft SQL Server required.  SQL Server 2012 Required and 2016 a plus
  • Experience in the Insurance industry and/or LOMA coursework; ALMI designation required
  • ITIL Foundation V3 Certification required
  • Experience with Workload Automation Tools – Control-M V8 or greater is a plus (Control-M V9 Preferred)
  • Experience with Microsoft MDS and Master Data Management a plus

Protective’s targeted salary range for this position is $81,000 to $125,000. Actual salaries may vary depending on factors, including but not limited to, job location, skills, and experience. The range listed is just one component of Protective’s total compensation package for employees.
This position also offers additional incentive opportunities through an annual incentive based on individual and Company performance.

edimedia

Work Level
Entry, Junior, Mid, Senior
Employment Type
Full-time, Remote
Protective Life
View profile
Industry
Insurance
Location
Remote

EDI Calendar 2024

January

Month-long observances:

  • National Mentoring Month
  • Poverty in America Awareness Month
  • Slavery and Human Trafficking Awareness Month

Important January EDI calendar dates:

    • January 1 – New Year’s Day
    • January 4 – World Braille Day
    • January 7 – Coptic Orthodox Christmas
    • January 25 – Mahayana New Year (Buddhist)
    • January 13 – Maghi (Sikh)
    • January 21 – World Religion Day
    • January 15 – Martin Luther King, Jr. Day
    • January 24 – International Day of Education
    • January 26 – International Customs Day
    • January 27 – International Holocaust Remembrance Day
February

Month-long observances:

  • American Heart Month
  • Black History Month

Important February EDI calendar dates:

    • February 1 – National Freedom Day
    • February 2 – Groundhog Day
    • February 4 — Rosa Parks Day
    • February 6 — Safer Internet Day
    • February 10 — Lunar New Year (Year of the Dragon)
    • February 11 – International Day of Women & Girls in Science
    • February 12 – International Epilepsy Day
    • February 13 – Mardi Gras
    • February 14 – Ash Wednesday
    • February 14 – Valentine’s Day
    • February 15 – Nirvana Day (Buddhist)
    • February 15 – International Childhood Cancer Day
    • February 17 – Random Acts of Kindness Day
    • February 19 – Family Day (Canada)
    • February 19 – President’s Day (USA)
    • February 20 – World Day of Social Justice
March

Month-long observances:

  • Developmental Disabilities Awareness Month
  • Ethnic Equality Month
  • Gender Equality Month
  • Greek-American Heritage Month
  • Irish-American Heritage Month
  • National Colon Cancer Awareness Month
  • National Kidney Month
  • National Multiple Sclerosis Awareness and Education Month
  • National Women’s History Month

Important March EDI calendar dates:

    • March 1 – Employee Appreciation Day
    • March 8 – International Women’s Day
    • March 8 – Maha Shivarati (Hindu)
    • March 10 –  Ramadan begins (Islam)
    • March 10 – Harriet Tubman Day (USA)
    • March 14 – Pi π Day
    • March 14 – Equal Pay Day
    • March 15 – International Day to Combat Islamophobia
    • March 17 – St. Patrick’s Day
    • March 21 – World Down Syndrome Day
    • March 23 – Purim (Jewish)
    • March 25 – International Day of Remembrance of the Victims of Slavery and the Transatlantic Slave Trade
    • March 24 – Palm Sunday (Christian)
    • March 25 – Holi (Hindu)
    • March 29– Good Friday (Christian)
    • March 31 – International Transgender Day of Visibility
    • March 31 – Easter (Christian)
    • March 31 – César Chávez Day (USA)
April

Month-long observances:

  • Arab-American Heritage Month
  • Autism Awareness Month
  • Celebrate Diversity Month
  • Earth Month
  • National Child Abuse Prevention Month
  • National Volunteer Month

Important April EDI calendar dates:

    • April 2 – World Autism Awareness Day
    • April 5 – Laylat al-Qadr (Muslim)
    • April 7 – World Health Day
    • April 9 – Eid-al-Fitr/End of Ramadan (Muslim)
    • April 12 – National Day of Silence (LGBTQ+)
    • April 21 – Start of Ridvan (Baha’i)
    • April 22 – Passover begins (Jewish)
    • April 22 – Earth Day
    • April 24 – Administrative Professionals Day
    • April 28 –World Day for Safety and Health at Work
    • April 30 – Passover ends
May

Month-long observances:

  • ALS Awareness Month
  • Haitian Heritage Month
  • Indian Heritage Month
  • Jewish-American Heritage Month
  • Mental Health Awareness Month
  • National Asian American and South Pacific Islander Heritage Month
  • Older Americans Month
  • South Asian American Heritage Month

Important May EDI calendar dates:

    • May 5 – Cinco de Mayo
    • May 5 – Yom Hashoah (Jewish)
    • May 12 – Mother’s Day
    • May 17 – International Day Against Homophobia, Transphobia and Biphobia
    • May 19 – Malcolm X Day (USA)
    • May 20 – Victoria Day (Canada)
    • May 20 – International Human Resources Day
    • May 21 – World Day for Cultural Diversity for Dialogue and Development
    • May 23 – Declaration of the Bab (Baha’i)
    • May 26 – Arbor Day
    • May 29 – Ascension of Baha’u’llah (Baha’i)
    • May 27 – Memorial Day
June

Month-long observances:

  • Alzheimer’s and Brain Awareness Month
  • Black Music Month
  • National Caribbean American Heritage Month
  • Pride Month (LGBTQ+)

Important June EDI calendar dates

    • June 5 – World Environment Day
    • June 9 – Race Unity Day
    • June 12 – Loving Day
    • June 16 – Eid al-Adha (Muslim)
    • June 16 – Father’s Day
    • June 19 – Juneteenth
    • June 20 – World Refugee Day
    • June 20 – Litha, Summer Solstice (Pagan)
    • June 21 – National Indigenous Peoples Day (Canada)
    • June 23 – Public Service Day
    • June 24 – St-Jean-Baptiste Day (Quebec)
    • June 27 – Helen Keller Day (USA)
    • June 28 – Pride Day (LGBTQ+) (varies by city and country)
July

Month-long observances:

  • French-American Heritage Month

Important July EDI calendar dates

    • July 1 – Canada Day (Canada)
    • July 4 – Independence Day (USA)
    • July 7 – Al-Hijra begins (Muslim)
    • July 9 – Martyrdom of the Bab (Baha’i)
    • July 11 – World Populace Day
    • July 14 – Bastille Day
    • July 18 – International Nelson Mandela Day
    • July 24 – Pioneer Day (Mormon)
    • July 24 – International Self-Care Day
    • July 26 – National Disability Independence Day (commemorates the signing of the Americans With Disabilities Act)
    • July 28 – Parents’ Day (USA)
    • July 30 – International Day of Friendship
August

Month-long observances:

  • National Civility Month

Important EDI calendar dates:

    • August 7 – Purple Heart Day
    • August 9 – International Day of the World’s Indigenous People
    • August 13 – Left-Handers Day
    • August 17 – Marcus Garvey Day (Jamaican)
    • August 19 – World Humanitarian Day
    • August 21 – Senior Citizens Day
    • August 26 – Women’s Equality Day
    • August 26 – Krishna Janmashtami (Hindu)
September

Month-long observances:

  • Hispanic Heritage Month
  • National Guide Dog Month
  • Suicide Prevention Month

Important September EDI calendar dates:

  • September 2 – Labor Day
  • September 5 – International Day of Charity
  • September 10 – World Suicide Prevention Day
  • September 10 – Grandparents’ Day
  • September 11 – Patriot Day (U.S.A.)
  • September 15 – International Day of Democracy
  • September 16 – Mexican Independence Day
  • September 18 – International Equal Pay Day
  • September 21 – International Day of Peace
  • September 21 – World Gratitude Day
  • September 22 – American Business Women’s Day
  • September 26 – HR Appreciation Day
  • September 27 – National Native American Day
  • September 30 – National Day for Truth & Reconciliation (Canada)

 

October

Month-long observances:

  • Breast Cancer Awareness Month
  • Bullying Prevention Month
  • Domestic Violence Awareness Month
  • Filipino-American Heritage Month
  • German-American Heritage Month
  • Italian-American Heritage Month
  • LGBTQ History Month
  • National Work and Family Month
  • Polish-American Heritage Month
  • Family History Month

Important October EDI calendar dates:

    • October 2 – International Day of Nonviolence
    • October 2 – Rosh Hashanah begins (Jewish)
    • October 3 – Navrati begins (Hindu)
    • October 10 – World Mental Health Day
    • October 11 – National Coming Out Day (LGBTQ+)
    • October 11 – Yom Kippur (Jewish)
    • October 14 – National Indigenous Peoples’ Day (United States)
    • October 14 – Thanksgiving Day (Canada)
    • October 16 – Sukkot (Jewish)
    • October 16 – Bosses’ Day
    • October 19 – Spirit Day (LGBTQ+ anti-bullying)
    • October 20 – Birth of the Bab (Baha’i)
    • October 20 – Sikh Holy Day (birth of Guru Granth)
    • October 21 – Waste Reduction Week
    • October 22 – International Stuttering Awareness Day
    • October 31 – Halloween
    • October 31 – Diwali (Hindu)
November

Month-long observances:

  • Diabetes Awareness Month
  • National Native American, American Heritage Month

Important EDI calendar dates:

    • November 1-2 – Dia de Muertos
    • November 1 – All Saints’ Day (Roman Catholic)
    • November 1 – National Stress Awareness Day
    • November 2 – All Souls’ Day
    • November 5 – Election Day (USA)
    • November 9 – World Freedom Day
    • November 9 – World Adoption Day
    • November 11 – Remembrance Day
    • November 11 – Veterans Day
    • November 12 – Birth of Baha’u’llah (Baha’i)
    • November 13 – World Kindness Day
    • November 16 – International Day for Tolerance
    • November 19 – International Men’s Day
    • November 20 – Transgender Day of Remembrance
    • November 20 – World Children’s Day (Human Rights, U.N.)
    • November 28 – Thanksgiving
    • November 25 – Day of the Covenant (Baha’i)
    • November 27 – Ascension of Abdu’l-Baha (Baha’i)
December

Month-long observances:

  • HIV/AIDS Awareness Month
  • Universal Human Rights Month

Important December EDI calendar dates:

    • December 1 – World AIDS Day
    • December 3 – International Day for People with Disabilities
    • December 3 – Giving Tuesday (USA)
    • December 5 – International Volunteer Day
    • December 7 – Pearl Harbor Remembrance Day (USA)
    • December 9 – International Genocide Prevention Day
    • December 10 – International Human Rights Day
    • December 18 – International Migrants Day
    • December 21 – Yule Winter Solstice (Pagan)
    • December 25 – Christmas (Christian)
    • December 25 – Hanukkah begins at sunset (Jewish)
    • December 26 – Kwanzaa week (Celebration of African Customs & Cultures)
    • December 26 – Boxing Day
    • December 31 – New Year’s Eve
    • January 2, 2025 – Hanukkah ends at sunset (Jewish)

Please note that while we have attempted to include all important diversity and inclusion dates in this calendar, we do not claim completeness and regret if an important date has escaped our attention. We appreciate any feedback or comments that contribute to completeness. Thank you for your understanding.

Let’s continue to recognize and celebrate diversity and inclusion throughout the year and work towards creating an inclusive environment for all.

Skip to content