Assistant Manager

ExlService Holdings, Inc.; New York (NY); On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Mentoring program

Opportunities for professional growth

Fast-paced innovative environment

Job summary

A leading analytics company based in New York is seeking an Analytics Assistant Manager/Power BI Developer. The role emphasizes managing end-to-end project delivery and requires developing sophisticated dashboards and solutions using Power BI. Candidates should have 3.5-6.5 years of relevant experience, with strong skills in SQL and Power BI. Ideal candidates will possess a degree in a related field, and familiarity with analytics tools like Alteryx and cloud environments is preferred. The position offers a dynamic work environment focused on innovation and professional growth.

Qualifications

• 3.5-6.5 years of relevant experience preferably in analytics.
• Experience with data flows, ETL flows over Power BI.
• Knowledge in cloud data environments like Snowflake is preferred.

Responsibilities

• Develop visual reports, dashboards, and KPI scorecards using Power BI.
• Connect Power BI to different data sources and transform data per project requirements.
• Collaborate with business teams to translate requirements into technical solutions.

Skills

SQL

Power BI

Data visualization

Data analysis

ETL Processes

DAX

Education

Bachelor's/Master's degree in computer science/engineering or related areas

Tools

Microsoft SQL Server BI Stack

Alteryx

Job description

- Experience (In Years) 0-3## Job DescriptionAnalytics/Assistant Manager/Power BI Developer ;EXL (NASDAQ:EXLS) is a leading operations management and analytics company that helps businesses enhance growth and profitability in the face of relentless competition and continuous disruption. Using our proprietary, award-winning Business EXLerator Framework, which integrates analytics, automation, benchmarking, BPO, consulting, industry best practices and technology platforms, we look deeper to help companies improve global operations, enhance data-driven insights, increase customer satisfaction, and manage risk and compliance. EXL serves the insurance, healthcare, banking and financial services, utilities, travel, transportation and logistics industries. Headquartered in New York, New York, EXL has more than 24,000 professionals in locations throughout the United States, Europe, Asia (primarily India and Philippines), Latin America, Australia and South Africa. ;EXL Analytics provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting edge analytics techniques and a consultative approach. Leveraging proprietary methodology and best-of-breed technology, EXL Analytics takes an industry-specific approach to transform our clients’ decision making and embed analytics more deeply into their business processes. Our global footprint of nearly 2,000 data scientists and analysts assist client organizations with complex risk minimization methods, advanced marketing, pricing and CRM strategies, internal cost analysis, and cost and resource optimization within the organization. ;EXL Analytics serves the insurance, healthcare, banking, capital markets, utilities, retail and e-commerce, travel, transportation and logistics industries. ;Please visit ;www.exlservice.com ;for more information about EXL Analytics. ;Role Overview: ;Emphasis is on managing end to end project delivery.Structure analytical solution to address business objectives and problem solving.Translate stated or implied client needs into researchable hypotheses.Develop sophisticated dashboards and solutions to incorporate complex client requirements and enhance UX.Facilitate client working sessions and lead recurring project status meetingsDevelop long-lasting, trusted advisor relationships with clientsAble to work in dual shore engagement across multiple time zonesManage business uncertaintySecure new opportunities within existing account relationshipAssess customer needs, pain points, behaviors, activation levers, headroom for growth, value propositions, etc.Manage day-to-day project operations, serve as the functional and domain expert on the project team to ensure that they meet client expectationsProvide quality oversight on deliverables prepared by the project team before submitting to client ; ; ;Responsibilities: ;Develop visual reports, dashboards and KPI scorecards using Power BI desktopConnect Power BI to different data sources, import data and transform data per project requirementsShould be able to create data flows, complex data flows and ETL flows over PBIShould be able to write SQL queries and well-versed with database fundamentals such as multidimensional database design, relational database design, and moreProficient in creating complex ;DAX queries, Power Query, bookmarks and SQLImplement row level security on data and understand application security layer models in ;Power BI, develop tabular/multidimensional models that are compatible with warehouse standards using M-QueryUnderstand cloud data environment (Snowflake knowledge is preferred)Adept in developing, publishing, maintaining, and scheduling Power BI reports and to visualize various trends as per the business requirementsBe able to troubleshoot, do enhancements on existing reports and create new dashboards ;Candidate Profile: ;Bachelor’s/Master's degree in computer science/engineering, operations research, or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcomed to apply3.5-6.5 years’ relevant experience preferably in analyticsDesign, develop and maintain Alteryx workflows for ETL, automation and data processing.Collaborate with business teams to understand requirements and translate into technical solutions.Integrate Alteryx with database, API and BI tools.Should be able to handle complex data queries/client requirements with hands on experienced on tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI, Power Query, Power Pivot and DAX for successfully designing, modelling, and implementing end to end power bi solutionsInvestigate & troubleshoot Power BI reports and data models including investigation of data issues, data validation and balancing, fix developed automated reports and dashboards.Maintain and create Power BI dashboards from scratch with enhanced customer/end-user experience with inclusion of story boards, smooth navigation and best in class visuals.Insurance Industry knowledge preferredOutstanding written and verbal communication skillsAble to work in fast pace continuously evolving environment and ready to take up uphill challengesIs able to understand cross cultural differences and can work with clients across the globePreferred Notice Period: 15-30 Days ; ; ;What we offer: ;EXL Analytics offers an exciting, fast paced and innovative environment, which brings together a group of sharp and entrepreneurial professionals who are eager to influence business decisions. From your very first day, you get an opportunity to work closely with highly experienced, world class analytics consultants.You can expect to learn many aspects of businesses that our clients engage in. You will also learn effective teamwork and time-management skills - key aspects for personal and professional growth ;Analytics requires different skill sets at different levels within the organization. At EXL Analytics, we invest heavily in training you in all aspects of analytics as well as in leading analytical tools and techniques.We provide guidance/ coaching to every employee through our mentoring program wherein every junior level employee is assigned a senior level professional as advisors.Sky is the limit for our team members. The unique experiences gathered at EXL Analytics sets the stage for further growth and development in our company and beyond. ; ;