We are a global team of creators, storytellers, technologists, experience originators, innovators and so much more. We believe amazing games and experiences start with teams as diverse as the players and communities we serve. At Electronic Arts, the only limit is your imagination.
Player Insight Network (PIN) is the central telemetry solution that helps EA to make great games across all platforms and titles. We, Player Insight Network Quality Verification Team, are looking for a data engineer responsible for Extract Transform Load (ETL) logic validation through the use of test automation and dbt. You will work with our partners to ensure quality data in player engagement and gameplay telemetry from source to dashboard reporting. Besides applying best software engineering practice in data engineering space, SQL and scripting language, you will work with an amazing team of data craft practitioners in driving high quality in our data product portfolios.
You will be responsible for planning, building and deploying data quality solutions for EA. The Data Engineer will be a subject matter expert in building data quality solutions using modern ETL technologies. You will leverage tools & technologies to store, analyse petabytes of data and solve complex business problems. You will collaborate with product, business and engineering teams to build & deliver the most optimal solution.
You will report to the Data Engineer of the team. This position is open to remote work from Canada.
Responsibilities
Create test plans by reviewing data pipeline feature design spec
Create test cases using DBT to validate ELT pipelines quality
Create test cases using SQL & python in internal test case automation framework to ensure data quality
Work with data analytics solution team to understand data requirements, Entity Relationship Diagram (ERD) and implementation of ETL logic
Design test strategy to validate end-to-end data quality based on data requirements and needs
Perform root cause analysis on failed test cases and communicate those with partners
Understand the design and architecture of data pipelines and come up with test solutions
Identify and communicate test coverage gaps on raw data to the partners
Define data quality KPIs & metrics to provide executive summary
Analyze and improve test coverage based on feedback provided by downstream partners
Identify creative methods to increase data pipelines testing efficiency
Work with the product, business and engineering teams to Identify new opportunities for data acquisition
Build analytical tools and programs to empower the business teams make decisions based on data
Qualifications
Excellent command over querying and analysing data using multiple query languages native to the storage system (e.g., SQL CQL, MQL, Hive, etc.)
Good understanding of SQL and NoSQL database concepts & applications, data modelling techniques (3NF, Dimensional), data pipelines orchestration
Experience tuning databases and queries for optimal performance
Experience in ETL logic implementation and data transformation - dbt, Python, R
Experience ingesting data from various sources in formats such as JSON, XML, CSV.
Experience in data visualisation tools such as Tableau, Power BI.
Experience working using Agile methodologies. Prior experience in using tools such as Gitlab, JIRA, Confluence, etc.
Ability to debug and test complex data pipelines
Experience identifying data quality rules and applying data validation techniques
Good understanding of data lifecycle & quality applications
Good understanding of software quality assurance concepts, debugging practices
3+ years relevant industry experience in data engineering role who has Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field
About Electronic Arts
Everything we do is designed to inspire the world to play. Through our cutting-edge games, innovative services, and powerful technologies, we bring worlds with infinite possibilities to millions of players and fans around the globe.
We’re looking for collaborative and inclusive people with diverse perspectives who will enrich our culture and challenge us. We take a holistic approach with our benefits program, focusing on physical, emotional, financial, career, and community wellness to support our people through every chapter of life. Our goal is to provide a safe and respectful workplace that empowers you to thrive in both work and life.
Electronic Arts is an equal opportunity employer. All employment decisions are made without regard to race, color, national origin, ancestry, sex, gender, gender identity or expression, sexual orientation, age, genetic information, religion, disability, medical condition, pregnancy, marital status, family status, veteran status, or any other characteristic protected by law. We will also consider employment qualified applicants with criminal records in accordance with applicable law. EA also makes workplace accommodations for qualified individuals with disabilities as required by applicable law.