Senior Consultant- Azure Data Engineering

Senior Consultant- Data Engineering 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.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

• Use your knowledge to plan and deliver data warehouses and storage

• Take part in crafting and running bespoke data services for individual projects

• Stay up to date with business best practice in using and retrieving data

• Design, develop, adapt, and maintain data warehouse architecture and relational databases that support data mining

• Customize storage and extraction, metadata, and information repositories

• Build and use effective metrics and monitoring processes

• Help to develop business intelligence tools

• Craft and maintain report forms and formats, information dashboards, data generators and canned reports, as well as other information portals and resources  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: $121,5 - $ 143, 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  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.   As a Data Engineer within our Data and AI practice, you'll 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. Together we do what matters.ss

• Strong knowledge of Python, Spark, and T-SQL * Microsoft Fabric/Synapse, Purview, Profisee and Azure Databricks

• Database, storage, collection and aggregation models, techniques, and technologies - and how to apply them in business

• Ability to use technology to aim business problems using one or more Microsoft Analytics services for building data pipelines, data streams, and system integration