Azure Data Architect, Information Technology

Other Jobs To Apply

No other job posts for this day.

Overview: 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

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...