Senior Data Engineer

• Design and develop ETL programs and workflows using Databricks
• Develop technical specifications for data loading rules
• Mentor and provide technical guidance to Software Engineers
• Design, implement, and architect software products
• Design, implement, and architect product extensions for customer-specific requirements
• Produce technical specifications, architectural specifications, data models, installation and qualification guides, and release notes
• Support technical consulting activities for pharmaceutical-industry clients
• Design and support clinical trial information-sharing solutions
• Provide application support for existing products
• Support release management using versioning tools such as Azure DevOps Git
• Execute live deployments
• Collaborate with cross-functional teams from design through live deployment
• Contribute to data integration, software product development, and clinical trial information sharing

• Bachelor's Degree in a technical discipline (Mathematics, Science, Engineering, Computing, etc.) or a related study, or equivalent project-related experience
• Proven relevant experience in systems integration and implementation, software development, or a related discipline
• Demonstrated ability to liaise with multiple stakeholders
• 5+ years of experience with Microsoft Azure components, particularly Azure SQL, Azure Databricks, and Azure Data Factory
• Experience implementing ETL solutions, particularly using Databricks
• Strong database development skills, particularly SQL solutions in Azure SQL or Databricks environments
• Experience working with large datasets
• Experience improving data quality in data warehouses
• Experience testing ETL solutions using Genie and MS Copilot
• Experience using enterprise architecture modeling tools, frameworks, and methodologies such as TOGAF, SPARX EA, UML, BPMN, and ArchiMate
• Experience designing data warehouses using Kimball's dimensional modeling techniques
• Experience architecting ETL systems
• Experience working in Agile development methodology
• Experience authoring technical documents and specifications
• Experience debugging complex software systems
• Significant experience implementing data-driven systems with large-scale relational or object-oriented databases
• Ability to work in a high-pressure, results- and deadline-oriented environment
• Understanding of common system architecture frameworks and concepts
• Technical awareness of security and application software development
• Comfort working with Microsoft Azure, Azure Databricks, and Azure DevOps Git
• Excellent interpersonal, verbal, and written communication skills
• Willingness to work in a matrix environment and appreciation for teamwork

• Flexibility
• Growth opportunities
• Continuous learning opportunities
• Career path exploration and skill expansion
• Team-oriented work environment