Applications for this job have closed. Try searching for similar jobs.

Analytics Architect

Avanade

Location: Chicago, Illinois, Cincinnati, Ohio, Columbus, Ohio, Des Moines, Iowa, Detroit, Michigan, Green Bay, Wisconsin, Indianapolis, Indiana, Kansas City, Missouri, Minneapolis, Minnesota, Oklahoma City, Oklahoma

Job Type: Full time

Posted

Be brave, not perfect.
- Reshma Saujani

Avanade leads the technical consulting industry 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 26 countries, bringing clients the best thinking through a collaborative culture that honors diversity and reflects the communities in which we operate. Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation. Learn more at www.avanade.com.



How we support you:



Do you want to work in an environment that supports 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, extended benefits to cover items that support your well-being, health, dental and vision insurance, professional development and paid Microsoft certification opportunities.

We are looking for a highly motivated, hardworking expert in Data Platform Cloud Solutions. The successful Architect will be able to drive high priority customer initiatives using Azure. In conjunction with customers and the Microsoft's Enterprise accounts segment of our business, we will accomplish cutting edge solutions. This is a customer facing role, owning overall technical relationship between our customer and the Microsoft Data Platform. The role will extend to some Advanced Analytics and Artificial Intelligence concepts.


As a Data Engineering Group Manager at Avanade, you will use comprehensive modern data engineer techniques and methods with Advanced Analytics to support business decisions for Avanade clients. You can collect, aggregate, and analyze structured/unstructured data from multiple internal and external sources and 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. In this role, you will collect, aggregate, store, and reconcile data in support of Client business decisions. You will help 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.

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.

  • Design and Build Data Service APIs.

  • Develop and maintain data warehouse schematics, layouts, architectures and relational/non-relational databases for data access and Advanced Analytics.

  • Expose data to end users using PowerBI, Azure API Apps or any other modern visualization platform or experience.

  • Implement effective metrics and monitoring processes.

  • Travel as needed

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.
  • Mastery of .NET C# and T-SQL with the familiarity of U-SQL is required

  • Knowledge of Azure Data Factory, Azure Data Lake, Azure SQL DW (or Synapse), and Azure SQL, Azure App Service is required.

  • Azure IoT, Azure HDInsight + Spark, Azure Cosmos DB, Azure Databricks, Azure Stream Analytics is a plus.

  • Knowledge of Python is a plus.

  • Experience preparing data for Data Science and Machine Learning.

  • Experience preparing data for use in Azure Machine Learning and/or Azure Databricks is a plus.

  • 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.

  • Knowledge of Lambda and Kappa architecture patterns.

  • Knowledge of Master Data Management (MDM) and Data Quality tools and processes
  • Strong team collaboration and experience working with remote teams.

  • Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code fundamentals.

  • Working experience with Visual Studio, PowerShell Scripting, and ARM templates.

  • Experience with Git/TFS/VSTS is a must.

Preferred Certifications:

  • Azure Data Engineer Associate / Professional
  • Databricks Cloud Partner Champion
  • Databricks data Engineer Associate / Professional
  • AZ-305 Azure Solutions Architect
  • AZ-300/ AZ-303 Azure architect technologies
  • AZ-301 /AZ-304 MS Azure architect design

Preferred Education:

You likely possess MS/ Ph.D. in a quantitative field such as computer science, applied mathematics, statistics, or machine learning. An equivalent combination of education and experience will also suffice.

Preferred Years of work experience:

You likely have about 7+ years of relevant professional experience.

3+ years managing & leadership of 3 or more associates in management consulting or industry.

Avanade requires all new hires to be fully vaccinated against COVID-19 as a condition of employment. Avanade will consider requests for medical or religious accommodation to this vaccination requirement on an individual basis.