Data Developer

Why Deephaven Mortgage? Deephaven was founded in 2012 to provide mortgages to the millions of Americans who, for one reason or another, are unable to qualify for a traditional, government-backed loan. Deephaven champions those mortgage borrowers whose independence, entrepreneurial drive and determination are often the very reason why they can’t qualify for a traditional loan. Using ingenuity, supported by common-sense underwriting, we continuously and responsibly innovate new mortgage products and programs that put homeownership within reach of millions of borrowers and investors that need and deserve financing. We offer our loans through a network of 1,000+ independent mortgage brokers. We also buy loans from more than 200+ correspondent partners. Deephaven is headquartered in Charlotte, North Carolina and is owned by Pretium, a highly specialized investment manager focused on real estate, mortgage finance and corporate debt. Job Overview The Data Developer is responsible for supporting the business areas in developing business intelligence solutions by leveraging the Microsoft Technology Platform (SQL Server, SSIS, Power BI). They are responsible for developing data products and solutions for the organization including the design, development, testing, and implementation of databases, data sets, integration pipelines, Business Intelligence, and analytics solutions. Additionally, the role implements configuration and support of data solutions. What You’ll Do Design, build, install, configure, and support data solutions, maintaining security and data privacy. Conduct performance tuning or optimization of data solutions along with testing and support. Collect data utilizing various analytical and reporting tools and setting up and maintaining new studies related to departmental KPIs and metric trending Structure data in a format that permits for a wider range of data analysis without interruption to production servers Develop complex SQL stored procedures/views as required Create variety of complex reports using BI tools such as Power BI or SQL Server Reporting Services, including but not limited to drill down, drill through, tabular, matrix, dashboard, multi parameter reports, etc. Build integration pipelines leveraging data from heterogeneous sources including but not limited to flat files, Excel documents, varying RDBMSs, REST APIs and low/no code toolsets Develop and support business process automation using SQL, custom code & vendor toolsets Provide advice and guidance on database good practices, and input on systems architecture Implement internal controls and processes to reduce reporting inaccuracies and improve efficiency. Ensure adherence to the implementation of effective governance, compliance, and risk management frameworks. Manage issues to mitigate impact and risk by early detection of risk items & active team involvement What We Need All DH employees must be able to work cooperatively as team members Bachelor’s degree 5+ years of Data Engineering and Development 5+ years of experience in Data Warehouse and ETL development. Data Architecture experience preferred. Experience with development and implementation of Data Warehouses, Data Modeling, Data Migrations, and APIs Experience with Power BI and other data analytics software Expert knowledge in SQL Server & SSIS Cloud IaaS working knowledge – AWS or Azure preferred Familiarity with scripting in languages such as Python/JavaScript Exposure to .NET programming, preferably C# Exposure to cloud based integration and development tools such as Skyvia, PowerAutomate, PowerApps, etc. Ability to understand organizational strategy and vision and clearly map out key priorities Ability and willingness to learn quickly Must maintain thorough documentation and show excellent attention to detail Strong ability to task switch effectively and manage multiple priorities Experience with MS Office products (Excel, PowerPoint, Visio, and Word) Ability to effectively communicate verbally and in writing to both business units and development team members Works well in a collaborative environment that is high energy and drives towards goals Communicates effectively orally and in writing. Ability to be adaptable and manage ambiguity from the business units Adhere to all corporate policies You Are Someone Who Strives for accuracy and pays close attention to detail Enjoys building strong relationships with customers and team-members Promotes company values while providing optimal customer service Thrives in a fast-paced environment while embracing change and innovation Our Perks Competitive base salary and performance-based bonuses 401(k) plan with an employer match Health insurance with a generous employer contribution that begin day one of employment Flexible work/life balance with Responsible Time Off Privacy Policy