Job Description :
Local or nearby MSBI Developer Princeton NJ Exp 10years
Location – Princeton ,NJ
Duration – Long term
Client : ETS
Local or nearby who can attend F2F interview.
Updates post manager meeting
Primary Skill -MS BI Power BI, SSIS, SSAS, SSRS ( In order of preference) SQL Server ( Tuning/Queries)
Secondary Skills - Oracle
role requires end to end of SDLC from requirement gathering to developing and implementing, need excellent comm skills, with hands on and Leading the effort, this is not a Team lead role,
Phone followed by Inperson interview, Phone interview to start next onwards, final round will be inperson interviews
Lead and mentor teams of other Enterprise BI staff to solve technical BI solutions with little or no supervision
2. Lead the activities of providing BI solutions, developing project plans, monitoring progress, and resolving issues
3. Provides consultation and knowledge transfer to peers and internal contacts as a Subject Matter Expert (SME) in the administration and new development using MSBI and Power BI
4. Provides technical expertise to design business solutions using acquired knowledge and experience related to MSBI and Power BI
5. Provide MSBI and Power BI administration including install, configure, control failover and load balancing across multiple servers and maintain security
6. Plan/drive Business Intelligence project deliverables for the entire ETS organization using MSBI and Power BI as a BI tool.
7. Performs application code migrations.
8. Trouble-shoots hardware and software problems as they apply to design, implementation, or installation activities.
9. Schedule and coordinate infrastructure maintenance activities including such items as hardware and software upgrades and maintenance.
10. Consult with ETS business community to gather requirements for specific BI scorecard, dashboard and reporting needs; write detailed specifications to be used in developing reports and processes.
11. Design and develop scorecards, dashboards and multi-dimension data cubes using MSBI and Power BI
12. Consult with end users to refine/enhance existing BI applications
13. Participate in the design and development of enterprise wide data repositories; make recommendations to improve the efficiency and functionality of the database, MSBI and Power BI environment and associated processes.
14. Develop and deliver reports on an ad-hoc basis using MSBI; develop and execute a verification and security strategy to ensure the accuracy of the data distributed in the reports
15. Function as the enterprise MSBI administrator ensuring performance and security is compliant
16. Assist management in attaining problem resolutions, working with multiple ETS BI partner groups and multiple levels of staff and management.
Process Outputs and Deliverables (From the key responsibilities above, describe the most important process outputs of the role)
High performance scorecards, dashboard and BI applications in concert with sponsors business requirements and commitments.
Highly available server infrastructure.
Production service level agreements met
Implementation of ad-hoc data requests (adhering to data security policies)
Education, Certifications, or Special Licenses:
Bachelor’s degree, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired is necessary.
Relevant Years of Experience Required:
8 to 10 years of related experience in IT or a related field
Other Requirements (Specialized skill sets, behavioral/technical):
Must be able to work independently with excellent organizational and communication skills
Ability to lead and mentor teams
Excellent verbal, written and interpersonal communication skills
In depth knowledge of MSBI tools and creation of dashboards