Data Warehouse Specialist

Xceedance is a global provider of consulting and managed services, technology, and data sciences to insurance organizations. With offices in the United States, United Kingdom, Poland, and India, Xceedance helps insurers launch new products, drive operations, implement technology, and deliver advanced analytics capabilities and process optimization. The experienced insurance professionals at Xceedance enable re/insurers, brokers, and program administrators worldwide to enhance policyholder service, enter new markets, boost workflow productivity, and improve profitability. For more information, visit www.xceedance.com.

Position Title: Data Modeler

JOB OBJECTIVE:

As a Data warehouse/Data Modeler, you will be responsible for designing and developing Relational and Dimensional data models that align with our organization's data strategy and business requirements. Your expertise in data modeling and understanding of data structures will play a critical role in shaping our data infrastructure and supporting effective data management practices. This position will be a hands-on data modeling role. You will create and maintain data models through effective data management practices. You will work closely with analysts to correctly translate requirements into the development team's technical design. In this role, you will assist application and data engineers at all levels with interpreting requirements, creating detailed designs, conducting Data Model and SQL reviews, and participating in all phases of the agile development cycle.

ESSENTIAL JOB DUTIES AND RESPONSIBILITIES:

"Success will be measured by the individual's ability to deliver and help others deliver well-architected data models at a steady pace of innovation. Co-design data models with DevOps and data warehouse product teams for OLTP, OLAP, and AI. Design, develop, test and publish logical/physical data models for Azure Cloud.

• Determine the impact of the Enterprise Data Model (EDM) and refine the EDM as needed as new applications or products are added.

• Research data sources for new business data and better sources of data feeds

• Participate in business requirement definition and review business requests for data and usage.

• Participate in application design reviews to ensure data model adherence and data standards.

• Ensure alignment with Data Governance practices.

• Work closely with the Architect(s) to ensure the EDM is integrated with development efforts.

• Ensure all data has a complete and accurate definition

• Establish and monitor data quality initiatives. "

Builds and Maintains Logical and Physical Data Model

• Develop, enhance, and maintain data warehouse and data mart logical & physical data models.

• Design conceptual and logical data models and data flows, ensuring data security and compliance with Financial and Banking industry regulations

• Work closely with the Data Base Architect (DBA) team to implement the physical data model.

• Analyze content and quality of data model(s) and databases. "

Participates in Agile Ceremonies/on Agile Team

• Participates by leading, listening, asking questions, and collaborating with the Agile team in Agile Ceremonies and discussions. Makes suggestions and presents ideas for team and process improvements. "

Communication

• Leads and facilitates collaboration among the team.

• Lead and facilitate data model review sessions

• Regularly collaborates with stakeholders to solve data-related business issues by gaining an understanding of business’s requirements, providing technical knowledge and recommendations on how data products and processes could benefit their teams, and communicating project expectations and status updates.

• Work with Developers, Managers, and others to determine new data sources, technologies, and other ways the Data Warehouse can better serve customers’ needs. "

ADDITIONAL DUTIES:

Coaching and Mentoring

• Regularly assists and guides junior data modelers or architects on day-to-day tasks. "

Best Practices

Understands best practices and how to leverage/implement them. Identifies areas for implementing and improving best practices within products or processes. Guides and instructs others on the use of best practices. Aids in the proposal, planning, and creation of methods and procedures to enable best practices for secure coding and handling of data. Uses technologies essential to development activities, including source control software, development environments, deployment software, and integration applications. Supports and follows best practices for continuous integration and continuous delivery."

Security

Assists with identifying and managing security risks within software products and data processes. May collaborate with Information Security team to identify, understand, and help resolve security risks within new and existing applications. Clearly communicates risks to technology team members and suggests appropriate course(s) of action to mitigate risks. Assists others in work aimed at mitigating risks and vulnerabilities within software applications.

Ensure the data model is designed and implemented with the appropriate data security and privacy controls."

Documentation

Creates and delivers documentation whenever necessary. Creates and maintains clear and accurate written documentation and procedures.

Create mapping documents to document business logic rules to transform data before loading it into the target data warehouse.

Guides and instructs team members and others on documentation needs, creation, maintenance, etc."

Knowledge, Skills, and Abilities: (*minimum qualifications needed to perform essential job function)

Required Knowledge:

*Bachelor's degree in MIS, Data Science, Computer Science, Computer Engineering, or related field or equivalent

*Database manipulation software and/or software application development (ex. .NET, SQL, Python, DB2, Teradata, Azure Synapse etc.)

*Database Management Systems (SQL Server, Azure, Oracle, Teradata, DB2)

*Experience with Data Modeling techniques and tools, such as Erwin or Embarcadero

*3-5 years of related IT work experience

*1-2 years 7of related Data Modeling work experience

*Strong knowledge of Azure Data platform its features, capabilities and the best use of implementing them

*Experience working with Data Warehouses, Data Marts, etc.

Preferred Knowledge:

Knowledge of Agile methodologies (Scrum, Kanban, etc.)

Cloud, database, or project management certification or designation

Insurance coverages and rating schemes and insurance products

Knowledge of P&C Insurance business

Cloud-based technologies ex.Azure (DevOps, Data Studio, etc.)

Artificial intelligence/machine learning

Prior Knowledge of Guidewire Policy, Billing, claim, Data Hub & Info Cen

Strong knowledge in Microsoft Azure cloud stack such as SQL PaaS Synapse Analytics MPP Data Factory ADF

At Xceedance, you will discover the possibility to exceed yourself and grow persistently with us. We offer career development opportunities to our members for a well-rounded development throughout their journey with us. Xceedance is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, sexual orientation, gender expression, gender identity or any other characteristic protected by law.