Advisory Data Modeler
Company: Church Mutual Insurance Company, S.I.
Location: Milwaukee
Posted on: May 28, 2023
|
|
|
Job Description:
As part of the Church Mutual team, you'll work with some of the
most experienced and knowledgeable people in the industry and
achieve your own growth and career satisfaction while finding
fulfillment in serving those who serve others. We foster a
workplace where all employees are treated with dignity and respect;
diversity, inclusion and belonging are woven into the fabric of our
company through our customers, employees, leadership, business
relationships and outreach programs. Join us and Stand for
Good.
Working with Data Architect, provide design and implementation of
data model solutions using relational and dimensional databases to
translate business needs into long-term solution data models that
are easily used by end users for reporting and analytics. Evaluate
existing systems and work with a development team to create
conceptual data models and data flows that address their needs.
These solutions streamline and support enterprise information
management. Troubleshoot and optimize data systems and evaluate
implemented systems for variance discrepancies and efficiency.
Responsible for the development of the conceptual, logical, and
physical data models, the implementation of Relational Database
Management System (RDBMS), Operational Data Store (ODS), data
warehouse, data marts, and data lakes on target platforms
(SQL/NoSQL).
Oversee and govern the expansion of existing data architecture and
the optimization of data query performance via best practices. The
candidate must be able to work independently and
collaboratively.
***This is a hybrid position that requires two days per week in the
office and can be based in either our Downtown Milwaukee or Merrill
Wisconsin locations. ***
--- Creating a visual representation of either a whole information
system or parts of it to communicate connections between data
points and structures.
--- Create and maintain conceptual/logical and physical data models
along with accurate metadata to identify key business entities and
visual relationships.
--- Create conceptual, logical, and physical data models.
--- Work with business and IT teams to understand data
requirements.
--- Implement business and IT data requirements through new data
strategies and designs across all data platforms (relational,
dimensional, and NoSQL) and data tools (reporting, visualization,
analytics, and machine learning).
--- Work with business and application/solution teams to implement
data strategies, build data flows, and develop
conceptual/logical/physical data models.
--- Maintain a data dictionary consisting of table and column
definitions.
--- Review data model with technical and business audience as
necessary.
--- Perform data profiling/analysis activities.
--- Identify the architecture, infrastructure, and interfaces to
data sources, tools supporting automated data loads, security
concerns, analytic models, and data visualization.
--- Hands-on modeling, design, configuration, installation,
performance tuning, and sandbox POC.
--- Work proactively and independently to address project
requirements and articulate issues/challenges to reduce project
delivery risks.
--- Work with Database Administrators (DBAs) to develop and ensure
adherence to data modeling standards, as well as deployment of any
data model changes.
--- Collaborate with application developers and Extract, Transform,
and Load (ETL) developers and project teams to design and build
data model to support project needs.
--- Develop, implement, and support the usage of data visualization
toolkit, configuration, deployment, and usage.
--- Solution architecture, design, and development of models for
small projects.
--- Create conceptual data model to identify key business entities
and visualize their relationships.
--- Provide documentation of solution design, as well as end user
training and change management communications at times.
--- Present and communicate modeling results and recommendations to
internal stakeholders.
--- Communicate physical database designs, DBA, and explains
features that may affect the physical data model.
--- Implementing data strategies and developing physical data
models.
--- Troubleshooting and optimizing data systems
--- 3+ years' experience in a data modeler role, with working
knowledge of information systems and integration/design
solutions.
--- Related insurance experience preferred.
--- Bachelor's degree in related field (e.g., business, finance, or
technical) or equivalent experience required.
--- Expertise in data modeling principles/methods, including
conceptual, logical and physical data models.
--- Ability to clearly communicate complex technical ideas,
regardless of the technical capacity of the audience.
--- Strong inter-personal skills.
--- Strong ability to work independently, as well as part of a
team.
--- Experience working with dimensionally modeled data.
--- Experience with data modeling tools.
--- Strong knowledge of Microsoft Office tools.
--- Knowledge of Systems Development Life Cycle (SDLC)
methodologies.
--- Knowledge of Property & Liability insurance industry.
--- Knowledge of insurance IT systems.
--- Ability to adapt.
--- Strategic thinking and planning skills.
--- Negotiation skills.
--- Leadership skills.
--- Decision-making skills.
--- Strong problem-solving skills.
--- Strong data analysis skills.
--- Strong Structured Query Language (SQL) skills.
--- Ability to work in a fast-paced environment.
--- Strong attention to detail.
--- Experience with SQL Server, Azure Synapse.
--- Experience with cloud architecture.
Church Mutual is an equal opportunity employer. All qualified
applicants will receive consideration for employment without regard
to race, color, religion, sex, sexual orientation, gender identity,
national origin, veteran or disability status.
ID: 20233079
External Company Name: Church Mutual Insurance, S.I.
External Company URL: www.churchmutual.com
Street: 833 E Michigan Street
Keywords: Church Mutual Insurance Company, S.I., Milwaukee , Advisory Data Modeler, Other , Milwaukee, Wisconsin
|
Click
here to apply!
|
