ServiceLink, the unrivaled leader in the mortgage industry, is seeking a talented and motivated individual to fill the role of Azure Data Architect for its portfolio of internal and customer-facing applications. The ideal candidate will have extensive experience working with both databases and database applications. Experience and/or training in both online transaction processing (OLTP) and data warehousing (DW) databases is desirable. If you thrive on high-level collaboration with enterprising, high performance teams, we encourage you to apply today.
A DAY IN THE LIFE
In this role, you will…
Assume a leadership role in establishing and ensuring compliance with IT governance/data security policies and initiatives including standards, best practices, policies and mentoring of junior staff.
Perform/lead/recommend SQL Performance Tuning, documenting and maintaining best practices, especially focusing on performance and cost optimization of cloud data systems.
Explore new technologies with intrinsic value for applications in database and system architectures, interfacing with external vendors and internal team to identify, evaluate and recommend system hardware and software. Define and lead proof of concept activities associated with technology assessment.
Work with IT and business representatives to determine the future development roadmap in cloud data systems, documenting the desired future state of solution architectures and potential gaps between current and future states. Define transition plans to close the gaps.
Design and configure both relational and transactional databases, in addition to their interfaces.
Engage with and support environment configuration and database migrations. Support the release of new products into production, troubleshooting issues as required.
Define and document full lifecycle requirements for systems and database design to guide product development teams.
Define/configure the optimal Architecture to enable/support consumers executing streaming and advanced analytics.
WHO YOU ARE
You possess …
Full command of cloud-based systems such as Azure (including modules such as Synapse, Fabric, Data Orchestration and Data Factory), AWS, Google Cloud or similar technologies/platforms (vendor supported or open source).
10+ years’ experience in software or applications engineering and/or technical operations.
Experience in Design/Implementation of Big Data Warehouses.
Real-world experience with Azure database technologies
Cloud Architecture certified
Knowledgeable in open source systems such as Apache and MongoDB
Knowledge of Data Flows, Sematic Models (manual, semi-automatic, automatic).
Experience with Microsoft Purview and/or similar data governance tools.
Ability to creatively perform as a problem solver, working and managinf multiple workstreams concurrently. Excellent communication skills and ability to work independently with minimal supervision and direction.
Soft skills and business acumen to work effectively in a fast-paced environment, interfacing with diverse teams and stakeholders and acting as both self-starter and motivator.
Responsibilities:
Define and document requirements for database design (both relational and non-relational) to guide product development teams. Within these requirements, stipulate best practices and the metrics to measure adherence to them, acting as the primary owner and maintainer of new and existing OLTP and DW/BI data models
Define and document test procedures to measure adherence of database performance/reliability to Company standards
Working with development, review and tune SQL queries and updates to ensure optimal performance, defining indexes, profiling performance, troubleshooting, and resolving issues. Work with DBA’s as needed to performance tune Azure SQL databases or Azure Cosmos DB containers
Working with database administrators to ensure deployed data models function as intended
Overseeing extraction, transformation, and loading activities for data warehouse/data marts
Migrate legacy databases which do not follow the ServiceLink schemas or microservices paradigms into cloud solutions
Support the release of new products into production
Support data migrations in all scales and degrees of complexity
Work with development and the larger data/reporting teams to implement and execute data migrations
Troubleshoot and resolve issues with Azure SQL and Cosmos DB in lower and production environments
Document the desired future state of solution architecture and document the gaps between current and future states. Define transition plans to close the gaps.
Explore new technologies with intrinsic value for applications in ServiceLink solutions. Lead activities with external vendors and internal team to identify, evaluate and recommend system hardware and software, sizing for capacity and cost effectiveness. Defines and leads proof of concept activity associated with technology assessment.
Assume a leadership role in establishing and insuring compliance with IT governance policies and initiatives including standards, best practices, and policies, including mentoring and guiding of other resources.
Reverse engineering, understanding, and documenting existing application data models
All other duties as assigned
Qualifications:
10+ years’ experience in software or applications engineering and/or technical operations.
Real-world experience working in Azure Cloud
Experience in the development lifecycle of enterprise database applications
Experience with Azure SQL database is required
Experience with SQL Server or another relational database is desirable
Thorough understanding of relational data modeling
Thorough understanding of database transaction processing
Thorough understanding of data normalization/de-normalization
Thorough understanding of data warehouses and star schemas
Experience with extraction, transformation, and loading (ETL) tools
Experience with reverse engineering of database schemas is desirable
Well-versed in SQL, DDL, DML, and stored procedures (T-SQL)
Familiarity with object relational mapping (ORM) frameworks is desirable
Experience with Azure Cosmos DB is required
Experience with NoSQL (particularly document) databases are highly desirable
Experience and/or certification in database administration is also a plus
About the Company
S
ServiceLink
ServiceLink is the premier national provider of mortgage services. ServiceLink delivers valuation, title and closing, and flood services to mortgage originators; end-to-end subservicing to mortgage servicers; and default valuation, integrated default title services, vendor invoicing and claims audit services as well as auction services to mortgage servicers.
ServiceLink helps clients in the lending industry and beyond achieve their strategic goals, realize greater efficiencies, and better serve their customers by delivering best-in-class technology, services, and insight with a relentless commitment to upholding the highest standards of quality, compliance, and service.
For more information about ServiceLink, please visit https://www.svclnk.com/.