02 Nov
Business Intelligence Analytics Developer
Texas, San antonio , 78205 San antonio USA

job summary:We are looking for a Business Intelligence Analytics developer for a permanant hire role with one of our premier clients in the San Antonio area. This individual will design and Develop an enterprise Data Analytics solution. Develop ETL layer including SSIS processes / Stored Procedures / SQL to support the data warehouse system. Develop views/tables/triggers and necessary objects. location: San Antonio, Texasjob type: Permanentsalary: $70,000 - 80,000 per yearwork hours: 8am to 5pmeducation: Bachelors responsibilities:- Develop ETL layer including SSIS processes / Stored Procedures / SQL to support the data warehouse system. - Develop views/tables/triggers and necessary objects. - Develop reports using IBM Cognos Report studio. - Develop Cognos Framework manager model - Integration of Cognos with Salesforce.com - Create Source- Target mapping documents and work closely with the Architect - Create Data flow diagrams / ERD diagrams and help develop optimal Data modelling solution - Support daily /weekly and monthly ETL jobs and resolve/ fix any issues - Maintain an incident log and research areas that can improve performance. Requirements- - At least 4-5 years of experience working with IBM Cognos Report studio / Analytics suite of products. - At least 2-3 years' experience with data hosted in Microsoft SQL server environments and related technologies - At least 2-3 experience with SSIS / SSRS or other similar ETL tools - Experience with Cognos Administration, Cognos Analytics and SQL Server. - strong experience with ODS layer and Kimball or Randolf Data warehouse development approaches - Experience with SQL performance tuning and code optimization. - Knowledge on Tableau and Sales Force application. - Knowledge on Data science / Statistical analysis / SPSS is a plus qualifications:

  • Experience level: Experienced
  • Minimum 2 years of experience
  • Education: Bachelors
skills:
  • SQL (2 years of experience is required)
  • SSIS (2 years of experience is required)
  • SSRS (2 years of experience is required)
  • IBM Cognos Report studio (4 years of experience is required)
  • Cognos Administration
  • Kimball or Randolf
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.


Related jobs

Report job