Data Consultant

Important Information

• Experience: More than 4 years
• Job Mode: Full-time
• Work Mode: Hybrid

Job Summary

• Work with the Data Visualization team, focusing on expertise in Microsoft BI, Power BI, and Azure Data Factory.
• Manage multiple client engagements, delivering high-quality results within stipulated timelines.
• Analyze and understand business requirements, creating information architecture, taxonomy, and solution approaches.
• Design and build complete ETL/Azure Data Factory processes for data movement and transformation across ODS, Staging, and Data Warehousing.
• Develop and deploy BI dashboards, models, and KPIs using Power BI.
• Translate business requirements into technical code and ensure efficient data cleansing, extraction, and loading processes.
• Provide technical demonstrations and prototypes for visualizations and reporting solutions.

Responsibilities and Duties

• Collaborate with stakeholders to gather and analyze business requirements, translating them into effective data solutions.
• Independently manage data cleansing, extraction, and loading tasks.
• Design and implement ETL processes using Azure Data Factory for seamless data transformation.
• Develop and deploy BI dashboards, reports, and KPIs using Power BI.
• Build and optimize data models, schemas, stored procedures, and functions in SQL.
• Prototype data visualizations, scorecards, and performance metrics using Power BI.
• Exhibit expertise in managing multiple client engagements and leading teams to deliver high-quality deliverables.
• Demonstrate strong project management skills and inspire teamwork within engagement teams.

Qualifications and Skills

• Education: Bachelor’s or Master’s degree in Computer Science, Engineering, Information Technology, or a related field.
• Strong expertise in Power BI, Azure Data Factory, Azure Synapse, and Microsoft Fabric.
• Proficiency in SQL and Azure SQL, including schema design, stored procedures, and T-SQL.
• Skills in Data Modeling, DAX, and Power Query for advanced reporting solutions.
• Experience with Databricks, Data Lake, and technologies such as Scala/Spark/SQL.
• Basic knowledge of Azure Machine Learning Services.
• Excellent written and verbal communication skills.
• Ability to deliver technical demonstrations and explain concepts to stakeholders.
• A quick learner with a proactive, “can-do” attitude.

Role-specific Requirements

• Ability to manage senior stakeholders and build strong relationships.
• Experience leading teams to execute high-quality deliverables.
• Skilled in planning engagements, developing risk assessments, and creating timelines.
• Knowledge of modern BI technologies and tools for advanced reporting and analytics.
• Ability to prototype and deliver data visualizations tailored to business needs.
• Strong collaboration and teamwork skills to work with engagement teams and stakeholders effectively.

Technologies

• Business Intelligence Tools: Power BI, Microsoft Fabric
• Data Management Tools: Azure Data Factory, Azure Synapse, Databricks, Data Lake
• Databases: SQL, Azure SQL
• Programming and Data Processing: Scala, Spark, SQL

Skillset Competencies

• Advanced Power BI development and dashboard deployment.
• ETL and data transformation using Azure Data Factory.
• Expertise in SQL schema design, stored procedures, and database optimization.
• Strong data modeling and DAX/Power Query skills.
• Ability to analyze business requirements and deliver tailored solutions.
• Effective communication and technical presentation skills.
• Leadership and project management in a collaborative, team-based environment.

About Encora

• Encora is a trusted partner for digital engineering and modernization, working with some of the world’s leading enterprises and digital-native companies. With over 9,000 experts in 47+ offices worldwide, Encora offers expertise in areas such as Product Engineering, Cloud Services, Data & Analytics, AI & LLM Engineering, and more. At Encora, hiring is based on skills and qualifications, embracing diversity and inclusion regardless of age, gender, nationality, or background.