Senior Data Platform Engineer

EMC Insurance Companies is committed to working together to make an impact. They are seeking a Senior Data Platform Engineer to guide the Data Platform Engineers on complex projects, ensuring the operationalization of production data environments and delivery of data services.

Responsibilities:

• Guides the Data Platform Engineers on highly complex projects related to fully operationalizing EMC's production data environments including alerting and monitoring, continuous integration/delivery/deployment (CI/CD) processes, data lifecycle and change management
• Tracks, reviews work in progress and completed assignments for projects within areas of expertise and follows up with team to ensure solutions created meet stakeholder needs and deadline for all technical delivery of project work per quarterly goals
• Guides team during planning in selecting tasks needed to deliver data services based on priorities set by stakeholders and team roadmap
• Leads planning and execution of strategic initiatives as requested by stakeholders and defined in DPO roadmap
• Ensures delivery of assigned projects required for completion of DPO team enablement initiatives
• Collaborates with Data Analytics Architecture Director to define and implement shared services solutions to support Data Analytics Product (DAP) teams. Performs work and guides DPO team members in the following areas:
• Operational Data Management – creates and maintains a central repository for logs to create metrics, observability, and incident root cause identification
• Data Lake – leads the storage of data product files, enabling access as appropriate
• Analytics Sandbox – provides guidelines for access, use, and data retention, monitors growth and organization of assets. Collaborates with Actuary, Data Science, and other teams for effective use of the sandbox
• Cost of Ownership – creates automated methods for gathering information necessary for producing metrics to analyze costs per data technology, development team, and/or business process
• Creates and documents guidelines and procedures used by the DPO team members in the following areas:
• Data Access and Security – administers functional and resource roles, data discovery/classification and loss prevention
• Data Lifecycle and Change Management – leads development of data retention policies, archival and purge processes, change management for reference data, data models, and metadata
• Data Governance and Quality - supports corporate governance strategy, data profiling and score cards
• Data Masking - masks data when required to reduce the risk of exposing sensitive data in queries or reports
• Data Operations initiatives - focuses on efforts to shorten the systems development life cycle and provide continuous delivery, including statistical process controls, embedded data quality and governance, platform instrumentation, and enhanced self-service capabilities
• Ensures proper implementation, education, and adherence to current guidelines and procedures
• Collaborates with Cloud Engineering, Data Engineering, Data Governance Office, DevOps, Information Security, Infrastructure, and Integrations in the creation of policies, procedures, and use cases to provide solution enablement for data services consumers
• Leads the installation, administration, and documentation of tools to support highly complex, enterprise-level data systems on various cloud-based and on-premise platforms
• Monitors system metrics to ensure optimal performance and utilization of the systems. Provides 24x7 support for critical systems as an escalation contact during assigned on-call rotation
• Evaluates the effectiveness of existing internal processes and applications and proposes solutions and opportunities for automation and audit controls
• Develops, implements, and documents policies and procedures to ensure availability and business recovery of data systems
• Leads team members efforts to identify and implement efficiency improvements on consumption-based platforms to contain costs
• Leads complex projects to migrate legacy/on-premise data solutions to the cloud
• Participates in onboarding new team members and training team members
• Maintains inventory lists of all database and software installations and provides recommendations to manager for license renewals
• Partners with vendors on proof of concept used to determine best fit during vendor evaluation process

Requirements:

• Bachelor's degree, preferably in computer science or equivalent relevant experience
• Eight years of data management administration experience or related experience
• Experience executing data migrations from on-premise to cloud environments
• Thorough knowledge of current relational databases such as SQL or PostgreSQL
• Advanced analytical skills related to database performance monitoring and troubleshooting
• Strong knowledge of applicable scripting languages such as Bash, PowerShell, and Python
• Thorough knowledge of Collibra, Informatica, Power BI, or Snowflake
• Thorough knowledge of AWS cloud data services
• Familiarity with administering data science platforms
• Familiarity with administering data virtualization tools
• Ability to work as part of a team and work collaboratively across departments and within all levels of the organization
• Excellent verbal and written communication skills, including documentation
• Excellent attention to detail, organizational and multi-tasking skills with the ability to adapt to changing priorities
• Ability to work on a monthly on-call rotation
• Ability to maintain confidentiality