Enterprise Data Architect

We are seeking an Enterprise Data Architect to spearhead data initiatives.
In this pivotal role, you will define data architecture strategies and drive solutions for our enterprise data warehouse. You will collaborate with business and IT teams to ensure that our data systems are high-performing and scalable. If you are ready to influence the data domain, we encourage you to apply.

#LI-DNI

Responsibilities

• Collaborate with business stakeholders and IT teams to define and document data architecture requirements
• Define and design solutions for the enterprise data warehouse, integrating data from diverse insurance and reinsurance systems
• Map Source to Target processes tailored for processing high data volumes
• Develop logical and physical data models for implementation on Microsoft SQL Server platforms
• Coordinate closely with the development team to ensure proper implementation of mappings into executable code
• Outline methodologies for data collection and validation with SQL-based solutions to ensure data quality
• Create enterprise data models for reporting and guide reporting teams in leveraging the data warehouse efficiently
• Engage in release planning activities and verify post-deployment system changes
• Build Microsoft SQL Server views to support reporting and dashboard creation
• Identify and resolve issues in SQL and Informatica mappings, as well as optimize stored procedures

• 7 years of experience in data architecture and design collaborating with development teams
• 5 years of domain expertise in insurance and reinsurance industries
• Background in extracting data from insurance applications
• Extensive proficiency in data warehousing, ETL, and business intelligence architectures
• Competency in designing and refining semantic layer reporting views
• Knowledge of relational database management systems such as Microsoft SQL Server
• B.S. degree in Computer Information Science, Information Management, or Statistics
• Proficiency in interpersonal communication, both written and verbal
• Collaboration skills for effective teamwork
• Strong organizational acumen and analytical mindset

• Knowledge of Guidewire Policy Center and Guidewire Claims Center
• Familiarity with SAP Financial Services Collections and Disbursements and SAP Financial Accounting General Ledger applications

• Career plan and real growth opportunities
• Unlimited access to LinkedIn learning solutions
• International Mobility Plan within 25 countries
• Constant training, mentoring, online corporate courses, eLearning and more
• English classes with a certified teacher
• Support for employee's initiatives (Algorithms club, toastmasters, agile club and more)
• Enjoyable working environment (Gaming room, napping area, amenities, events, sport teams and more)
• Flexible work schedule and dress code
• Collaborate in a multicultural environment and share best practices from around the globe
• Hired directly by EPAM & 100% under payroll
• Law benefits (IMSS, INFONAVIT, 25% vacation bonus)
• Major medical expenses insurance: Life, Major medical expenses with dental & visual coverage (for the employee and direct family members)
• 13 % employee savings fund, capped to the law limit
• Grocery coupons
• 30 days December bonus
• Employee Stock Purchase Plan
• 12 vacations days plus 4 floating days
• Official Mexican holidays, plus 5 extra holidays (Maundry Thursday and Friday, November 2nd, December 24th & 31st)
• Relocation bonus: transportation, 2 weeks of accommodation for you and your family and more