Advanced Analytics Developer

**Your Journey at The team Starts Here:**

At The team, you can build a meaningful and rewarding career. With real flexibility to balance work with life moments, you’re trusted to deliver results and make an impact. We embrace you for who you are, care for your well-being, and nurture your career. Everyone has equitable access to opportunities for career growth and leadership. Over our 80-year history, delivering excellent service through innovation has been a core part of our DNA across our audit, tax, and consulting groups. That’s why we continuously invest in innovative ideas, such as AI-enabled insights and technology-powered solutions, to enhance our services. Join us at The team and embark on a career where you can help shape the future of our industry.

**Job Description:**

As a Data Analytics Manager at The team, you will provide critical solution development across a broad portfolio of external clients and industries. You retain a combination of functional knowledge and execution skills in leveraging SQL, SSAS, PySpark, Power BI, Tabular Editor, Microsoft Fabric, and other Microsoft BI stack products. Accounting or Finance background a huge plus. The ideal candidate will have a deep understanding of Business Intelligence processes and technologies, as well as experience with a variety of data sources, modeling techniques, and advanced visualizations. We prefer candidates with a strong client facing, consulting background and business accounting/finance acumen.

Additionally, you have strong critical thinking and analytical skills with a proven track record in executing solutions from planning to delivery. You understand basic agile methodologies and are committed to the continuous improvement of your solutions.

At The team, you will join the Data & Analytics Engineering team comprised of synergistic, high-functioning problem solvers that have extensive consulting and industry experience to drive solutions from strategy to execution. The team thrives on helping clients solve their complex business issues accurately, creatively, and expeditiously. As a member of the Data Analytics team, you will provide meaningful firm-wide contributions that uphold the team’s dedication to “One The team.” We strive for an unparalleled client experience and look to you to promote our success. Providing an excellent client experience, timely delivery, and communication are critical elements to success in this role.

Specific responsibilities include but are not limited to:

• The shift timings for this role is 5:00PM - 2:00AM IST (7:30AM - 4:30PM ET)
• Perform duties related to business analysis, such as scoping, documentation, project management, and related activities to establish an engagement blueprint
• Interface and communicate with subject matter experts of varied backgrounds to adequately assess business intelligence requirements and execution strategy
• Rapidly develop diverse POCs from various data sources and systems
• Clean, transform, and blend large and disparate data sources while leveraging SQL EDW, M, and DAX best practices
• Leverage Tabular Editor, ALM Toolkit, and DAX Studio to quickly and efficiently perform model operations across complex deliverables
• Perform ad-hoc data discovery using tools such as Power BI, SQL, or Excel
• Create visually stunning and salient reports using tools such as Power BI or Tableau (additional tools a major plus)
• Deploy, provision, and manage Power BI workspaces and deliverables
• Possess effective writing and communication skills for audiences of diverse business and technical backgrounds
• Work with data engineers and other stakeholders to define data requirements
• Balance multiple projects with attention to detail while meeting deadlines
• Continuously improve processes with advancements in the MS BI platform

Qualifications

• Master's or Bachelor's degree in a relevant field (such as Computer Science, Information Systems, Data Science, or a related discipline).
• 8+ years of experience in a data analyst, developer, architect, or similar position
• 7+ years of advanced experience with DAX, M, SQL, and Power BI
• 5+ years of experience in creating dashboards and deploying to clients
• 3+ years of experience in Power BI Service delivery and Admin role and responsibility
• 1.5+ years of experience in leveraging ETL SaaS tools (Talent, Stitch, Hevo, etc.,) or ADF Integration
• Expert knowledge of creating and optimizing dimensional models
• Strong leadership, team management, and communication skills.
• Ability to mentor and train junior ETL developers

• Solid understanding of software development life cycle models as well as expert knowledge of both Agile and traditional project management principles and practices and the ability to blend them together in the right proportions to fit a project and business environment
• Expert skills in Microsoft Excel and Outlook, strong skills in PowerPoint
• Strong track record of developing high-quality models on-premise and/or in the cloud
• Excellent client-facing and internal communication skills
• Excellent written and verbal communication skills
• Effectively managing multiple deliverables, clients, and projects in a fast-paced environment
• Knowledge of programming languages like SQL, Python, R, or Java.
• Familiarity with data governance, data security, and compliance.
• Solid understanding of software development life cycle models as well as expert knowledge of both Agile and traditional project management principles and practices and the ability to blend them together in the right proportions to fit a project and business environment
• Technical background, with understanding or hands-on experience in enterprise solutions for different industries
• High-level knowledge of BI architecture or data warehousing
• Excellent written and verbal communication skills
• Effectively managing multiple deliverables, clients and projects in a fast-paced environment
• Strong problem-solving skills and analytic