POSITION SUMMARY:
The Data Science and Analytics (DSA) team is a technical engine underpinning many of the company's key strategic functions. We are a passionate, human-centered org with diverse science/analytical skillsets working in concert.
DSA is seeking a Manager of SQL Development for Onity's Data Science and Analytics team. Success in this role is about producing a high volume of report/query/visualization outputs (like an assembly line: hands-on work all day long). Required skills are SQL (being a fast programmerwe'll test this as wellthink window functions, nested queries, stored procedures), PowerBI (complex visualizations), Excel (with VBA), a hunger for business knowledge, ability to communicate in business terms, and a passion for automating technical workflows. Nice-to-have skills are experience in Mortgages, experience in SAS, experience in Python, consultancy experience, Data Science experience.
JOB FUNCTIONS AND RESPONSIBILITIES
- Design, build, and maintain highvolume BI reporting assets including SQL queries, stored procedures, Power BI datasets, dashboards, and operational reports supporting servicing and originations workflows.
- Operate as a highly handson individual contributor, producing a steady throughput of reports, analyses, and visualizations in response to business demand.
- Develop complex SQL logic (window functions, nested queries, performanceoptimized joins) to support pipeline tracking, status monitoring, exception reporting, and adhoc deep dives.
- Build and enhance Power BI dashboards with complex measures, calculated tables, and visuals that translate operational data into clear business insights.
- Automate recurring reporting, data preparation, and quality checks using SQL, Power BI, and Excel/VBA to reduce manual effort and improve reliability.
- Partner closely with business stakeholders to understand requirements, clarify definitions, and translate business questions into precise analytical outputs.
- Support strategic analysis and opportunity mining by rapidly iterating on queries and reports as business questions evolve.
- Maintain documentation, data definitions, and reusable query/report patterns to improve consistency and scalability.
- Ensure accuracy, performance, and consistency of reporting outputs in alignment with data governance and audit expectations.
- Contribute to continuous improvement of BI engineering standards, tooling, and workflow automation within the Data Science & Analytics organization.
EDUCATION / EXPERIENCE
- Minimum education required: Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, Economics, or a related quantitative field.
- Preferred education: Master's degree in a quantitative or analyticsfocused discipline.
- Minimum years of experience required: 34 years in business intelligence, analytics engineering, or reportingfocused data roles.
- Specific skills or abilities needed:
- Strong proficiency in SQL, including complex joins, window functions, subqueries, and performance optimization.
- Handson experience building and maintaining Power BI dashboards, datasets, and semantic models.
- Advanced Excel skills, including formulas and VBA for automation.
- Demonstrated ability to work at high output and manage multiple reporting and analysis requests concurrently.
- Strong business acumen and ability to communicate analytical findings in clear, nontechnical terms.
- Experience translating loosely defined business questions into precise analytical deliverables.
- Interest in automating data and reporting workflows to improve efficiency and scalability.
- Experience in mortgage, financial services, or highly regulated data environments is a plus.
- Familiarity with SAS or other legacy analytics platforms is a plus.
