Senior Business Intelligence Developer (Database Architect & ETL Developer)

Company Description

We’re over 2,500 strong across the globe. We’re scientists, strategists, creatives, and innovators. We value individual brilliance and build a strong foundation for Teamwork across all our business. We love the challenge of our industry. We’re changing lives and redefining success every step of the way.

You are dynamic. You are curious. You are more than your job. For you, excellence isn’t just a word; it’s the measure for all you do. You’re passionate. Driven. Dedicated. You can’t stand mediocrity. And you might be the team member we're looking for. 

Job Description

PSI CRO is looking for a hands-on, experienced Database Architect & ETL Developer who is a visionary, self-directed and comfortable supporting the various data & analytics needs of multiple teams, systems, and products. In this role, the Database Architect/ETL Developer will be responsible for requirements, analyzing, designing, coding & testing various databases & ETL processes required by the Data Platform team to build world class data lakes, databases, and data repositories utilizing both Microsoft SQL Servers as well as cutting-edge Azure cloud data technologies.

Requirements:

• Demonstrated ability to have successfully completed multiple, complex technical projects and create high-level design and architecture of the solution, including class, sequence, and deployment infrastructure diagrams.
• Develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences.
• Ensure new features and subject areas are modelled to integrate with existing structures and provide a consistent view.
• Provide input on Azure technologies and industry best practices in the field of data warehouse architecture and modelling.
• Take ownership or assistance of technical solutions from design and architecture perspective for projects from conceptual phase through architecture, feasibility, design, and implementation
• Maintain, monitor, upgrade and secure the SQL Server/Azure platform in partnership with established vendor.
• Develop ETL (extract, transform and load) processes to populate Data Marts and Warehouses
• Develop systems integrations across between traditional databases and modern Cloud APIs.
• Follow established Software Development Lifecycle (SDLC) activities and AGILE including Analysis, Design, Development, UAT, Pilot, Testing & lessons learned.
• Design, model and develop across both Relational Databases and Data Warehouse and Synapse
• Troubleshoot data integrations/data feeds between systems.

Qualifications

• 5+ Years’ Experience in SQL Server Database Management
• 5+ Years’ Experience in SQL Server Database Development and SQL scripting (T-SQL)
• Must have experience with at least one end to end implementation of Azure cloud data warehouse
• Expertise in Azure – data modelling, ELT using Azure ADF pipelines, implementing complex stored Procedures and standard DWH and ETL concepts.
• Expertise in Azure advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features.
• Expertise in deploying Azure features such as data sharing, events, and lake-house patterns
• Hands-on experience with Azure utilities, PySpark, ADF, Synapse, Big Data model techniques using Python or similar.
• 3+ years of hands-on experience with on prem and Azure Data warehouse, ETL, BI projects, Azure Synapse.

Additional Information

If you feel it is time to make your skills and knowledge visible within a growing company with true focus on its people, then PSI is the right choice for you.