Azure Data Architect

Location: Pittsburgh

Job Type: Full Time / Permanent

Overview: We are 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.

In this role, you will… • Create and maintain the relational data models for assigned enterprise applications in Azure cloud. • Explore new technologies with intrinsic value for applications in solutions. Lead activities with external vendors and internal team to identify, evaluate and recommend system hardware and software. Defines and leads proof of concept activity associated with technology assessment. • Provide guidance and/or design complete modeling data in NoSQL databases such as Azure Cosmos DB and relational databases such as Azure SQL • 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. • 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 • Perform light DBA duties such as object creation/modification and backup/restore in lower environments. Mentor DBA and junior staff in such tasks as needed • Migrate legacy databases which do not follow the schemas or microservices paradigms into cloud solutions • Support the release of new products into production • Work with IT and business representatives to identify opportunities leading to the design and development of tools and applications in support and business partner operations. • 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 • Full command of Azure Data Orchestration and Azure Data Factory • Knowledgeable about Azure Cognitive Services and Azure MLOps • Knowledgeable about automatic data and pipeline validation tools such as Erwin Data Modeler and Pointblanc • Document the desired future state of solution architecture and document the gaps between current and future states. Define transition plans to close the gaps. • Assume a leadership role in establishing and insuring compliance with IT governance policies and initiatives including standards, best practices, and policies.

You possess … • Bachelor’s degree in Computer Science or related years of experience. • 10+ years’ experience in software or applications engineering and/or technical operations. • Real-world experience with Azure database technologies • Detailed knowledge and real-world experience of Microsoft Cloud products • Works effectively in a fast-paced environment. • Works well in team scenarios and possesses characteristics representative of a self-starter and motivator • Creative and effective problem-solving skills • Ability to work on/manage multiple tasks concurrently • Excellent communication skills • An ability to work independently with minimal supervision and direction • A talent for work prioritization, time management, and multitasking.

Responsibilities: • Create and maintain the relational data models for assigned enterprise applications in Azure cloud. • Explore new technologies with intrinsic value for applications in 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. • 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 • Define and document test procedures to measure adherence of database performance/reliability to Company standards • Provide guidance and/or design complete modeling data in NoSQL databases such as Azure Cosmos DB and relational databases such as Azure SQL • 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 • Perform light DBA duties such as object creation/modification and backup/restore in lower environments and mentor/guide junior staff in such duties • Actively participate of Scrum meetings to ensure adequate interfaces and timely response with areas connected to/dependent upon database design, implementation and maintenance • Migrate legacy databases which do not follow the 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 IT and business representatives to identify opportunities leading to the design and development of tools and applications in support of and business partner operations. • 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 • Full command of Azure Data Orchestration and Azure Data Factory • Knowledgeable about Azure Cognitive Services and Azure MLOps • Knowledgeable about automatic data and pipeline validation tools such as Erwin Data Modeler and Pointblanc • Document the desired future state of solution architecture and document the gaps between current and future states. Define transition plans to close the gaps. • Assume a leadership role in establishing and insuring compliance with IT governance policies and initiatives including standards, best practices, and policies. • Reverse engineering, understanding, and documenting existing application data models • Acting as the primary owner and maintainer of new and existing OLTP data models • Acting as the primary owner and maintainer of new and existing DW/BI data models • Refactoring and optimizing existing data models to meet functional and performance needs • Formulating plans for incremental rollout of changes derived from refactoring and optimization • Advising and consulting with the architecture and development teams on data model changes • Providing advice or other inputs into the process of tuning new or existing database structures • Working with database administrators to ensure deployed data models function as intended • Overseeing extraction, transformation, and loading activities for data warehouse/data marts • Providing expertise in the formulation of efficient SQL queries and DML inserts/updates • Reviewing application SQL and DML written by development prior to implementation • All other duties as assigned.

Qualifications: • Bachelor’s degree in Computer Science or related years of experience. • 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 ERWin or similar data modeling tools is desirable • 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.

APPLY NOW