Sr Data Engineer – Business Intelligence
| Company | Newrez |
|---|---|
| Location | Houston, TX, USA |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Senior |
Requirements
- College or university degree in the field of Information Technology, Data Science, Computer Science, MIS, or another STEM-related field required. Significant experience in a similar role or industry will be considered as a replacement.
- 5-7 years engineering/development experience
- Expertise in SQL Server 2017 or higher
- Expertise with data and analytics technologies such as RDBMS, ETL and BI
- Experience with SQL Server Integration Services (SSIS)
- Experience with SQL Server Reporting Services (SSRS)
- Experience with Microsoft Visual Studio 2017 or higher
- Experience with on prem and cloud solution design and engineering
- Experience with Snowflake, Azure, AWS, or other cloud technologies
- Experience with agile delivery methodologies
Responsibilities
- Serve as a key contributor to identify, evaluate, and execute the development and implementation of data infrastructure.
- Deliver collaborative products that align with organization and decision strategies.
- Consult with technology and business staff to understand business need and provide thought leadership on solutions during requirements gathering sessions.
- Serve as key contributor in the development and maintenance of the data warehouse.
- Support critical strategic initiatives and architect moderately complex data engineering projects.
- Design and develop scalable, efficient data pipeline processes to handle data ingestion, cleansing, transformation, integration, and validation required to provide access to curated data sets to data analysts and data scientists.
- Develop, communicate, and present solution architectures to both technology and business stakeholders.
- Develop highly complex SQL queries to extract data for analysis and model construction.
- Design, build, and maintain internal and external data integrations.
- Build robust data pipelines, optimizing workloads across on prem and cloud environments.
- Test and validate data pipelines, transformations, datasets, reports, and dashboards built by team.
- Document and test data processes including performance of through data validation and verification.
- Contribute to delivery of multiple large, complex data engineering projects simultaneously.
- Collaborate with technology management to define standards and best practices for team.
- Mentor and assist other data engineers, data analytics and data scientists.
- Provide support to other data engineering, data analytics, application development, data systems and production support teams.
- Work on other projects as assigned.
- Performs related duties as assigned by supervisor.
Preferred Qualifications
- Cloud-based solution design and engineering
- Experience with tools such as HVR/Fivetran and Snaplogic are a plus
- Azure data and analytics deployments
- Experience in solution design spanning multiple frameworks
- Experience in other languages such as Python, R, Spark SQL, Java, etc. are a plus
- Experience with Azure DevOps, TFS
- Familiarity with API-first architectures
- Real time streaming data delivery
- DevOps and CI/CD experience
- Mortgage servicing, mortgage lending and/or finance experience