Data Analyst / Data Architect

Precise Resource; United States; Remote; USD 80,000 - 100,000; Full time

Job summary

Join a forward-thinking company as a Sr. Data Analyst/Architect/Modeler, where your expertise in data architecture and integration will shape the future of the insurance industry. This exciting role involves designing and developing comprehensive data solutions that provide critical insights and enhance business performance. You will work closely with clients to gather requirements, model data, and implement state-of-the-art data warehouses and lakes. If you're passionate about leveraging cutting-edge technologies and thrive in a dynamic environment, this opportunity is perfect for you to make a significant impact.

Qualifications

• 5+ years of data architecture experience focused on data integration.
• 3+ years of experience in the P&C insurance domain is essential.

Responsibilities

• Design and develop enterprise data solutions for insurance data warehouses.
• Collaborate with business analysts to gather data requirements.

Skills

Data Architecture

Data Integration

Data Modeling

ETL/ELT

SQL Server

Azure SQL

Data Profiling

Data Cleansing

Communication Skills

Time Management

Education

Bachelor's Degree in Computer Science or related field

Tools

ER/Studio

ERWin

Microsoft SQL Server

AWS

Oracle

Google Cloud

Job description

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