Description
Must-Haves :
SQL Server Integration Services (SSIS) - 3 Years
SQL Server Reporting Services (SSRS) - 3 Years
SQL Server Analysis Services (SSAS) - 3 Years
Microsoft Business Intelligence (MSBI) - 2 Years
SQL Server databases - 4 Years
Additional Guidelines :
Work from office (4 days working from office and 1 day work from home)
Timings: 12.30 pm to 9.30 pm
Location – Mumbai Goregaon East, Nesco
Travel time should be max. 1 hour.
Interview Mode: 1R1 - Virtual and R2 - In-Person if local, If out of Mumbai will need to come for an In-person for final round on own expense
Good communication skills
Hiring Company Details:
Head Office- USA
Mumbai Office – Goregaon East
Domain- Accounts
It is an MNC
People Strength- 4K+
About the company: EisnerAmper is one of the largest accounting, tax, and business advisory firms, with nearly 4,000 employees and more than 400 partners across the world. We combine responsiveness with a long-range perspective; to help clients meet the pressing issues they face today and position them for success tomorrow. Our clients are enterprises as diverse as sophisticated financial institutions and start-ups, global public firms, and middle-market companies, as well as high net worth individuals, family offices, not-for-profit organizations, and entrepreneurial ventures across a variety of industries. We are also engaged by the attorneys, financial professionals, bankers, and investors who serve these clients. EisnerAmper (India) Consultants Pvt. Ltd. (“EA India”) is a subsidiary of Eisner Advisory Group LLC (“EA Group”), which practices in an alternative practice structure with EisnerAmper LLP. EA India employees provide advisory services to clients of EA Group and audit services to clients of Eisner Amper LLP and comply with the professional standards applicable to each of EA India, EA Group and EisnerAmper LLP. EA India employees also provide operational services to EA Group and EisnerAmper LLP. The policies and procedures of EA India, including obligations of confidentiality and non-disclosure, apply to all services provided by EA India employees. All applicants are applying to positions for employment with EA India, and not EA Group or EisnerAmper LLP.EA India opened its first office in Mumbai in 2007. Over the years, our India footprint has expanded to include offices in Bangalore and Hyderabad. We are a culturally diverse pool of over 500 professionals supporting our global clientele from a range of startups to Fortune 500 entities.
About the Vacancy:
Designation – Business Intelligence Developer
Experience required – 8-12 years
Reporting To: Manager
JOB SUMMARY:
Responsibilities:
Design and develop data ETL routines to integrate data from disparate source systems into an integrated business intelligence environment including defining source-to-target mappings, business rules and other required data transformations
Develop dashboards and reports using Microsoft Power BI, SSRS or other BI technologies.
Ensuring the quality of the data through utilization of process and technology
Participation in actively formulating and maintaining both a data catalog and a data dictionary
Providing data marts and data lakes to support business initiatives
Conduct business analysis to define the required data to fulfill on business requirements
Meet with Customers to understand business problems and questions, exploring options to model data driven platforms used for analysing answers
Become a trusted partner for Customers who translates business problems into analysis; then helps interpret the analysis into actionable steps
Actively participate in the design, development, and maintenance of complex BI Dashboards, Reports, Queries, and integrated applications
Manage other resources to complete the development work needed to deliver the required product to the client
Analyze and share results with users to ensure content meets business requirements; and train users to facilitate adoption and understanding of BI reports and toolsProactively initiate projects and analysis targeting opportunities for revenue growth, risk mitigation, and operational efficiency
Provide technical support of the Microsoft Platform Software
Comprehensive data analysis and design experience, with full knowledge of data warehouse & data mart methodologies as well analysis modelling
Lead solution and design sessions for end to end for data integration efforts
Deliver technical innovations in support of business growth;
progressing ideas from concepts to full scale implementation with focus on flexibility, reuse, and overarching extensibility.
Qualifications:
5-7+ years of experience in the Microsoft business intelligence platform, including SQL Server databases, SQL Server Integration Services, Power BI/SSRS & SSAS and/or Azure Cloud Services
5-7+ years of building and maintaining data integration processes
5-7+ years supporting large scale data integration and ETL processes including daily monitoring and operational support
Strong experience working in data warehouse architectures
Experience building formatted paginated reports using MS SSRS
Experience with PowerBI dashboard development or experience with one or more BI reporting tools like QlikView/QlikSense, Tableau, Micro Strategy, Open Source reporting is a plus
Experience with the PowerBI Cloud Services
Significant experience in the design and development of data integration solutions and data analysis
Expert in automating data integration routines
Expert in optimization of data integration processing and database design
Expertise in designing and developing dashboards, reports, analytics and data visualization solutions.
Experience in creating dimensional data models across multiple subject areas is a plus
Strong command of MS Excel
Experience and familiarity with processes, platforms, and stakeholders
Excellent written and oral communication skills
Excellent technical documentation skills
Ability to work independently in a fast paced environment with minimum over sight.
You would own building a future proof integration architecture to solve integration needs across projects.
Balances a variety of competing goals in a design, including project time, scope and budget constraints, and system performance, message verbosity, and loose coupling.
Optional:
Some experience with advanced analytics tools and languages such as R, Python, Scala, SAS, and others1-2+ years’ experience working in a DevOps environment and understanding of the associated tools and capabilities, and value of using this approach1-2+ years of cloud-based data platforms (such as Azure, AWS, Snowflake, …)1-2+ years using CI/CD (continuous integration/continuous deployment) methods for deployment1-2+ years using cloud data integration pipelines
Experience setting up and managing Power BI Report server is a plus.
Experience working in data lakes and reference data environments