Job description
Senior Analyst
Job Description
Role and responsibilities:
- Design, develop, and maintain interactive and visually appealing Power BI dashboards and reports that provide actionable insights to business stakeholders.
- Develop complex DAX formulas and measures to create sophisticated calculations and aggregations within Power BI models.
- Proficiently apply various SQL window functions (e.g., ROW_NUMBER (), RANK (), LAG (), LEAD (), NTILE (), Loop, etc.) to transform and prepare data for Power BI consumption.
- Lead and execute data modeling efforts within Power BI, ensuring optimal performance, scalability, and data integrity (e.g., star schema, snowflake schema, relationships, hierarchies).
- Collaborate directly with business users to gather and understand reporting requirements, translating them into technical specifications and compelling dashboard designs.
- Design and implement complex charts and visualizations, including but not limited to Sankey diagrams, Step charts, drill down charts, dynamic charts (dynamic KPI and Dimension using field parameter) where number of charts or kpi’s and dimensions in a chart can be altered to represent intricate data flows and trends.
- Should be able to Develop Integrate and present outputs from machine learning models within Power BI reports and dashboards, leveraging Power BI's capabilities for predictive analytics and advanced insights.
- Architect and design end-to-end Power BI solutions, considering data sources, data transformation, data models, security, and deployment strategies.
- Provide clear and concise data requirements and specifications to data engineers for data ingestion, transformation, and warehousing initiatives.
- Optimize Power BI reports and dashboards for performance; including query optimization, data source connectivity, and visual rendering.
- Perform thorough data validation and quality checks to ensure accuracy and reliability of reports.
- Stay up-to-date with the latest Power BI features, industry trends, and best practices.
- Act as a subject matter expert for Power BI within the organization, providing guidance and support to other team members.
- Demonstrate the ability to independently research, analyze, and solve complex problems without reliance on generative AI tools.
Requirements / Qualifications
- Education: Bachelor degree in Analytics, Data Science, Business, Statistics, or a related field. Advanced degrees.
- 5+ years of hands-on experience as a Power BI Developer.
- Demonstrable expertise in data modeling principles and practices within Power BI, including understanding of relationships, cardinality, cross-filter direction, and M-query for data transformation.
- Strong proficiency in SQL, including extensive experience with all types of SQL window functions (e.g., analytic, ranking, aggregate, value, distribution functions).
- Experience in integrating outputs from machine learning models into Power BI reports and dashboards.
- Experience working with various data sources (SQL Server, Azure Synapse, Excel, SharePoint, APIs, etc.).
- Excellent analytical and problem-solving skills, with a keen eye for detail.
- Strong communication skills, with the ability to articulate technical concepts to non-technical stakeholders and provide clear requirements to data engineers.
- Ability to work independently and as part of a team, managing multiple priorities in a fast-paced environment.
- A strong commitment to independent work and problem solving, without reliance on generative AI tools.
About The Team
eClerx is a global leader in productized services, bringing together people, technology and domain expertise to amplify business results. Our mission is to set the benchmark for client service and success in our industry. Our vision is to be the innovation partner of choice for technology, data analytics and process management services. Since our inception in 2000, we've partnered with top companies across various industries, including financial services, telecommunications, retail, and high-tech. Our innovative solutions and domain expertise help businesses optimize operations, improve efficiency, and drive growth. With over 18,000 employees worldwide, eClerx is dedicated to delivering excellence through smart automation and data-driven insights. At eClerx, we believe in nurturing talent and providing hands-on experience.
Equal Opportunity Statement
eClerx is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status, or any other legally protected basis, per applicable law.
