MaxJobsClub US Contractor
Senior Data Modeler for Data Warehouse with ACCORD experience
12-24 Months Contract
The Data Analytics and Engineering (DAE) is expanding its data modeling team. DAE Data Modelers design analytical databases that translate complex business data into usable computer systems. Data Modelers work with data architects to design databases and data structures that meet organizational needs using conceptual, logical, and physical data models. Their models are designed to improve efficiency and business value and may focus on issues such as reducing data redundancy, improving data quality or improving data movement across systems.
An ideal DAE Data Modeler is an analytical and creative thinker who is not intimidated by roadblocks and challenges. They understand how to successfully evaluate problems and develop appropriate solutions. Data Modelers perform well under pressure, possessing great focus while completing projects efficiently. They should be able to work well as part of a team, but also carry responsibility for their own work. Data Modelers also need to be able to work on multiple projects at a time, with the ability to quickly understand and incorporate new technologies. Below are the skills and abilities that DAE will look for in a Data Modeler.
What you will do:
• Work with the Data Office, DAE and Application Development teams to translate business needs into data models
• Create and Maintain Conceptual, Logical and Physical Data Models
• Participate in Data Governance procedures and policy management
• Mentor, contribute and govern Data Management standards and best practices
What you will need:
• Bachelor’s degree in Computer Science or similar
• 5+ years experience translating Business rules into Conceptual, Logical & Physical data models for a data lake and data warehouse
• 5+ years experience with modeling tools such as Erwin or ER/Studio
• Prior experience with Data Warehouse modeling techniques using Data Vault 2.0
• 2+ years experience with Snowflake
• 3+ years experience with cloud-based Data Warehouse and Data Lake environments
• Software Development experience with SQL
• Experience in converting relational data models to semi-structured data (XML, JSON) or vice versa
• Must be able to work independently and collaboratively on large scale data projects
Experience in these areas is a Plus:
• Experience in the insurance industry
• Experience with industry standard data models such as ACORD is a must have
• Experience with ETL tools such as Informatica or Snaplogic
• Exposure to Business Intelligence tools (PowerBI, MicroStrategy)
• Experience with MDM solutions
• Exposure with messaging solution like Kafka and MQ