Lead Data Analyst

CES has 26+ years of experience in delivering Software Product Development, Quality Engineering, and Digital Transformation Consulting Services to Global SMEs & Large Enterprises. CES has been delivering services to some of the leading Fortune 500 Companies including Automotive, AgTech, Bio Science, EdTech, FinTech, Manufacturing, Online Retailers, and Investment Banks. These are long-term relationships of more than 10 years and are nurtured by not only our commitment to timely delivery of quality services but also due to our investments and innovations in their technology roadmap. As an organization, we are in an exponential growth phase with a consistent focus on continuous improvement, process-oriented culture, and a true partnership mindset with our customers. We are looking for the right qualified and committed individuals to play an exceptional role as well as to support our accelerated growth.    You can learn more about us at:

Job Summary
As a key member of our team, the Business Intelligence (BI) Developer will be responsible for leading the design, implementation, and management of enterprise-level BI solutions. This role demands strong expertise in data architecture and governance to generate actionable insights that drive informed decision-making across the organization. The ideal candidate will establish and enforce best practices, ensuring robust data governance and high data quality standards. This role involves collaborating with cross-functional teams to gather requirements and leveraging skills and experience to create end-to-end solutions, from data acquisition and data modelling to support reporting and visualization. The candidate will continuously assess and adopt new technologies, methodologies and practices to enhance data processing capabilities. This position is crucial in ensuring high-quality data operations and providing valuable insights to support the organization's decision-making processes.

Job Role:

• Lead the end-to-end design and implementation of scalable, enterprise-grade BI solutions, ensuring alignment with business objectives and data strategy.

• Work with business stakeholders to gather requirements and translate them into end-to-end technical solutions.

• Lead the design, development, and deployment of Power BI reports and dashboards with interactive and user-friendly visualizations.

• Collaborate with Data Engineers to design and implement data models that are scalable and optimized for performance and efficiency for reporting and visualizations.

• Optimize Databricks SQL query performance and troubleshoot slow-running reports or data processes.

• Design and implement advanced DAX measures, calculated columns, and tables to support complex business requirements.

• Optimize DAX queries for performance and scalability, ensuring responsive and efficient reports.

• Administer Power BI service, including workspace management, user access, and licensing.

• Implement and manage object and row-level data security in data solutions.

• Audit and monitor Power BI usage, ensuring compliance with organizational policies and standards.

• Establish and enforce data governance policies, ensuring data accuracy, security, and consistency.

• Conduct regular data audits to identify and address issues related to data quality and integrity.

• Maintain documentation of data models, workflows, and business logic for transparency and collaboration.

• Ensure proper configuration management and change controls are implemented.  
Work Experience/KSA's

Key Responsibilities:

• 7-10 years – Proven experience in delivering end-to-end BI solutions, including requirement gathering, data modeling, reports and dashboarding.
• 7-10 years – Experience in visualization principles and user experience design for dashboards.
•  7-10 years – Experience in writing & analyzing complex SQLs, views, Materialized views to manage large volume data for reporting and dashboarding
•  5-7 years – Proven experience in Power BI development and administration within enterprise environments
•  5-7 years – Strong expertise in DAX, Power Query (M), and advanced data modeling in Power BI
•  5-7 years – Experience in Power BI governance and security
•  5-7 years – Experience in working with cloud data warehouse/lake house such as Databricks or Snowflake or any other similar platform
•  5-7 years – Hands-on experience with SQL performance tuning and optimization techniques with Databricks SQL or Snowflake or Oracle or SQL Server
•  5-7 years – Experience working ERP system as a data source with understanding of Finance, Supply Chain, Manufacturing, Procurement processes and data elements
• 3-5 years – Experience in using Azure DevOps for version control, CI/CD pipelines.

Competencies

• Strong analytical and problem-solving skills with the ability to troubleshoot complex issues
  
  • Excellent communication and interpersonal skills to work with cross-functional teams and business stakeholders
  
  • Ability to manage multiple tasks and priorities in a fast-paced environment
  
  • Attention to detail and a commitment to delivering high-quality, error-free data solutions
  
  • A strong sense of ownership and accountability, promptly notifying management of any issues that affect his/her ability to accomplish planned goals
  
  • Proven leadership qualities, fosters a sense of pride within the team and encourages individuals to take pride in their accomplishments.

---