Azure Data Platform Architect (Remote)

Nxt Level Los Angeles , CA 90003

Posted 3 months ago

We're looking for a versatile Data Warehouse Architect with deep Azure Cloud Solutions experience who can easily step into many different types of engagements. The ideal candidate would be familiar and comfortable with all levels of the Microsoft SQL Server Stack. This position will be responsible for leading customer conversations, creating and presenting project architecture, and leading delivery.

This is a REMOTE position with the expectation to travel about 20-25% of the time to meet onsite with clients.



Need to Understand the following:

  • 400+ level knowledge of Azure Data Factory, Azure Data Lake, Azure SQL Data Warehouse, Azure SQL Database

  • 300 level knowledge of Spark, Python, Azure Analysis Services

  • 200 level knowledge of Azure Services in General

Required Technical Skills:

  • Ability to appropriately architect complex data solutions utilizing SQL Server architecture. This includes storage, replication, server tuning, upgrading, backup/restore, security, etc.

  • Ability to write complex SQL queries

  • TSQL knowledge, DML/DDL, triggers, CTE's, query tuning, etc.

  • Strong knowledge of SSIS: script tasks, check points, record set objects, package vs. project deployment.

  • Practical knowledge in how to design complex SQL Server Integration Services (SSIS) packages

  • Knowledge of SQL Server Reporting Service and Power BI.

  • Knowledge of Azure SQL, and other Azure offerings centered around data and Analytics (Azure Machine Learning, Data Lake, Data Factory, Streaming Analytics, Table Storage, Hadoop, etc.)

  • Knowledge of working with unstructured data BI technologies is a plus

  • BS or MS in Computer Science, Engineering or Mathematics preferred, equivalent work experience will be considered.

Primary Responsibilities:

  • Interfacing directly with clients to solve broad business goals with data based solutions.

  • You will be responsible for gathering requirements, designing solutions, and overseeing the development and execution of projects.

  • This role will be directly involved in the business development process; specifically delivering customer demos to show the value of how data can drive business goals.

  • Be able to build pilot solutions and proof-of-concepts with minimal direction.

  • Provide support to project manager through developing tasks, estimates, and dependencies to meet expectations

Who you are:

  • Excels with ambiguity and able to design a clear path to meet end goals

  • Have a broad understanding of BI and data technologies and how to match the right technologies to solutions.

  • Have proven experience with both the customer facing and solution engineering skill set

This position is flexible to working in-office in Bellevue or remotely across the US.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Azure Data And AI Architect


Posted 6 days ago

VIEW JOBS 1/19/2020 12:00:00 AM 2020-04-18T00:00 Do you view data as an art and a science? So do we. Avanade leads in providing creative digital services, business solutions and design-led experiences for its clients, delivered through the power of people and the Microsoft ecosystem. Our professionals combine technology, business and industry expertise to build and deploy solutions to realize results for clients and their customers. Avanade has 27,000 digitally connected people across 23 countries, bringing clients the best thinking through a collaborative culture that honors diversity and reflects the communities in which we operate. We welcome all and seek talented individuals who can bring their whole self to work, build inclusive teams and encourage diversity inside and outside the organization. Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation. How we support you: We believe in gender equity and an inclusive community. We offer a comprehensive benefits package: generous vacation allowance disability coverage, retirement plans, paid maternity and paternity leave, life insurance, hotel and travel discounts, extended benefits to cover items that support your well-being, health, dental and vision insurance, professional development and paid Microsoft certification opportunities. About you: You put analytics into motion, using insight as the common thread between machine learning and human experiences. You're an authority at harnessing the power of emerging and established technologies to creatively design experiences centered on humans, as well as machines. You will design and build data pipelines, data streams, reporting tools, information dashboards, data service APIs, data generators and other end-user information portals and insight tools. You will be a critical part of the data supply chain, ensuring that stakeholders can access and manipulate data for routine and ad hoc analysis to drive business outcomes using Advanced Analytics. Role Overview: As an Azure Data & AI Architect at Avanade, you will act as a trusted advisor for Avanade clients by designing and building analytics architectures to enable better business outcomes for these corporations. You will work across client stakeholders to determine solution requirements and rationalize architecture decisions. During implementation, you will collect, aggregate, and analyze structured/unstructured data from multiple internal and external sources and present patterns, insights, and trends to decision-makers. Your goal is to support the use of data-driven insights to help our clients achieve business outcomes and objectives. Must Haves: You likely have about 5-7 years' relevant professional experience. Mastery of .NET C# and T-SQL with the familiarity of U-SQL. Knowledge of Azure Data & Analytics PaaS Services: Azure Data Factory, Azure Data Lake, Azure SQL DW, and Azure SQL. Expose data to end-users using Power BI, Azure API Apps or any other modern visualization platform or experience. Experience preparing data for Data Science and Machine Learning. Experience with Git/TFS/VSTS. Knowledge of Lambda and Kappa architecture patterns. Knowledge of Master Data Management (MDM) and Data Quality tools and processes. Pluses: Knowledge of Python. Azure IoT, Azure HDInsight + Spark, Azure Cosmos DB, Azure Databricks and Azure Stream Analytics. Experience preparing data for use in Azure Machine Learning and/or Azure Databricks is a plus. Day-to-day, you will: Translate business requirements to technical solutions leveraging strong business acumen. Analyzes current business practices, processes, and procedures as well as identifying future business opportunities for leveraging Microsoft Azure Data & Analytics PaaS Services. Support the planning and implementation of data design services, providing sizing and configuration assistance and performing needs assessments. Delivery of architectures for transformations and modernizations of enterprise data solutions using Azure cloud data technologies. Design and Build Modern Data Pipelines and Data Streams and build Data Service APIs. Develop and maintain data warehouse schematics, layouts, architectures and relational/non-relational databases for data access and Advanced Analytics. Implement effective metrics and monitoring processes. Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code fundamentals. Working experience with Visual Studio, PowerShell Scripting, and ARM templates. Ability to conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows. The ability to apply such methods to solve business problems using one or more Azure Data and Analytics services in combination with building data pipelines, data streams, and system integration. Strong team collaboration and experience working with remote teams. 80% travel as needed Capability Requirements: Your technical and non-technical skills include: Demonstrated experience of turning business use cases and requirements to technical solutions. Experience in business processing mapping of data and analytics solutions. Ability to conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows. The ability to apply such methods to solve business problems using one or more Azure Data and Analytics services in combination with building data pipelines, data streams, and system integration. Demonstrated experience preparing data and building data pipelines for AI Use Cases (text, voice, image, etc.…). Designing and building Data Pipelines using streams of IOT data. Preferred Education Background: You likely possess a Bachelor's/Master's/Ph.D. degree in Applied Mathematics, Statistics, Analytics, Operations Research, Economics/Econometrics, Engineering or another relevant quantitative field. You will likely have 5-7 years of experience Accountabilities & Metrics: Accountable for: Chargeability target and personal goals. Avanade Los Angeles CA

Azure Data Platform Architect (Remote)

Nxt Level