Key Responsibilities
Database Migration Support
- Support end-to-end database migration activities, including data validation, transformation, and reconciliation.
- Assist in migrating data sources that underpin large-scale visualization dashboards.
- Identify and resolve data integrity, performance, and compatibility issues arising from migration.
Data Engineering & Platform Management
- Develop and maintain SQL and Python-based data pipelines using Databricks and Jupyter Notebooks.
- Create and manage Databricks compute clusters and SQL Warehouses; and configure Unity Catalog for data governance and access control.
- Optimize queries and data models to ensure performance and scalability post-migration.
BI & Dashboard Enablement
- Reconfigure, test, and validate Tableau dashboards impacted by database changes.
- Partner with dashboard owners to ensure data accuracy, performance, and functional parity after migration.
- Support ad-hoc analysis and troubleshooting related to Tableau and SpotFire dashboards.
Collaboration & Documentation
- Work closely with Data Analysts, Business Stakeholders, and IT teams within ASM.
- Document migration steps, data mappings, and known issues to support knowledge transfer and audit readiness.
- Follow ASM data governance, security, and compliance standards.
- Collaborate with global network/database team to identify, engineer and key data elements in-line with existing needs.
Required Skills & Qualifications
Technical Skills (Mandatory)
- Tableau certification (required; active or recently obtained).
- Strong proficiency in SQL / MySQL for querying, transformation, and validation.
- Hands-on experience with Python for data processing and automation.
- Experience using Databricks, including: Creating and managing compute clusters and SQL Warehouses.
- Working with Unity Catalog
- Experience working with Jupyter Notebooks.
Technical Skills (Nice-to-Have / Highly Favored)
- Experience with SpotFire (dashboard development or support).
- Prior involvement in database or platform migration projects.
- Familiarity with manufacturing, biotech, or regulated environments.