Mercer Advisors is looking to manage their Azure-based data warehouse, develop and maintain data pipelines, and implement a robust, scalable, and optimized end-state target data model to support analytics, reporting, and business intelligence needs.
Requirements
- Hands-on experience in Azure Data Platform (Azure SQL Database, Azure Data Factory, Synapse Analytics, etc.).
- Python for data pipelines and transformation.
- Data modeling, schema design, and optimization.
- Understanding how data is consumed in Power BI and optimizing data models for reporting.
- Strong SQL expertise for querying and performance tuning.
- Familiarity with version control systems (e.g., Git).
- Knowledge of cloud-native architectures and best practices.
Responsibilities
- Oversee and maintain the Azure-based data warehouse, ensuring high availability, performance, and security.
- Design, build, and maintain data pipelines using Python, Azure Data Factory, or other Azure-native tools.
- Develop and implement the end-state target data model to support analytics, reporting, and business intelligence needs.
- Collaborate with analysts to understand how data is consumed in Power BI and design solutions that meet reporting and visualization needs.
- Partner with data analysts, scientists, and business teams to understand requirements and deliver data solutions.
- Identify opportunities to improve data architecture, pipelines, and processes.
- Stay updated on emerging data engineering trends and Azure capabilities.
Other
- Bachelor’s degree in computer science, Engineering, or a related field (Master’s preferred).
- 1-2 years in data engineering.
- Experience in the financial services industry or familiarity with investment management concepts (preferred).
- Must be able to work in a team environment and collaborate with stakeholders.
- Must have excellent communication and problem-solving skills.
