Country:

United States

Cities:

Augusta, Boston, Concord, Florham Park, Hartford, Jersey City, Newark, Philadelphia, Providence, Rochester, Stamford, Syracuse

Area of expertise:

Analytics

Job Description

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 Consultant

Do you enjoy making sure that information is accessible and easy to use? So do we.

You’re a data designer who knows how to 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.

About you

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.

About the job

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

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

Create and use effective metrics and monitoring processes

Help to develop business intelligence tools

Support deal teams by providing subject knowledge and solutions for client proposals

Author reports that include key performance indicators, show where current operations can be improved, and identify the causes of any problems

Create and maintain report forms and formats, information dashboards, data generators and canned reports, as well as other information portals and resources

Travel as required.

Your skills

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
Advanced knowledge in entity and relationship extraction from unstructured data
Understanding of database table indexing, with emphasis on clustered columnstore 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



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.  

Role Location: Range of Starting Pay for role

New York: $121,550 – $ 143,000


Apply now

Share this job:

Share Facebook Twitter

About Avanade

Avanade is the leading provider of innovative digital, cloud and advisory services, industry solutions and design-led experiences across the Microsoft ecosystem. Every day, our 59,000 professionals in 26 countries make a genuine human impact for our clients, their employees and their customers. 


We have been recognized as Microsoft’s Global SI Partner of the Year more than any other company. With the most Microsoft certifications (60,000+) and 18 (out of 18) Gold-level Microsoft competencies, we are uniquely positioned to help businesses grow and solve their toughest challenges.


We are a people first company, committed to providing an inclusive workplace where employees feel comfortable being their authentic selves. As a responsible business, we are building a sustainable world and helping young people from underrepresented communities fulfil their potential. 


Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation. Learn more at www.avanade.com. 

Apply now

Share this job:

Share Facebook Twitter Back to search jobs