Microsoft Analytics Data Engineer Senior Consultant

Protiviti • Chicago, IL

9d • Hybrid

About The Position

Protiviti is looking for a Technology Consulting Senior Consultant to join our growing Enterprise Data & Analytics team. 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.

Requirements

• 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.
• 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.
• 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.

Nice To Haves

• Advanced certification is preferred (see Recommended Qualifications).
• Bonus: Experience with Data Science and/or Machine Learning.
• 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

• Designing and delivering modern data engineering solutions with Microsoft Fabric and Azure Databricks.
• Building relationships with clients and providing clients with exceptional experiences.
• Contributing to a positive team culture that fosters open communication among all engagement team members.
• Creating development opportunities for others and ways for your team to improve our clients and communities.
• Working with a diverse portfolio of clients across multiple 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.
• Data engineering, including data movement, data integration, transformation, and cleansing.
• Designing and managing data warehousing solutions that optimize data storage and retrieval.
• Data modeling, including entity-relationship diagrams, dimensional modeling, and semantic modeling.
• 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.
• Understanding data security practices, including encryption and access control.
• Configuring Azure data solutions with networking considerations.
• Implementing DevOps or DataOps concepts and 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 technologies such as Microsoft Fabric, Azure Storage, Azure Databricks, Power BI, Git-based version control and deployments for Azure Data Solutions, Microsoft Purview, and Azure AI tooling.

Benefits

• Medical coverage
• Dental coverage
• Vision coverage
• 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
• Up to 20 days of CTO per calendar year for new hires
• Up to 11 paid holidays each calendar year
• Annual bonus plan

What This Job Offers

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