Microsoft Analytics Data Engineer Senior Consultant

Protiviti•New York, NY

4d•$110,000 - $164,000•Hybrid

About The Position

You Belong Here The Protiviti Career provides opportunity to learn, inspire, and advance within a collaborative and inclusive culture. We hire curious individuals for whom learning is a passion. We lean into our mission: We Care. We Collaborate. We Deliver. At every level, we champion leaders who live our values of integrity, inclusion, innovation, and commitment to success. Imagining our work as a journey, we believe integrity guides our way, inclusion moves us forward together, innovation creates new destinations, and our commitment to success empowers us to deliver on our vision to be the most trusted global consulting firm. Where We Need You Protiviti is looking for a Technology Consulting Senior Consultant to join our growing Enterprise Data & Analytics team. What You Can Expect As a Senior Consultant, you will be a mentor, trainer, and coach to Interns and Consultants as you facilitate the successful completion of project work plans. You’ll identify areas of risk and opportunities to increase efficiency. You’ll strengthen relationships and deepen your abilities to communicate, gain trust, and network with client personnel and professional associates. At the direction of Managers, you may accept responsibility for decision-making in areas including establishing project scope and work plans, project staffing, preparation of deliverables, and application of methodologies. What Will Help You Be Successful You enjoy business-focused analytics, reporting, and engineering solutions and requirements and how they can be solved with Microsoft technologies. You are motivated to learn and interested in all things related to business intelligence reporting and data engineering, including the latest trends and developments. You are passionate about building relationships with clients and providing clients with exceptional experiences. You have an inherent interest in project management and team leadership. You contribute to a positive team culture that fosters open communication among all engagement team members. You create development opportunities for others and ways for your team to improve our clients and communities. You have interest in working with a diverse portfolio of clients across multiple industries. Do Your Talents Include the Following? You have experience with many and familiarity with most of the following Concepts and Methodologies: Ability to articulate the value of Microsoft Fabric and Business Intelligence solutions to customers and colleagues, and proven track record of data storytelling to guide decision-making. Participation in the process of formulating, communicating, and executing data strategies that align with organizational goals and objectives leveraging Microsoft technologies. Experience in assessing existing data solutions, whether on-premises or in the cloud, to inform improvement initiatives. Basic skills in architecting future state data solutions on Azure and Microsoft Fabric based on the Well-Architected Framework. Some experience in planning and migrating data solutions from various sources, including on-premises, other cloud platforms, or legacy systems, to Microsoft Cloud 1st Solutions. Proficiency with implementing ETL processes and databases on Microsoft Technologies. Experience optimizing existing data implementations, including pipelines, queries, and data models, to enhance performance and delivery of value to the business. Knowledge of administering and maintaining data solutions to ensure stability, security, scalability, and affordability. Proficiency in data engineering, including data movement, data integration, transformation, and cleansing. Ability to contribute to designing and managing data warehousing solutions that optimize data storage and retrieval. Skills in data modeling, including entity-relationship diagrams, dimensional modeling, and semantic modeling. Track record of creating engaging data visualizations and interactive dashboards. Ability to perform data analytics, including exploratory data analysis and leveraging data for actionable insights. Some experience with implementing data governance frameworks and policies, including an understanding of managing data assets. Understanding of data security practices, including encryption and access control. Some knowledge of networking as it applies to configuring Azure data solutions. Understanding of DevOps or DataOps concepts and experience with the deployment of Azure data solutions. Proficiency in SQL and bonus for familiarity with any of the programming languages utilized within the Microsoft Data Platform stack, such as Python, Spark, C#, Java, Scala, R, DAX, MDX, or M. Advanced certification is preferred (see Recommended Qualifications). Bonus: Experience with Data Science and/or Machine Learning. Competency with at least 3 and exposure to most of these technologies: Microsoft Fabric Azure Storage Azure Databricks (PySpark, SparkSQL, etc.) Power BI Git-based version control and deployments for Azure Data Solutions Microsoft Purview Bonus: Azure AI tooling Your Educational and Professional Qualifications Bachelor’s degree in a relevant discipline (e.g., MIS, CIS, Analytics) 2+ years working in professional services or related industry. Proficiency in Microsoft Office suite applications with specific emphasis on Word, Excel and PowerPoint. Secondary emphasis on Visio and Access. Our Hybrid Workplace Protiviti practices a hybrid model, which is a combination of working in person with a purpose and working remotely. This model creates meaningful experiences for our people and our clients while offering a flexible environment. The ratio of remote to in-person requirements vary by client, project, team, and other business factors. Our people work both in-person in local Protiviti offices and on client sites, which can include local or out-of-state travel based on our projects and client requests and commitments.

Requirements

You enjoy business-focused analytics, reporting, and engineering solutions and requirements and how they can be solved with Microsoft technologies.
You are motivated to learn and interested in all things related to business intelligence reporting and data engineering, including the latest trends and developments.
You are passionate about building relationships with clients and providing clients with exceptional experiences.
You have an inherent interest in project management and team leadership.
You contribute to a positive team culture that fosters open communication among all engagement team members.
You create development opportunities for others and ways for your team to improve our clients and communities.
You have interest in working with a diverse portfolio of clients across multiple industries.
Ability to articulate the value of Microsoft Fabric and Business Intelligence solutions to customers and colleagues, and proven track record of data storytelling to guide decision-making.
Participation in the process of formulating, communicating, and executing data strategies that align with organizational goals and objectives leveraging Microsoft technologies.
Experience in assessing existing data solutions, whether on-premises or in the cloud, to inform improvement initiatives.
Basic skills in architecting future state data solutions on Azure and Microsoft Fabric based on the Well-Architected Framework.
Some experience in planning and migrating data solutions from various sources, including on-premises, other cloud platforms, or legacy systems, to Microsoft Cloud 1st Solutions.
Proficiency with implementing ETL processes and databases on Microsoft Technologies.
Experience optimizing existing data implementations, including pipelines, queries, and data models, to enhance performance and delivery of value to the business.
Knowledge of administering and maintaining data solutions to ensure stability, security, scalability, and affordability.
Proficiency in data engineering, including data movement, data integration, transformation, and cleansing.
Ability to contribute to designing and managing data warehousing solutions that optimize data storage and retrieval.
Skills in data modeling, including entity-relationship diagrams, dimensional modeling, and semantic modeling.
Track record of creating engaging data visualizations and interactive dashboards.
Ability to perform data analytics, including exploratory data analysis and leveraging data for actionable insights.
Some experience with implementing data governance frameworks and policies, including an understanding of managing data assets.
Understanding of data security practices, including encryption and access control.
Some knowledge of networking as it applies to configuring Azure data solutions.
Understanding of DevOps or DataOps concepts and experience with the deployment of Azure data solutions.
Proficiency in SQL and bonus for familiarity with any of the programming languages utilized within the Microsoft Data Platform stack, such as Python, Spark, C#, Java, Scala, R, DAX, MDX, or M.
Bachelor’s degree in a relevant discipline (e.g., MIS, CIS, Analytics)
2+ years working in professional services or related industry.
Proficiency in Microsoft Office suite applications with specific emphasis on Word, Excel and PowerPoint. Secondary emphasis on Visio and Access.

Nice To Haves

Advanced certification is preferred (see Recommended Qualifications).
Bonus: Experience with Data Science and/or Machine Learning.
Competency with at least 3 and exposure to most of these technologies: Microsoft Fabric Azure Storage Azure Databricks (PySpark, SparkSQL, etc.) Power BI Git-based version control and deployments for Azure Data Solutions Microsoft Purview Bonus: Azure AI tooling
Microsoft Certified: Fabric Analytics Engineering Associate (highly desired)
Microsoft Certified: Fabric Data Engineer Associate
Microsoft Certified: Azure Developer Associate
Microsoft Certified: Azure Administrator Associate
Microsoft Certified: Azure Solutions Architect Expert

Responsibilities

As a Senior Consultant, you will be a mentor, trainer, and coach to Interns and Consultants as you facilitate the successful completion of project work plans.
You’ll identify areas of risk and opportunities to increase efficiency.
You’ll strengthen relationships and deepen your abilities to communicate, gain trust, and network with client personnel and professional associates.
At the direction of Managers, you may accept responsibility for decision-making in areas including establishing project scope and work plans, project staffing, preparation of deliverables, and application of methodologies.

Benefits

Employees are eligible for medical, dental, and vision coverages, FSA and HSA healthcare accounts, life and accident insurance, adoption and fertility assistance, paid parental leave up to 10 weeks, and short/long term disability.
We offer eligible employees a company 401(k) savings and investment plan with an employer match of 50% on the first 6% of your contributions.
We provide Choice Time Off (CTO) for vacation, personal needs, and sick time. The amount of (CTO) varies based on years of service. New hires receive up to 20 days of CTO per calendar year.
Protiviti also recognizes up to 11 paid holidays each calendar year.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume