Note: The job is a remote job and is open to candidates in USA. AmeriSave Mortgage Corporation is one of the top-rated, largest privately-owned online mortgage lenders in the nation, committed to delivering beneficial home lending solutions. They are seeking a highly skilled Senior Data Engineer to design, develop, and maintain an enterprise data warehouse to support advanced analytics and data science activities.
Responsibilities
- Own the control tower for database health across the Azure SQL estate — standing up and maintaining monitoring through database watcher, Azure Monitor metrics and alerts, Query Store, DMVs, and Log Analytics / KQL
- Establish wait-statistics, file-I/O, and resource (DTU/vCore) baselines per workload, defining what "normal" looks like per workload and per time-of-day
- Define and continuously tune Azure Monitor alert rules and action groups (blocking, deadlocks, long-running queries, resource saturation) against those baselines so alarms stay trusted and acted upon — alerting on statistical deviation rather than arbitrary thresholds
- Design, develop, and maintain robust enterprise data warehouse solutions that support data science, artificial intelligence, and business intelligence requirements
- Architect scalable ETL/ELT pipelines to efficiently transform raw data into structured, analytics-ready formats
- Build and manage API integrations, including hands-on API development
- Utilize T-SQL and Azure Data Factory to create, optimize, and manage data integration workflows
- Use Microsoft Fabric notebooks for transformation and orchestration where appropriate, leveraging Lakehouse and Warehouse for supplemental storage
- Ensure high data quality, integrity, and performance through meticulous query tuning and process optimization
- Collaborate with data scientists, software developers, business intelligence teams, and stakeholders to develop and deploy data solutions that meet business needs
- Translate business requirements into technical solutions and coordinate smoothly between engineering and other teams
- Lead the creation of scalable, reliable data models and optimize them for performance and usability
- Drive continuous improvement in data engineering processes and practices to keep them efficient and aligned with industry best practices
- Monitor system performance and proactively implement improvements to maximize efficiency and scalability
- Troubleshoot and resolve data-related issues to ensure reliable data delivery
Skills
- 5+ years of hands-on experience in data warehousing, data engineering, or a similar role
- Extensive experience with T-SQL, including advanced query development and performance tuning
- 5+ years as a SQL Server / Azure SQL DBA — performance tuning, index and statistics management, execution-plan analysis, and proactive capacity planning
- Proficiency with pipeline development and configuration using Azure Data Factory (ADF)
- Working familiarity with Microsoft Fabric (notebooks and pipelines for transformation, Lakehouse, and Warehouse)
- Expertise in Python for data engineering tasks, including data manipulation and workflow management
- Strong understanding of data modeling, data architecture, and best practices in data governance
- Experience handling sensitive/PII data and supporting data quality and governance in a regulated, financial-services environment
- Experience preparing clean, analytics- and ML-ready datasets to support data science and AI workloads
- Excellent problem-solving skills and the ability to work independently as well as collaboratively
- Strong communication skills to effectively liaise with both technical teams and non-technical stakeholders
Benefits
- 401(k)
- Dental insurance
- Disability insurance
- Employee discounts
- Health insurance
- Life insurance
- Paid time off
- 12 paid holidays per year
- Paid training
- Referral program
- Vision insurance
- Bonus
- Referral bonuses
Company Overview
Company H1B Sponsorship