Business Intelligence (BI) Specialist

Location: Hauppauge, NY
Date Posted: 02-02-2018
The Business Intelligence (BI) Specialist is responsible for the design, development, implementation, management and support of mission critical enterprise BI reporting and Extract, Transform, Load (ETL) processes and environments.
         Proven experience analyzing data for the purposes of developing dashboard reporting;
         Proven experience working with business users to developing requirements documentation;
         Proven experience working with a wide array of RDBMS’ including Microsoft SQL Server, Microsoft Access, Oracle, Progress, and MySQL;
Proven experience developing extraction, transformation and load (ETL) routines to populate data warehouse and data marts
Responsibilities:
·         Business analysis to gather required BI system requirements
·         Translate business requirements into specifications that will be used to drive data store/
·         data warehouse/ data mart design and configuration
·         Use ETL tools to load data store(s)/ data warehouse(s)/ data mart(s).
·         Transition developed BI systems to the Operations & Support team
·         Provide support as required to ensure the availability and performance of enterprise data
·         and BI environments for both external and internal users
·         Ensure proper configuration management and change controls are implemented for your
·         sphere of influence
·         Provide technical assistance and cross training to other team members
·         Design and implement technology best practices, guidelines and repeatable processes
·         Must be able to perform duties with moderate to low supervision
Required Qualifications:
·         5+ years’ experience implementing enterprise-scale reporting systems
·         Extensive use of SQL and RDBMS systems (DB2, Oracle, SQL Server, etc.)
·         Extensive experience with data warehouse implementations
·         Strong knowledge of logical and physical data modeling concepts
·         Demonstrated ability with ETL tools. Familiarity with Informatica is a plus.
·         Performance tuning experience required
·         Excellent interpersonal (verbal and written) communication skills are required to support
·         working in project environments that includes internal, external and customer teams
·         Requires strong analytical, conceptual and problem-solving abilities
·         Functional knowledge of the Sisense Business Intelligence technology stack;
·         Proven experience developing business intelligence reports in Sisense
·         Ability to manage multiple priorities, and assess and adjust quickly to changing priorities
·         Requires leadership qualities to mentor junior members of the team.
 
Education Required:
·         BA/BS in Computer Science or related field is preferable. Equivalent combination of experience, education and training will be considered
·         Certifications Required: BI certifications desirable
or
this job portal is powered by CATS