Enterprise Data Specialist

2 weeks ago

Kansas City, MO, United States Nexus IT Group Full time

The Enterprise Data Specialist 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 Enterprise Data Specialist 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:
  • 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.
  • Capable of creating and tuning Semantic layer Reporting Views.
  • Capable of facilitating data discovery sessions involving business subject matter experts.
  • Knowledge of RDBMS platforms (SQL Server, DB2, etc.) with experience in generating DDL.
  • Candidate has strong interpersonal skills, including both written and verbal communication skills.
  • Possess the ability to work as part of a team.
  • Candidate has strong organizational skills and analysis skills.
  • Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-CD & SAP FI-GL applications.
  • B.S. Degree in Computer Information Science, Information Management, or Statistics.

  • SBA Reporting Specialist

    1 week ago

    Kansas City, MO, United States Enterprise Bank and Trust Full time

    Enterprise Bank & Trust was founded in the spirit of entrepreneurship and community. From the small mom-and-pop coffee shop to the large construction company that employs local people, our goal is to help businesses succeed and our communities thrive. With offices in Arizona, California, Florida, Kansas, Missouri, New Mexico, Nevada and Texas, we're strong,...

  • SBA Reporting Specialist

    2 weeks ago

    Kansas City, MO, United States Enterprise Bank and Trust Full time

    Enterprise Bank & Trust was founded in the spirit of entrepreneurship and community. From the small mom-and-pop coffee shop to the large construction company that employs local people, our goal is to help businesses succeed and our communities thrive. With offices in Arizona, California, Florida, Kansas, Missouri, New Mexico, Nevada and Texas, we're strong,...

  • SBA Reporting Specialist

    2 weeks ago

    Kansas City, MO, United States Enterprise Bank and Trust Full time

    Enterprise Bank & Trust was founded in the spirit of entrepreneurship and community. From the small mom-and-pop coffee shop to the large construction company that employs local people, our goal is to help businesses succeed and our communities thrive. With offices in Arizona, California, Florida, Kansas, Missouri, New Mexico, Nevada and Texas, we're strong,...

  • SBA Reporting Specialist

    5 days ago

    Kansas City, MO, United States Enterprise Bank and Trust Full time

    Enterprise Bank & Trust was founded in the spirit of entrepreneurship and community. From the small mom-and-pop coffee shop to the large construction company that employs local people, our goal is to help businesses succeed and our communities thrive. With offices in Arizona, California, Florida, Kansas, Missouri, New Mexico, Nevada and Texas, we're strong,...

  • Enterprise Systems Administrator

    1 week ago

    Kansas City, MO, United States Spotlight | Analyst Relations Full time

    Spotlight is a fast-growing, tech-enabled services firm focused on Analyst Relations (AR)-the strategic discipline of engaging with industry analysts (like Gartner and Forrester) to influence market perception and drive business growth. This is a mission-critical function for major B2B and SaaS organizations. As our Enterprise Systems Administrator, you will...

  • Enterprise Systems Administrator

    2 weeks ago

    Kansas City, MO, United States Spotlight | Analyst Relations Full time

    Spotlight is a fast-growing, tech-enabled services firm focused on Analyst Relations (AR)-the strategic discipline of engaging with industry analysts (like Gartner and Forrester) to influence market perception and drive business growth. This is a mission-critical function for major B2B and SaaS organizations. As our Enterprise Systems Administrator, you will...

  • ACC Specialist

    4 days ago

    Kansas City, MO, United States Olsson Full time

    ACC Specialist - Data Center Fayetteville, AR; Fort Worth, TX; Lincoln, NE; North Kansas City, MO; Oklahoma City, OK; Omaha, NE; Overland Park, KS; Phoenix, AZ; Tulsa, OK Company Description We are Olsson. We engineer and design solutions that improve the world around us. As a company, we promise to always be responsive, transparent, and focused on results -...

  • Senior Product Manager

    3 hours ago

    Kansas City, MO, United States Acryl Data Full time

    Senior Product Manager - Catalog DataHub is an AI & Data Context Platform adopted by over 3,000 enterprises, including Apple, CVS Health, Netflix, and Visa. Innovated jointly with a thriving open-source community of 13,000+ members, DataHub's metadata graph provides in-depth context of AI and data assets with best-in-class scalability and extensibility. The...

  • Senior Product Manager

    2 minutes ago

    Kansas City, MO, United States Acryl Data Full time

    Senior Product Manager - Catalog DataHub is an AI & Data Context Platform adopted by over 3,000 enterprises, including Apple, CVS Health, Netflix, and Visa. Innovated jointly with a thriving open-source community of 13,000+ members, DataHub's metadata graph provides in-depth context of AI and data assets with best-in-class scalability and extensibility. The...

  • Data Integrity Specialist

    2 weeks ago

    Kansas City, MO, United States Saint Luke's Health System Full time

    Job Description We are seeking a Data Integrity Specialist to join our team! You must have a working knowledge of HIM to be considered for this role. To meet this expectation, you should have prior work experience in HIM or a HIM degree. The entire job description is below. The main objective of this position is to maintain an accurate and concise Master...