Data Modeler / Architect

Responsibilities Kforce has a client that is seeking a Data Modeler/Architect. This role is Hybrid, 3 days: Alpharetta, GA; Charlotte, NC; Chicago, IL; Conshohocken, PA; Dallas, TX; Denver, CO; Fargo, ND; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Morristown, NJ; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS. Summary: The Data Modeler/Architect is a pivotal role focused on designing, modeling, and mapping data solutions for the enterprise data warehouse. This position requires a strategic approach to data architecture, ensuring robust data models and seamless data integration. The Data Modeler/Architect will collaborate with business stakeholders and IT teams to drive data initiatives that enhance operational performance and support the development of an industry-leading data warehouse. Responsibilities: • Collaborate with business stakeholders and IT teams to define and document data architecture and modeling needs • Architect and design comprehensive solutions for the enterprise data warehouse; Sourcing data from multiple Insurance and Reinsurance Policy, Treaty, Claim and financial systems • Design and implement Source to Target mappings optimized for high-volume data integration • Create logical and physical data models and implement them on SQL Server platforms • Work closely with the development team to ensure accurate translation of mappings into code • Develop strategies for data collection and ingestion and write SQL based solutions to validate data accuracy and integrity in the data warehouse • Analyze and design enterprise data models for optimal reporting; Support reporting teams in understanding and utilizing the data warehouse model effectively • Participate in release planning and validate changes post-deployment • Develop SQL Server views for reporting and dashboard development • Troubleshoot and optimize SQL and Informatica mappings and stored procedures Requirements • B.S. degree in Computer Information Science, Information Management, or Statistics • 10+ years of data architecture and design experience working with development team to extract data directly from source applications and loading to an enterprise data warehouse • 3+ years of experience within the Insurance and reinsurance domain • Advanced experience with extracting data from Insurance applications • Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts, and frameworks • Knowledge of RDBMS platforms (SQL Server, DB2, etc.) with experience in generating DDL • Capable of creating and tuning Semantic layer Reporting Views • Capable of facilitating data discovery sessions involving business subject matter experts • Strong interpersonal skills, including both written and verbal communication skills • Strong organizational skills and analysis skills • Possess the ability to work as part of a team • Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-CD & SAP FI-GL applications The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future. We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave. Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law. This job is not eligible for bonuses, incentives or commissions. Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. By clicking “Apply Today” you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.