Intelligent Data Platform - Data Engineering Consultant

Leading organizations - corporations, non-profits, government departments, look to Avanade to help them make the most of their investment in Microsoft and to push the boundaries of digital innovation. The result? Interesting work that is well supported, always evolving and sure to keep you engaged and interested. Together we go beyond.

Come join us

As a Data Engineering Consultant within Avanade, you will use comprehensive modern data engineering techniques and methods to support business decisions for Avanade clients. You can collect, aggregate, and analyse structured and 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 a 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.

What you'll do

· Translate business requirements to technical solutions leveraging strong business acumen.

· Analyse current business practices, processes and procedures as well as identifying future business opportunities for leveraging Microsoft Azure Data & AI services.

· Support the planning and implementation of data design services, providing sizing and configuration assistance and performing needs assessments.

· Deliver end-to-end data architectures for transformations and modernisations 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, Advanced Analytics and AI.

· Expose data to end users using Power BI, Azure API Apps or any other modern visualisation platform or experience.

· Implement effective metrics and monitoring processes

· Travel as needed.

Skills and experiences

you likely have 3-5 years of relevant professional experience

· Demonstrated experience of turning business use cases and requirements to technical solutions.

· Strong team collaboration and experience working with remote teams.

· you are able to execute project/program plans and processes in alignment with established operational objectives.

· you have the ability to coordinate work across different workstreams, processes, or projects.

· you can solve complex problems that can span across work domains requiring considerable judgment of contextual factors.

· you possess a wide latitude in approach to work within established work plans.

· you are able to work under general guidance and direction, but fully independent in own work with latitude for autonomous decision-making related to work process.

· you can support more junior colleagues on work efforts, with routine supervision of those efforts. May serve as Career Advisor

· You can apply advanced knowledge of learned occupation/discipline and basic knowledge of business operations.

Technical skills

· Experience in business processing mapping of data and analytics solutions.

· Ability to conduct data profiling, cataloguing, and mapping for technical design and construction of technical data flows.

· Ability to apply such methods to solve business problems using one or more Azure Data & AI services in combination with building data pipelines, data streams, and system integration.

· Mastery of Python, .NET C# and T-SQL with the familiarity of U-SQL is required.

· Knowledge of Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure SQL, Azure Databricks, Azure App Service is required.

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

· Working experience with Visual Studio, PowerShell Scripting, and Azure Resource Manager (ARM) templates.

· Experience with Git/TFS/Azure DevOps is a must.

· Knowledge of Lambda and Kappa architecture patterns.

· Knowledge of Master Data Management (MDM) and Data Quality tools and processes.

· Microsoft Fabric, Azure IoT Operations, Azure Cosmos DB, Azure Stream Analytics is a plus.

· Experience preparing data for use in Azure AI Services (Azure ML, Azure OpenAI, Azure Computer Vision, etc.) is a plus.

· Designing and building data pipelines using streams of IoT data is a plus.

Education & Certifications:

· You likely possess a BSc in a quantitative field such as computer science, applied mathematics, statistics, or another relevant field. An equivalent combination of education and experience will also suffice.

· You likely possess a certification in one or more of the following:

· Azure Data Engineer Associate (DP-203)

· Microsoft Fabric Analytics Engineer (DP-600)

· Azure Enterprise Data Analyst Associate (DP-500)

Enjoy your career

Some of the best things about working at Avanade:

• Opportunity to work for Microsoft’s Global Alliance Partner of the Year (14 years in a row), with exceptional development and training (minimum 80 hours per year for training and paid certifications)

• Real-time access to technical and skilled resources globally

• Dedicated career advisor to encourage your growth

• Engaged and helpful coworkers genuinely interested in you

Find out more about some of our benefits [1] here ([2] https://www.avanade.com/en/career/benefits).

A great place to work

As you bring your skills and abilities to Avanade, you’ll get distinctive experiences, limitless learning, and ambitious growth in return. As we continue to build our diverse and inclusive culture, we become even more innovative and creative, helping us better serve our clients and communities. You’ll join a community of smart, supportive collaborators to lift, mentor, and guide you, and to lean on your expertise. You get a company purpose-built for business-critical, leading-edge technology solutions, committed to improving the way humans work, interact, and live. It’s all here, so take a closer look!

Together we do what matters.

We work hard to provide an inclusive, diverse culture with a deep sense of belonging for all our employees. Visit our [3] Inclusion & Diversity page ([4] https://www.avanade.com/en-us/about-avanade/inclusion-and-diversity).

Create a future for our people that focuses on:

• Expanding your thinking

• Experimenting courageously

• Learning and pivoting

Inspire greatness in our people by:

• Empowering every voice

• Encouraging boldness

• Celebrating progress

Accelerate the impact of our people by:

• Amazing the client

• Prioritizing what matters

• Acting as one

Learn more

To learn more about some of Avanade’s client success stories, check out the following case study:

· [5] Inail Digitization with Digital Desk- Avanade

Interested in knowing what’s going on inside Avanade? Check out our blogs:

· [6] Avanade Insights - exchange ideas that drive tomorrow’s innovation

· [7] Inside Avanade - explore what life is like working at Avanade

References

Visible links

1. https://www.avanade.com/en/career/benefits

2. https://www.avanade.com/en/career/benefits

3. https://www.avanade.com/en-us/about-avanade/inclusion-and-diversity

4. https://www.avanade.com/en-us/about-avanade/inclusion-and-diversity

5. https://www.avanade.com/en-au/clients/sportello-digitale-di-inail

6. https://www.avanade.com/en/blogs/avanade-insights

7. https://www.avanade.com/en/blogs/inside-avanade