Data Engineer II

Electronic Arts Inc. is a global leader in interactive entertainment. We develop games, content and online services across platforms. We have a broad portfolio of brands that span the most popular genres.

We exist to Inspire the World to Play. We create extraordinary new game experiences for our millions of players everywhere by bringing together experienced people that combine creativity, innovation, and passion. We celebrate diversity and inclusion and aim to create great experiences for our employees as often as our players. We're looking for people to come to the office or Zoom meeting excited to work and ready for some fun. The Senior Data Engineer will report to Sr Manager Engineering responsible for Data & Insights.

Join us in driving the next revolution in games.

Responsibilities:

• Design, build, and optimize scalable data acquisition and integration solutions to meet business requirements.
• Develop and maintain ETL processes for extracting, transforming, and loading (ETL) data from various sources into appropriate databases with accuracy and timeliness.
• Optimize data integration systems for performance as data volume grows, ensuring high quality and reliability.
• Create and maintain logical and physical data models to ensure efficient data storage, retrieval, and integration across systems.
• Collaborate with development teams to implement data strategies, data flows, and conceptual models.
• Ensure data quality and integrity by establishing and maintaining data governance standards.
• Analyze complex data to develop business intelligence solutions and integration designs.
• Translate business requirements into technical designs and implement them effectively.
• Convert data models and design specifications into functional code, including complex SQL queries, stored procedures, and automation scripts using SQL, JavaScript, and/or Python.
• Monitor, troubleshoot, and enhance system performance, integrating new features as needed.
• Follow best practices and company guidelines for programming, documentation, and data integration.
• Develop and document data audit, archiving, and restoration processes.
• Review and refine integration development efforts to ensure consistency and adherence to best practices.
• Leverage Python and APIs to automate data workflows and improve data processing efficiency.
• Apply prompt engineering techniques to enhance NLP-driven data querying and insights.
• Provide ongoing support, responding to system issues promptly.

Qualifications

• Bachelor's or Master's degree in IT, Computer Science, or equivalent experience.
• 4+ years of experience in data integration or similar roles.
• 3+ years of hands-on experience with ETL and data integration processes.
• 2+ years of experience in data modeling, both physical and relational.
• Advanced proficiency in Snowflake, including its advanced features and utilities.
• In-depth understanding of data structures, database systems, and data mining techniques.
• Proficiency in Python is highly desirable.
• Experience with prompt engineering for natural language processing (NLP) applications is a plus.