RECRUITING FOR THE FUTURE This posting is for a future job opportunity. To support the needs of our clients, Avanade is actively recruiting and interviewing for the role outlined below, as we continue to build on another year of growth in our business. Now, with more than 60,000 employees around the globe, we are positioning our organization to effectively prepare for the future. What does this mean for you? We encourage you to apply and interview for this role without the need to decide now. This allows you to connect with leaders and hiring managers at a pace that works for you and when roles become available, you will be the first know. Data Engineering Senior Consultant Our talented Data and AI Practice is made up of globally recognized experts- and there's room for more analytical and ambitious data professionals. If you're passionate about helping clients make better data-driven decisions to tackle their most complex business issues. let's talk. Take your skills to a new level and launch a career where you can can truly do what matters. Come join us As an Data Engineer within our Data and AI Practice, you'll find, store and present a range of information from different sources so that everyone can access what they need quickly and simply, and use it effectively. You draw on your considerable experience in bringing data and statistics to life to solve sometimes complex problems, and you’re comfortable looking after several projects at once. You’re able to make your own decisions while at the same time supporting more junior team members. Together we do what matters. What you'll do Working in Data Engineering, you know the importance of data to business. You design and set up projects that bring together information from a variety of sources, to enable analysis and decision-making. You make sure that data is accessible and easy to use, so that it can be used for routine and ad-hoc analysis. Day to day, you will: * Use your knowledge to plan and deliver data warehouse and storage * Take part in designing and running bespoke data services for individual projects * Design, develop, adapt and maintain data warehouse architecture and relational databases that support data mining * Customize storage and extraction, metadata, and information repositories * Create and use effective metrics and monitoring processes * Help to develop business intelligence tools * Travel as required. Skills and experiencesss * You’re got great experience in data and analysis, and how to source, store and share information. You’re a problem solver who’s happy to work autonomously and to share their knowledge and skills, as well as guiding other team members. * Manage data pipelines: assist in creation of end-to-end data pipelines from external and internal sources to the data warehouse; create new pipelines, recreate config files as needed. * Manage jobs: Create automation jobs (e.g. Azure Data Factory) to normalize and prepare data to be consumed by analytics and the business. * Platform administration: Administration of existing in-house databases running in Azure, Make and implement recommendations for optimization and monitoring. * Provide subject-matter expertise on best practices for data and platform management, and technology adoption * Collaboration: Work closely with data analysts to ensure the data model consistently feeds the desired end-user reports and queries * Data governance: Experienced in developing and integrating software allowing for flexible and scalable data transformation with data quality controls * Knowledge of Python and PySpark About you Characteristics that can spell success for this role: * Advanced knowledge in entity and relationship extraction from unstructured data * Understanding of database table indexing, with emphasis on clustered column store tables * Proficient in data handling, understanding, analysis and interpretation of results * Experience with SQL technologies: Databricks (Spark), OR Azure Synapse * Data security: Must be able to demonstrate an understanding of data security at rest and in transit * Scale: Deliver performance at scale, and accurately anticipate system enhancement needs * Data integrity: Data manipulation, error identification and handling, and modeling Enjoy your career  Some of the best things about working at Avanade  People-first culture that supports innovation and encourages people to move forward  Turn your ideas to human impact by cultivating a team that will help clients unlock what’s next​  Opportunities to innovate in the Microsoft platform while charting your own career path  On-the-job growth through hackathons, innovation contests, and other expressions of our passion for innovating with purpose  Real-time access to technical and skilled resources globally    Find out more about some of our benefits [1] here.    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 our communities. You’ll join a community of smart, supportive collaborators to lift, mentor, and guide you, but to also 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!     We work hard to provide an inclusive, diverse culture with a deep sense of belonging for all our employees. Visit our [2] Inclusion & Diversity page.    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 the types of projects our Data & AI team works on check out these case studies:  * [3] thyssenkrupp Materials Services uses data to help strike a delicate operational balance  * [4] What matters to SSE Renewables is innovating for a sustainable future  * [5] Hachette UK enables employees with machine learning-driven contract searches  * [6] Marston Holdings identifies significant cloud savings    Interested in knowing what’s going on inside Avanade? Check out our blogs:  * [7] Avanade Insights - exchange ideas that drive tomorrow’s innovation  * [8] Inside Avanade - explore what life is like working at Avanade    Compensation for roles at Avanade varies depending on a wide array of factors including but not limited to the specific office location, role, skill set and level of experience. As required by local law, Avanade provides a reasonable range of compensation for roles that may be hired in New York as set forth below and information on benefits offered is here.   Range of Starting Pay for role: New York: $140,250 - $ 165,000 References Visible links 1. https://www.avanade.com/en-gb/career/benefits 2. https://www.avanade.com/en-us/about-avanade/inclusion-and-diversity 3. https://www.avanade.com/en-gb/clients/thyssenkrupp 4. https://www.avanade.com/en-gb/clients/sse-renewables-ai 5. https://www.avanade.com/en-gb/clients/hachette-automated-identification 6. https://www.avanade.com/en-gb/clients/marston-holdings 7. https://www.avanade.com/en/blogs/avanade-insights 8. https://www.avanade.com/en/blogs/inside-avanade