Data Engineer

E-Solutions Group - Phoenix, AZ

Full-time - Mid Level

Phoenix, AZ

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

The Data Engineer role involves overseeing all technical aspects of databases that support the global work application. The position requires a deep understanding of database architectures and hands-on experience with database technologies. The successful candidate will ensure optimal database performance, security, resiliency, integrity, and availability, while implementing innovative solutions such as the Point of Arrival (POA) system for the data layer.

Responsibilities

• Leads and mentors teams of engineers through ongoing development efforts.
• Ensures engineers adhere to team standards.
• Accountable for accurate completion and quality of all documentation and work produced by the engineering team.
• Accountable for delivering a quality product that meets customer needs.
• Performs all technical aspects of data architecture and database management for assigned applications, including developing prototypes and new database structures and APIs as applicable.
• Transforms logical data architectures into physical data designs according to database design best practices and standards.
• Provides database administration services to projects, crafting, extending, or maintaining databases, data warehouses, and datamarts.
• Debugs database components, identifies fixes, and verifies remediation of design and/or performance defects.
• Performs ongoing refactoring of database design and continuously improves product to follow data placement procedures and reuse existing databases as appropriate.
• Ensures optimal data replication performance, high availability, backup, and recovery processes exist to meet requirements, reduce cost, and adhere to standards.
• Leads in the development of plans and strategies, best practices, and standards related to data management processes, data products, data security, and programs.
• Functions as a senior member of an agile team and leads data assets as per the enterprise standards, guidelines, and policies.
• Typically spends 50% of time in database development and testing and the remainder collaborating with partners through ongoing product/platform releases.
• Communicates and works collaboratively with business and product teams to support changes and implementation.
• Works with the product team to prioritize features for ongoing sprints and leads a list of data requirements based on industry trends, new technologies, known defects, and issues.
• Partners with delivery architects and engineers to design optimal data tier solutions to meet enterprise platform objectives and goals.
• Stays abreast of new DBMS features and functions and drives adoption across clients to use product capabilities.
• Active member of the vendor product development strategy that enables vendors to provide solutions and features to meet client needs.
• Contributes to decisions about tools, methods, and approaches.
• Finds opportunities to embrace innovative technologies.
• Works closely with product owners on blueprints and annual planning of feature sets that impact multiple platforms and products.

Requirements

• Strong analytical skills with a proven ability to understand and document business data requirements in complete, accurate, extensible, and flexible logical data models using data modeling tools.
• Ability to facilitate discussions between technology and business people, recognize issues of conflict and inconsistency between data requirements, and pursue resolution of these issues.
• Evaluates and undertakes impact analysis on major design options for databases and assesses and leads associated risks.
• Expert in XML and schema development/reuse, RDBMS databases, and open source. Expertise in NoSQL is an added advantage.

Nice-to-haves

• Experience with data modeling tools and SQL DB modeling.
• Familiarity with agile methodologies.