Deephaven Mortgage needs to support the business through business intelligence solutions leveraging the MS BI Platform (SQL Server, SSRS, 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, business intelligence, and analytics solutions.
Requirements
- Minimum 5 years of experience in data warehouse and ETL development, including dimensional modeling (Kimball methodology)
- Proven expertise with the SQL Server platform, including T-SQL, SSRS, SSIS, and SSAS
- Hands-on experience with Power BI and other modern data analytics/visualization tools
- Strong working knowledge of cloud Infrastructure-as-a-Service (IaaS) platforms; AWS or Azure preferred
- Familiarity with at least one general-purpose programming language such as Python or C
- Ability to work a hybrid schedule in office in the Ballantyne are of Charlotte, NC
Responsibilities
- Design, build, install, configure, and support data solutions, maintaining security and data privacy
- Conduct performance turning 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 KPI’s, and specific departmental trending
- Use analytical tools to create statistical models for various business needs
- Normalize and de-normalize data into a format that permits a wider range of analysis without interruption to production server performance
- Develop complex SQL stored procedures, views, functions and queries
- Create a 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 parameters reports, etc.
Other
- This role is hybrid in office 2+ days a week in the Ballantyne are of Charlotte, NC
- Bachelor’s degree in Computer Science, Information Systems, or related field; or 5+ years of equivalent Data Engineering and Development experience
- Demonstrated ability to align data solutions with organizational strategy and translate business vision into actionable priorities
- Strong written and verbal communication skills, with the ability to convey complex technical concepts clearly
- Thrives in high-energy, collaborative team environments focused on delivering results
