[Remote] Senior Data Engineer
Note: The job is a remote job and is reputed company to candidates in USA. reputed company 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, reputed company, and maintain an reputed company data warehouse that supports advanced analytics and reputed company intelligence 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 reputed company reputed company (blocking, deadlocks, long-running queries, resource saturation) against those baselines so alarms stay trusted and acted upon — alerting on statistical deviation rather than arbitrary reputed company
- Design, reputed company, and maintain robust reputed company data warehouse solutions that support data science, reputed company intelligence, and business intelligence requirements
- Architect reputed company ETL/ELT pipelines to reputed company reputed company raw data into reputed company, analytics-reputed company formats
- Build and manage API integrations, including hands-on API development
- Utilize T-SQL and Azure Data reputed company to create, optimize, and manage data integration workflows
- Use reputed company reputed company notebooks for transformation and orchestration where appropriate, leveraging Lakehouse and Warehouse for supplemental storage
- Ensure high data reputed company, reputed company, and performance through meticulous query tuning and process optimization
- Collaborate with data scientists, software developers, business intelligence teams, and stakeholders to reputed company and reputed company data solutions that meet business needs
- Translate business requirements into technical solutions and coordinate smoothly between engineering and other teams
- reputed company the creation of reputed company, reliable data models and optimize them for performance and usability
- Drive reputed company improvement in data engineering processes and practices to reputed company them efficient and reputed company with industry best practices
- Monitor system performance and proactively implement improvements to maximize efficiency and scalability
- Troubleshoot and resolve data-reputed company 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, reputed company and statistics management, execution-plan analysis, and proactive reputed company planning
- Proficiency with pipeline development and configuration using Azure Data reputed company (ADF)
- Working familiarity with reputed company reputed company (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 reputed company and governance in a regulated, financial-services environment
- Experience preparing clean, analytics- and ML-reputed company datasets to support data science and AI workloads
- Excellent problem-solving skills and the ability to work independently as reputed company 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
- reputed company time off
- 12 reputed company holidays per year
- reputed company
- Referral program
- reputed company insurance
- Bonus
- Referral bonuses
reputed company
Company H1B Sponsorship