Description:
The strength of our platform lies in working with the right people. Acting with integrity and employing an entrepreneurial mindset, our employees work together to create an exciting, dynamic workplace. By employing an active hands-on approach to asset management, our skilled and innovative team operates closely alongside our investors. We’re disciplined, we focus on value, and we’re informed experts. We pride ourselves on our diverse and inclusive workplace; we are a unique workplace with unique people.
WHAT WILL YOU DO?
- Design, develop, and maintain, the corporate Azure SQL Managed Instance-based data warehouse.
- Create, implement, and enhance data models and define both logical and physical models.
- Develop, maintain, and optimize data pipeline architecture.
- Design, develop, and maintain various Data Marts.
- Ensure full up-to-date documentation is maintained.
- Ensure all information assets are fully tested, documented, and reflect accurate data for timely and optimized reporting of corporate information.
- Foster strong collaborative relationships with IS/IT teams, data science professionals, and business units to identify data quality issues and develop solutions.
- Oversee the administration, maintenance, and support of the data warehouse environment, tools, and jobs.
- Ensure critical process contingency plans are in place for any key processes required to ensure data availability.
- Monitor data warehouse work and provide subject matter expertise.
- Analyze and optimize various data warehouse objects.
- Ensure strict adherence to all applicable privacy regulations.
- Contribute to a dynamic and agile team culture by willingly embracing additional responsibilities.
WHAT WILL YOU NEED?
- Bachelor’s degree in computer software science or a related discipline.
- 3+ years of experience in Azure SQL MI, designing, developing, and scripting database objects.
- Proficiency in using Python for data manipulation, analysis, and automation tasks is essential
- Extensive experience in relational and multi-dimensional data modeling, including multiple source systems from databases and flat files, OLAP, ROLAP.
- Expert experience in data pipeline and data mart development using Azure Data Factory (ADF).
- Extensive experience in development and administration with Azure SQL Database.
- Excellent communication skills, both written and verbal.
- Experience in project management methodologies.
- Works independently as well as in a team-oriented environment.
- Strong analytical skills to solve and model complex business requirements.
- Emphasize client satisfaction and communicate solutions to both technical and non-technical team members and other staff.
- Demonstrated ability for creativity and innovative problem-solving.
- Able to multi-task in a dynamic environment and think clearly and calmly under pressure.
- Ability to work in a fast-paced, dynamic environment that requires flexibility and balancing of competing priorities.
- Ability to deal with situations, people, and problems ethically, with honesty and integrity.