[Remote] Data Engineer
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking a Data Engineer to design, build, and maintain robust data pipelines for the Mortgage reputed company Platform. This role focuses on executing end-to-end data workflows and requires strong SQL, ETL, and data reputed company skills.
Responsibilities
- Design and build extraction, transformation, and loading (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
- 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
- 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
- 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
- Collaborate with reputed company to define semantic models and calculated metrics
Skills
- Strong SQL, ETL, and data reputed company skills
- Design and build extraction, transformation, and loading (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
- 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
- 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
- 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
- Collaborate with reputed company to define semantic models and calculated metrics
- 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
- 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
- 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
- Mortgage/lending domain familiarity preferred; willingness to learn domain required
reputed company