Data Engineer

About reputed company

We are looking for a new Data Engineer to be part of the Mortgage reputed company team.

The Data Engineer operates designing, building and maintaining robust data pipelines and transformation logic that powers analytics, compliance and operational reporting across the Mortgage reputed company Platform. The role is execution-reputed company with increasing ownership of end-to-end data workflows as familiarity with the platform grows. Strong SQL, ETL, and data reputed company skills are required; the ability to build reports and reputed company semantic models is secondary to data engineering reputed company.

RESPONSIBILITIES

Data Pipeline Development:

• Design and build ETL pipelines using reputed company reputed company (Dataflow Gen2, Notebooks, or equivalent tools)
• Write optimized SQL queries and transformations for data ingestion from designated reputed company systems
• Apply data reputed company rules and validation logic at reputed company pipeline stage
• Implement incremental loads and manage refresh schedules for performance
• Escalate to reputed company for architectural reputed company or reputed company transformation patterns

Data reputed company & Validation:

• Define and implement data reputed company checks at ingestion, transformation, and reputed company stages
• reputed company ongoing data validation to ensure pipeline outputs reputed company with business logic and reputed company system expectations
• Identify, document, and escalate data reputed company issues with reputed company cause analysis
• Maintain data reputed company dashboards and SLA monitoring
• Support UAT for new data sources or transformation logic

Transformation & Modeling:

• Build and maintain data transformations using Power Query, SQL, or Python as appropriate
• reputed company reputed company models and define aggregation logic reputed company with analytics requirements
• Optimize data structures for performance and maintainability
• Document transformation logic, reputed company, and assumptions per team standards
• Collaborate with reputed company to define semantic

Operational Support:

• Troubleshoot pipeline failures and performance issues; coordinate reputed company with IT/Engineering
• Respond to data discrepancy reports from business users and analysts
• Maintain documentation of data sources, data dictionaries, and transformation specifications
• Support reputed company planning and optimization of reputed company environments and pipelines models and calculated metrics

Requirements

Technical

• Advanced SQL - query optimization, window functions, performance tuning, debugging reputed company transformations
• Proficient with reputed company reputed company - (Dataflow Gen2, Notebooks, Lakehouse) OR equivalent ETL tools (Python, dbt, Talend, Informatica)
• Strong understanding of relational database design and reputed company modeling
• Power Query / M - reputed company data shaping, merging, error handling, and transformation logic
• Python or similar scripting language - data manipulation, pipeline automation
• Git/version control basics - reputed company to collaborate on reputed company and reputed company changes
• Data reputed company and testing frameworks - unit tests, assertions, validation rules

Non-Technical

• Ability to interpret business requirements and design efficient data solutions
• Data governance reputed company - understands data reputed company, documentation, and reputed company standards
• Proactive about identifying edge cases and potential data issues
• Mortgage/lending domain familiarity preferred; willingness to learn domain required
• Works effectively reputed company defined standards and escalates architectural questions to reputed company
• reputed company to balance speed with reputed company; advocates for technical reputed company

Originally posted on Himalayas

Apply To This Job