Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust.
Job Summary:
Mercer Advisors is a leading financial services firm dedicated to simplifying and amplifying the financial lives of families across the U.S. They are seeking a Data Engineer to manage their Azure-based data warehouse, develop data pipelines, and implement robust data models to support analytics and reporting needs.
Responsibilities:
• Oversee and maintain the Azure-based data warehouse, ensuring high availability, performance, and security.
• Monitor and optimize data storage, retrieval, and processing within the platform.
• Design, build, and maintain data pipelines using Python, Azure Data Factory, or other Azure-native tools.
• Ensure ETL/ELT processes are efficient, reliable, and scalable.
• Troubleshoot and resolve data ingestion, transformation, and delivery issues.
• Develop and implement the end-state target data model to support analytics, reporting, and business intelligence needs.
• Work with stakeholders to align data models with business requirements and ensure data accuracy and integrity.
• Collaborate with analysts to understand how data is consumed in Power BI and design solutions that meet reporting and visualization needs.
• Ensure data models are optimized for seamless integration with Power BI dashboards and reports.
• Partner with data analysts, scientists, and business teams to understand requirements and deliver data solutions.
• Provide technical expertise and support for data-related projects and initiatives.
• Identify opportunities to improve data architecture, pipelines, and processes.
• Stay updated on emerging data engineering trends and Azure capabilities.
Qualifications:
Required:
• Bachelor’s degree in computer science, Engineering, or a related field (Master’s preferred).
• 1-2 years in data engineering, with hands-on experience in Azure Data Platform (Azure SQL Database, Azure Data Factory, Synapse Analytics, etc.).
• 1-2 years in data engineering, with hands-on experience in Python for data pipelines and transformation.
• 1-2 years in data engineering, with hands-on experience in data modeling, schema design, and optimization.
• 1-2 years in data engineering, with hands-on experience in 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.
Preferred:
• Experience in the financial services industry or familiarity with investment management concepts.
• Proficiency with CI/CD pipelines and DevOps practices in Azure.
• Exposure to machine learning pipelines and advanced analytics tools.
• Knowledge of data governance, security, and compliance standards.
Company:
Mercer Advisors is a full-service wealth management firm. Founded in 1985, headquartered in Denver, Colorado, USA, team size 501-1000 employees, currently Late Stage. Mercer Advisors has a track record of offering H1B sponsorships.
