Data Modeler

Ideally Mexico Nearshore Data Modeler

Bill rate is 35.00 for 6-7 years of experience and 50.00 for more than 10 years of experience. Priority for experience modeling for analytics. Experience with Snowflake. Strong with physical models.

General Summary: Working as part of a multi-disciplinary team, the data architect designs, deploys, and manages the information management solution architecture and associated technologies. Collaborates with key business and IT stakeholders to develop requirements and standards for how information will be modeled, stored, integrated, consumed, and managed across the organization. Proactively develops and leverages knowledge of source and target systems and technologies to execute responsibilities.

Principle Duties:

1. Works closely with business and IT stakeholders to optimize information assets by defining business requirements and delivering appropriately structured information and analytical solutions
2. Builds an inventory of information assets needed for solution architecture, and creates a vision for how information will flow through the organization leveraging existing platforms and processes where applicable
3. Responsible for the design, security, compliance, reliability, and performance of the solution architecture
4. Designs complex data models, develops capacity planning, and implements systems
5. Designs, develops, and maintains business intelligence solutions
6. Produces and enforces standards, processes, and procedures for the solution architecture
7. Works in an agile environment and continuously reviews business needs, refines priorities, outlines milestones and deliverables, and identifies opportunities and risks
8. Seeks continuous performance improvement and ensures the security of information
9. Acts as a resource and impacts the quality of work for colleagues with less experience
10. Builds an understanding of source application databases by analyzing data models and leveraging data profiling techniques.
11. Performs other duties as assigned

Education: Bachelor's degree or equivalent education/experience

Experience:

• 10+ years information management, data warehouse or other relevant experience
• 5+ years database, data modelling, data transformation and data analysis experience
• Prior experience as an Information Architect, Lead Data Engineer or Data Warehouse Architect
• Proven history of designing and building Data Hubs or Operational Data Stores to collect and facilitate access to data assets
• Demonstrated ability to quickly learn new technologies
• Demonstrated ability to lead small teams and projects
• Advanced ability to solve complex problems, drawing upon creativity, experience, and multiple sources of information
• Advanced interpersonal skills, including the ability to build consensus and influence decisions
• Advanced communication skills, including the ability to communicate complex or difficult information in straightforward manner

Preferred:

• Experience with iterative development methodologies
• Experience working with global teams in global organizations
• Insurance and/or reinsurance industry knowledge or certification

Technical Requirements:

• Analytical Databases (Vertica, Snowflake, etc.)
• Analytical Tools (Tableau, Power BI, etc.)
• Data Transformation Tools (Informatica Powercenter, Talend, etc.)
• Data Matching and Entity Resolution packaged software
• Experience with cloud and on-premise solutions
• Streaming Tools (Kafka, Storm, Kinesis, Qlik Replicate, etc.)
• Erwin data modelling tool
• Azure DevOps or Team Foundation Server (TFS)

Benefits (employee contribution):

• Health insurance
• Health savings account
• Dental insurance
• Vision insurance
• Flexible spending accounts
• Life insurance
• Retirement plan

All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Rate of pay within the stated range will depend on the qualification of the applicant.