Sr. Data Analyst/Architect/Modeler

Precise Resource, Inc. is a leading privately held Woman Business Enterprise specializing in Executive Search, Recruiting, and staff augmentation services for Fortune 1000 clients across the United States. One of our more prestigious clients has asked for our assistance in seeking a Business Analyst to join their organization. As a Sr. Data Analyst/Architect/Modeler, our client believes in having you feel like joining their team is about being part of something bigger.

Our client is a trailblazer in the insurance industry, revolutionizing data and analytics through their unique platform. They offer the only insurance-specific solution that works seamlessly on any cloud platform and leverages cutting-edge technologies like generative AI, machine learning, and natural language processing. This gives insurers unparalleled insights and a competitive edge in managing their businesses. 

What you'll be doing:

You will work with Insurance clients and business analysts to gather data and analytics requirements, and then design and develop data repository solutions to provide business insights and manage business performance. The person will be responsible for analyzing, modeling, designing, and delivering Insurance data warehouses, operational data stores, data lakes, data marts, reporting, and extending and implementing our in-house data and analytics platform.

Responsibilities:

  • Own the analysis, design and development of the enterprise (whole) data solution for Insurance (P&C) data warehouses, staging, ODS, data marts & semantic layers, reports and analytics, (ideally using ER/Studio or ERWin).
  • Design and develop all data models conceptual, logical and physical.
  • Instantiate the physical models on SQL Server, Azure SQL databases applying techniques to optimize for data load, data storage and data access.
    • Experience with AWS & Google and NoSQL databases is a “nice to have”.
  • Design the solution to support two-way integration of data sourced from core insurance transactional systems (policy, billing, claims, reinsurance), web-based applications, and other external sources as needed.
  • Design solutions to enable integration with structured and unstructured data, using ETL, ELT, XML, JSON
  • Ensure analysis and design is completed efficiently and accurately and incorporates the entire set of data requirements.
  • Own creation and maintenance of documentation across the entire life-cycle.
  • Participate in pre-sales, sales, training and support.
  • Deliver remotely or on-site technical engagement with clients.
  • Works with Analytics Developers, Architects and ETL Developers to design and develop the complete technical solution.


Minimum Qualifications/Experience/Attributes:

  • Must have 3 Years P&C Insurance domain experience.
  • Must have 5 years of data architecture experience, with a heavy emphasis on data architecture and data integration.
  • Must have experience data mapping supporting integration and historical data loading.
  • Must have 5 years of hands-on IT experience designing, modeling (in ER/Studio, ERWin, or similar), and implementing data lakes, data warehouses, ODS, and data marts/semantic layers.
  • Strong experience/exposure to one or more of Microsoft, Oracle, AWS, Google, data management tools.
  • 3 years of experience with data profiling and data cleansing.
  • Demonstrated ability to liaise closely with business and IT leadership to establish, defend, and persuade implementing recommended solutions.
  • Strong communication, organizational, interpersonal and time management skills.
  • Ability to work independently with minimal direction and the ability to deal with a dynamic environment.
  • Experience leading others through the full development life-cycle.



Click here to apply online
Job Type
Full-Time Regular