Data Platform Engineer

ETHOS - Talent & Advisory is seeking a Data Platform Engineer to join their Information Systems Team. The role focuses on data engineering, data governance, and Python-driven automation, while also managing database administration responsibilities.

Responsibilities:

• Design and implement data governance policies, procedures, and frameworks across the organization
• Build and maintain a PII classification system to identify, tag, and protect sensitive data
• Develop Python and PySpark automation for data pipelines, operational tooling, and workflow orchestration
• Design and manage the data access layer, including database users, roles, and permissions to ensure proper access controls
• Contribute to system design decisions for a scalable, maintainable data platform
• Integrate and manage data across PostgreSQL, Redshift, API-based sources, and flat files in S3
• Perform core database administration tasks including performance monitoring, query and index tuning, and troubleshooting bottlenecks and capacity constraints
• Implement and maintain data security controls, including encryption, auditing, and compliance measures
• Ensure data integrity and availability through robust backup, recovery, and disaster recovery strategies
• Design and implement logical data models that inform physical design and scalable architecture
• Build usable datasets that expand access to self-service analytics and improve decision-making
• Support reporting and dashboard development for business stakeholders
• Document data governance frameworks, security protocols, and administration procedures
• Write maintainable, testable, efficient code that is clear to engineers unfamiliar with the system

Requirements:

• Bachelor's degree in any field or equivalent experience required
• 5 years of experience in data engineering, database administration, or a related data platform role
• Expert-level Python scripting for automation, data pipelines, and operational tooling; PySpark experience strongly preferred
• Strong system design skills and the ability to architect scalable data solutions
• Hands-on experience with data governance practices (e.g., PII classification, lineage, security, quality)
• Expertise with relational databases (e.g., PostgreSQL, Redshift, MySQL, SQL Server) including schema design, query tuning, and index strategy
• Working knowledge of database security and access controls, including roles/permissions, auditing, and encryption concepts
• Experience managing production database environments for reliability, performance tuning, access control, and security
• Experience partnering with Development/QA/Operations to support deployments, environment health, and incident response
• Strong SQL skills, including complex queries and performance optimization
• Ability to translate business needs into analytical deliverables and communicate findings to technical and non-technical stakeholders
• Experience with AWS data services (Redshift, S3, Glue, Lambda); candidates with equivalent experience on other cloud platforms are encouraged to apply, as PySpark and data engineering skills transfer across platforms
• Experience building or maintaining dashboards and reports (Power BI and/or Tableau); training will be provided for the right candidate
• Experience with backup/recovery concepts and disaster recovery preparedness
• Background in any data-intensive industry; energy sector experience is not required