FUJIFILM

Returning Candidate?

Report and Power BI Developer

Report and Power BI Developer

Requisition ID 
2017-1511
# of Openings 
1
Job Locations 
US-NY-Valhalla
Posted Date 
2/23/2018
Category 
Technical Services

More information about this job

Overview

FUJIFILM Holdings America Corporation is the holding company for North American based Fujifilm companies operating in 27 states and engaged in the research, development, manufacture, sale and service of Fujifilm products. The company serves a broad spectrum of industries in the U.S. including medical and life sciences, electronic, chemical, graphic arts, information systems, broadcast, and photography. For more information, please visit www.fujifilmusa.com. 

 

We are currently hiring for a Report and Power BI Developer.  The Report and Power BI Developer position will report to the Service Application Manager and be responsible for developing SSRS and Power BI reporting according with users requirements. This person will also be responsible for Administrating of the Power BI / Reporting environment (Creating / updating Data warehouse; Creating reporting Database). This person should be proficient in Power BI, web development techniques, delivery of the reporting solutions to the users, including their mobile devices, and possess deep understanding of multi-dimensional and tabular database modeling.  Within the first 6-9 months this person will understand the service business within FujiFilm and become familiar enough with DB architecture and details where they are able to design reports and dashboards on their own.  After 9 months the person will be able to handle customer requests without assistance from business analysts or technical leads.  

External US

Responsibilities:

(Including but not limited to)

  • Participating in project planning sessions with project managers, business analysts and users to analyze business requirements and outline the proposed solution
  • Design and develop different types of SSRS reports including: Drill through reports, Sub reports, Drill down reports based on business requirement
  • Administrating the BI and reporting environment
  • Enhance report performances by tuning the derived tables and join structures
  • Create data warehouse, databases and schema objects including tables, indexes, stored procedures and functions
  • Designing, developing and testing of the ETL strategy to populate the data from various source systems using SSIS
  • Understanding of database administration and performance tuning (SQL server security, query optimization, storage management, indexing, replication, backups, restores, monitoring production jobs)
  • Ability to provide on-call support on the rotation basis
  • Work closely with business departments and other IT areas
  • Work on projects within the IT and business teams to continuously drive operational and efficiency improvements
  • Deployment of software solutions, new and enhancement releases to production across multiple applications
  • Provide proactive support with a high degree of technical competency in accordance with the business requirements, standard working practices and processes of Fujifilm.
  • Routine application administration and maintenance tasks
  • Assist in project planning, scheduling and status reporting
  • Advise and act on corrective actions to stay on project schedule
  • Share knowledge and identify areas for, and contribute toward, improvement
  • Take full responsibility for all testing methodologies of software implementations

 

Required:

  • Bachelor’s or Associate’s Degree in computer science or equivalent certification with 5+ years in related fields.
  • Programming Experience:
    • SSAS, SSIS and SSRS, T-SQL, Stored Procedures, DAX, MDX
    • BI Multidimensional and Tabular model, ETL
    • Microsoft .NET C#, ASP.NET, VS2013 or above
    • HTML5, jQuery, JavaScript
    • MS Power BI, Excel
  • Databases:
    • Microsoft SQL Server 2012 and 2016 Standard and Enterprise

 

 

Desired:

  • 5 + years experience with SSRS reporting
  • Experience with Power BI reporting
  • 3+ years experience in Data warehouse design / creation with SSAS, SSIS and SSRS
  • Business background in service industry is a plus.
  • Experience and working knowledge of production system implementations

 

FUJIFILM is an equal opportunity and affirmative action employer.  All qualified applicants will receive consideration without regard to race, color, national origin, sex, gender identity, sexual orientation, religion, disability, protected veteran status or any other characteristic protected by applicable federal, state or local law.