Sr. MDM Developer (Hybrid)

At Selective, we don't just insure uniquely, we employ uniqueness.

Our Business

Selective is a midsized U.S. domestic property and casualty insurance company with a history of strong, consistent financial performance for nearly 100 years. Selective's unique position as both a leading insurance group and an employer of choice is recognized in a wide variety of awards and honors, including listing in Forbes Best Midsize Employers in 2023 and certification as a Great Place to Work in 2023.

Working at Selective

At Selective, we don't just insure uniquely - we employ uniqueness. Employees are empowered and encouraged to Be Uniquely You by being their true, unique selves and contributing their diverse talents, experiences, and perspectives to our shared success. Together, we are a high-performing team working to serve our customers responsibly by helping to mitigate loss, keep them safe, and restore their lives and businesses after an insured loss occurs. Employees receive comprehensive total rewards packages - including competitive compensation and performance awards, health benefits, and retirement savings - and professional development opportunities and flexible schedules to support their health, wealth, and well-being. Join our team and help make a difference.

Overview:

Selective is seeking an experienced Sr. Developer for MDM, ETL and BI Applications in the Information Management department. This person will be responsible to provide technical expertise to design and implement for all batch and real time data integrations as per functional business and non-functional technical requirements. They will be the senior hands-on developer for data, MDM, ETL and BI platforms in the team working under the general direction of a team lead or manager. They will collaborate with business partners, identify, and document IT system requirements for business change requests, perform efficient and effective analysis of system problems and manage the on-going maintenance of a group of related systems.

Responsibilities:

• Data Modeling and low-level technical design in MDM including developing data integrations for batch, bulk/incremental/real time REST APIs, define rules for standard REST API/SIF/Message Queue based integration for Search-before-create, bi-directional sync, implement Match Rules, develop extensions, user exits, and composite web services for solution integration etc.
• Works with Enterprise Architects to create as well as review low level and high-level design documents, data flow designs, support architectural solutions, develops MDM, ETL, BI, Data, strategies, roadmaps for one or more technology domains.
• Provide mentorship and guidance to Junior developers in MDM, ETL, SQL, BI technologies, overall design of data, best practices, innovation, designs, and processes.
• Provides support for escalated production issues and as well as issues in any phase of the development lifecycle across MDM, ETL, BI and data applications.
• Supports continuous improvement by identifying and proposing tuning opportunities and opportunities to increase efficiency, quality, and speed to market.

Qualifications:

• Hands-on experience with Informatica MDM, standard REST API/SIF/Message Queue based integration for Search-before-create, bi-directional sync.
• Experience on Informatica MDM hub components: Landing tables, base objects, staging tables, lookup tables, relationships, mappings, cleanse function, trust and matching rules, hierarchy management, E360 (provisioning) etc.
• Hands-on Experience in creating mappings, mapplets, sessions, workflows, worklets in Informatica Data Quality (IDQ).
• Strong functional knowledge and experience mastering multiple domains.
• Hands-on experience with relational databases and SQL.
• Experience with IICS and/or Informatica PowerCenter, Cognos, Power BI or other ETL or BI technologies is preferred.
• Experience working with cross functional teams to execute projects in Agile and/or SAFe methodologies.
• Superior technical knowledge in Data Quality, Standards, Governance, and Design.
• Bachelor's degree in Computer Science, Management Information Systems, or related field preferred.

Salary range: $90,000 - $130,000. The actual base salary is based on geographic location, and the range is representative of salaries for this role throughout Selective's footprint. Additional considerations include the candidate's qualifications and experience.

Selective is an Equal Employment Opportunity employer. That means we respect and value every individual's unique opinions, beliefs, abilities, and perspectives. We are committed to promoting a welcoming culture that celebrates diverse talent, individual identity, different points of view and experiences - and empowers employees to contribute new ideas that support our continued and growing success. Building a highly engaged team is one of our core strategic imperatives, which we believe is enhanced by diversity, equity, and inclusion. We expect and encourage all employees and all of our business partners to embrace, practice, and monitor the attitudes, values, and goals of acceptance; address biases; and foster diversity of viewpoints and opinions.

Selective maintains a drug-free workplace.