Job Description :
Candidate with 5 years of experience required in the field of Business intelligence
The candidate will be responsible for the design, development, implementation and maintenance of a data warehouse and associated dashboards to be used for reporting and analytical purposes against transactional databases in a variety of environments.
The candidate should possess expert level data mining/modeling skills and a deep understanding of OLTP and OLAP database design.
Candidates must have extensive experience with SQL Server 2012 or higher version including SSIS
Candidate must have experience working with reporting tools such as IBM Cognos BI.
Strong SQL skills required with experience in stored procedures and functions
Sharepoint office 365 environment exposure is preferred
Experience working with QAD / KBM environments is preferred
Bachelor’s degree or higher required in the field of computer science, electrical engineering or related fields.
Typical Job responsibilities
Build jobs using SSIS and help migrate our existing Data Manager ETL jobs to SSIS
Write appropriate stored procedures and functions to support our Data warehouse initiatives
Develop IBM Cognos BI reports and dashboards based on user requests
Handle the development to production lifecycle for ETL jobs and BI reports
Provide user support as needed