About the Role
Job Title: Data Analyst - Financial Industry with Life Insurance experience
Type: Contract: 6+ Months
Location: Boston,MA/ Remote anywhere in the US.
As an Data Analyst, one must have advanced knowledge of application, data, and infrastructure disciplines. You’ll use your skills to implement data strategies, analyse and build data flows, and develop conceptual data models. You’re capable of working independently and communicating effectively to provide feedback on policies, procedures, processes, and standards.
Objectives of the role:
? Manage database design and data models for a specific application. Analyze existing data and recommend changes that lead to a reduction of stored data without impacting business requirements.
?Daily and monthly responsibilities
Perform as a technical data steward – understanding tables, data use, data replication, data connection, and data lineage – and take accountability for data hygiene.
? Review existing data model and recommend changes to optimize data requirements.
? Analyze source system data and look for data redundancy and duplication. Work with Application Architects to review exiting data models and suggest action to reduce input data for storage optimization.
?Work with the development team to implement data strategies, build data flows, and develop conceptual data models.
? Create logical and physical data models using best practices.
Delivers and provides feedback for data modeling policies, procedure, processes and standards.
?Assists with capturing and documenting system flow and other pertinent technical information about data, database design, or systems.
Required Qualifications:
• Overall IT experience 10+ years required.
• 6+ years as Data Analyst in Data Warehouse projects preferably in Financial Industry with Life Insurance experience
• Advance SQL hands-on experience.
• Good communication and articulation skills.
Preferred Qualifications
? Advanced knowledge of application, data and infrastructure disciplines.
? Experience with Life Insurance or any insurance related products
? Expertise in tuning and debugging SQL and resolving application specific bottlenecks.
Experience facilitating meetings and providing presentations to stakeholders and senior leaders.
?Data modeling, data warehousing, dimensional modeling, data modeling for big data and metadata management.
? Data Lake and Big Data modeling experience.
? Excellent communication, problem solving, organizational and analytical skills. Understanding of enterprise and reporting modeling concepts, including dimensional modeling, snowflakes, slowly changing dimensions, schema on read, irregular dimensions, and surrogate, compound and intelligent keys.
?Advanced degree in computer engineering, computer science, information systems, or related field.
? Able to work independently.
? Experience with Hadoop, Spark, and Kafka
? Experience with Scala
? Strong communication and interpersonal skills.
? Ability to present design of the solution to various stakeholders.
? Experience in data modeling and design in the insurance and financial industries.