Microsoft Data Engineering Associate Director (Microsoft Fabric & Databricks)

Protiviti • New York, NY

1d • $173,000 - $295,000 • Hybrid

About The Position

Protiviti is looking for a Technology Consulting Associate Director to join our growing Enterprise Data & Analytics. As an Associate Director, you'll take a lead role in strengthening our relationships with clients and providing seamless guidance in the completion of engagements. You'll partner with our strategic clients to manage risk associated with their use of technology. You'll develop strategies to solve complex business problems using new ways of thinking, and devise solutions to support your clients' needs through analytics, automation or the latest tools and methods. You’ll develop new projects, help identify new business, and build lasting relationships with clients and within the community as you serve as an ambassador of Protiviti in the market. You will also be a mentor and provide growth and development to teams as you oversee the successful completion of project work plans.

Requirements

• 9+ years working in professional services or industry.
• Proficiency in Microsoft Office suite applications with specific emphasis on Word, Excel and PowerPoint.
• Secondary emphasis on Visio and Access.
• Proficiency in SQL.
• Familiarity with programming languages utilized within the Microsoft Data Platform stack, such as Python, Spark, C#, Java, Scala, R, DAX, MDX, or M.
• 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.
• Experience with data engineering, including data movement, data integration, transformation, and cleansing.
• Skills in data modeling, including entity-relationship diagrams, dimensional modeling, and semantic modeling.
• Ability to perform data analytics, including exploratory data analysis and leveraging data for actionable insights.
• Understanding of data security practices, including encryption and access control.
• Understanding of DevOps or DataOps concepts.
• 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. Ability to contribute to designing and managing data warehousing solutions that optimize data storage and retrieval. Track record of creating engaging data visualizations and interactive dashboards. Some experience with implementing data governance frameworks and policies, including an understanding of managing data assets. Some knowledge of networking as it applies to configuring Azure data solutions. Experience with the deployment of Azure data solutions.

Nice To Haves

• Advanced certification is preferred.
• 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.
• Experience with Data Science and/or Machine Learning.
• Bonus: Azure AI tooling.

Responsibilities

• Designing and delivering modern data engineering solutions with Microsoft Fabric and Azure Databricks.
• Building trusted relationships with C-level executives and providing exceptional experiences that translate to additional project work.
• Promoting a positive team culture that fosters open communication among all engagement team members.
• Creating development opportunities for others, including participating in the creation and rollout of training, and ways for your team to improve our clients and communities.
• Discovering prospective project work with current and potential clients through networking, knowledge-building, and client interactions.
• Identifying opportunities to integrate product solutions and resources to improve client service capabilities.
• Translating client challenges into new project proposals and sales.
• Being a valued contributor to thought leadership and encouraging knowledge-sharing and collaboration across teams.
• Managing a diverse portfolio of clients across industries.
• Articulating the value of Microsoft Fabric and Business Intelligence solutions to customers and colleagues.
• Guiding decision-making through data storytelling.
• Formulating, communicating, and executing data strategies that align with organizational goals and objectives leveraging Microsoft technologies.
• Assessing existing data solutions, whether on-premises or in the cloud, to inform improvement initiatives.
• Architecting future state data solutions on Azure and Microsoft Fabric based on the Well-Architected Framework.
• Planning and migrating data solutions from various sources, including on-premises, other cloud platforms, or legacy systems, to Microsoft Cloud 1st Solutions.
• Implementing ETL processes and databases on Microsoft Technologies.
• Optimizing existing data implementations, including pipelines, queries, and data models, to enhance performance and delivery of value to the business.
• Administering and maintaining data solutions to ensure stability, security, scalability, and affordability.
• Performing data engineering, including data movement, data integration, transformation, and cleansing.
• Designing and managing data warehousing solutions that optimize data storage and retrieval.
• Creating engaging data visualizations and interactive dashboards.
• Performing data analytics, including exploratory data analysis and leveraging data for actionable insights.
• Implementing data governance frameworks and policies, including managing data assets.
• Configuring Azure data solutions.
• Deploying Azure data solutions.
• Utilizing SQL and programming languages utilized within the Microsoft Data Platform stack, such as Python, Spark, C#, Java, Scala, R, DAX, MDX, or M.
• Implementing Data Science and/or Machine Learning solutions.
• Utilizing Microsoft Fabric, Azure Storage, Azure Databricks (PySpark, SparkSQL, etc.), Power BI, Git-based version control and deployments for Azure Data Solutions, Microsoft Purview, and Azure AI tooling.

Benefits

• 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
• short/long term disability
• company 401(k) savings and investment plan with an employer match of 50% on the first 6% of your contributions
• Choice Time Off (CTO) for vacation, personal needs, and sick time
• 11 paid holidays each calendar year

What This Job Offers

• Job Type: Full-time
• Career Level: Director