Job Description :
Position : Lead BI Developer

Location: Princeton, NJ

Duration: 6 mos initial assignment with expected extensions

Additional Notes from HM
Provides backend data warehousing, data solutions to the BI Teams
- Lead Position – (Coding – 100% Coding) (Front-End)
Engage with the Business itself. This person needs to be able to lead initiative, understanding business requirements, divide metrics and build a solution
Experience in ETL, Visualization, PowerBI, Qlikview, Tableau
Team is 18 People (More on the Backend, than the Front end which is why he’s looking for a BI lead) (5 are ETS Employees/ 13 are Contractors)
They are a Microsoft Site – SSIS, SSRS, PowerBI
Drive Back-End: Must have to understand the SSIS backend, ETS, Oracle Backend Database environment, 70% of backend systems are in Oracle, Uses a lot of Microsoft Stack, Data Mirroring, Migrate over to AWS Cloud next year

Interviews/Resume Feedback on Candidates:
4-5 weeks have been interviewing, majority issues are they are technical, front end engagement, not as much. They don’t know how to engage with a client or consulting type engagement to determine needs of the customer
More on the backend, than on the visualization, tableau etc.
Communication Skills- needs to be a very good communication (Managing the backend as well as communicating with Customers)

Interview Process:
Phone IV – then next round with other members of the team (Face to Face or WebEx)
Will be making a selection soon. Closing out the req this week – needs candidates in ASAP

Responsibilities
Responsible for the administration of the MSBI Infrastructure and provides 24x7 availability of the Enterprise Business Intelligence.
Perform software upgrades, performance monitoring, system tuning, upgrades and infrastructure management.
Actively provide BI solutions, developing project plans, monitoring progress, and resolving issues
Provided consultation and knowledge transfer to peers and internal contacts as a Subject Matter Expert (SME) in the administration and new development using MSBI
Provides technical expertise to design business solutions using acquired knowledge and experience related to MSBI
Provide MSBI administration including install, configure, control failover and load balancing across multiple servers and maintain security
Plan/drive Business Intelligence project deliverables for the entire organization using MSBI as a BI tool.
Performs application code migrations.
Trouble-shoots hardware and software problems as they apply to design, implementation, or installation activities.
Schedule and coordinate infrastructure maintenance activities including such items as hardware and software upgrades and maintenance.
Consult with business community to gather requirements for specific BI scorecard, dashboard and reporting needs; write detailed specifications to be used in developing reports and processes.
Design and develop scorecards, dashboards and multi-dimension data cubes using MSBI
Consult with end users to refine/enhance existing BI applications
Participate in the design and development of enterprise wide data repositories; make recommendations to improve the efficiency and functionality of the database, MSBI environment and associated processes.
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
Function as the enterprise MSBI administrator ensuring performance and security is compliant
Assist management in attaining problem resolutions, working with multiple BI partner groups and multiple levels of staff and management.
Adhere to ethical standards and comply with the laws and regulations applicable to your job function.
Develops and documents BI coding and naming standards, templates and metadata.
Ensures BI environment is optimized to address business requirements by designing and creating tables, diagnosing and repairing user and performance issues, and testing, monitoring and tuning software.
Education Required
Bachelor’s degree, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired is necessary.
             

Similar Jobs you may be interested in ..