Hybrid - Presales Solution Architect - Data

$150,000 - $210,000/Yr

Insight Enterprises - Chandler, AZ

Full-time - Senior

Hybrid - Chandler, AZ

Professional, Scientific, and Technical Services

About the position

The DataOps Architect is a customer-facing role responsible for the design, modernization, and deployment of enterprise-level data estates, leveraging Microsoft's ecosystem of data technologies and native Azure services. This position emphasizes data governance and DataOps best practices, working closely with technical leads from both the Cloud Practice and DevOps Practice. The architect will integrate various data components with the overall solution, ensuring alignment with industry best practices such as the Well Architected and Cloud Adoption Frameworks. In this role, the DataOps Architect is expected to provide technical thought leadership, establish proven design patterns, and implement processes for evaluating and/or rearchitecting data landscapes across various maturity states. This includes creating long-term remediation strategies and defining relevant milestones that help catalyze the customer's business objectives. The architect will collaborate with cloud engineers and developers to ensure best practices and proper resource utilization, while also assisting customers with model deployment and operations. The goal is to equip customers with the necessary tools and insights to make informed decisions regarding the maintenance and evolution of their data landscape. A strong familiarity with the Azure cloud platform is essential, particularly experience with Azure and Microsoft data platforms, as well as business intelligence (BI), reporting, data pipelines, and data warehouses/data lakes. The architect will also be responsible for assessing and modernizing obsolete or partially deployed data warehouses, helping clients transition to a modernized data landscape that leverages a centralized data lake with a proper governance framework to empower self-service analytics and democratized modeling aimed at analyst communities.

Responsibilities

• Provide senior level technical expertise assessing and modernizing obsolete or partially deployed data warehouses and poorly managed user data repositories.
• Act as lead resource for data estate architecture reviews; perform readiness assessments for cloud and assist with appropriate migration strategies and reference architecture.
• Work in tandem with a cloud architect to assess an application's cloud readiness, focusing on the customer's data ecosystem and providing gap analysis for data management and governance.
• Provide technical leadership and become a trusted advisor to cloud and data teams, guiding them in adopting best practices and proper governance.
• Collaborate with business users to design, develop, test, and implement business intelligence solutions in the Data & Analytics Platform.
• Build Data Lakes and Data Catalogs to provide actionable insights into prioritized processes and key business performance metrics.
• Develop optimal data pipeline architecture to align with business requirements.
• Design end-to-end aspects of the data architecture, ensuring resilience and optimization for performance, cost, and security.
• Collaborate closely with developers to leverage DevOps best practices, following agile methodology, and modernizing processes with continuous integration and development.
• Ensure security is integrated into all workflows, data repositories, and architecture solutions, continuously improving security posture.
• Create and maintain reference architecture documentation.
• Stay abreast of industry best practices, identifying and driving opportunities to improve reference architectures and implementation processes.

Requirements

• 5+ years experience with traditional data warehousing, multidimensional and tabular models, and writing/optimizing data pipelines.
• Solid proficiency in traditional RDBMS and EDW platforms: SQL Server, Postgres, MySQL, SSIS, SSAS, Dimension & Fact Tables, Indexing, etc.
• Proficient in at least 2 modern data querying languages: T-SQL, Kusto, DAX, PowerQuery, etc.
• Experience with NoSQL platforms: MongoDB, CosmosDB, Cassandra, etc.
• Intermediate proficiency with Excel, PowerPivot, and PowerBI.
• Strong focus on Microsoft Data Fabric ecosystem: Data Factory, Purview/Data Catalog, Power BI, ADLSv2/OneLake, Data Explorer/Kusto.
• Real-world understanding of data governance, data mapping, data catalogs, and self-service data repositories.
• Understanding of Azure Well Architected Framework and experience deploying and conforming to Azure/cloud architecture best practices.
• Hands-on experience configuring Azure environment and designing/deploying data solutions with Azure IaaS and PaaS services.
• Experience designing and deploying data protection and encryption mechanisms and integrating with key management (e.g., Azure Key Vault).
• Experience with DevOps practices: GitOps/GitHub, Azure DevOps Repos/Pipelines.
• Experience working on large, complex projects following Agile/Scrum methodology.

Nice-to-haves

• Experience with streaming/IOT data tools: IOT Hub, Stream Analytics, Data Explorer, Time Series Insights.
• Exposure to and experience with ML Engineering, MLOps, Azure ML Services, Copilot, Knowledge Mining/Search.
• Experience with big data platforms: Spark, Pandas/PySpark, Hive/Spark SQL, Kafka.

Benefits

• Competitive salary range of $150,000 to $210,000 based on various factors.
• Additional bonuses and benefits available.
• Equal opportunity employer with consideration for all qualified applicants.