Job Description

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