Data Analytics Warehouse Developer

Data Analytics Warehouse Developer

02 Nov 2021
Texas, San antonio, 78205 San antonio USA

Data Analytics Warehouse Developer

job summary:

We are looking for a Data Analytics warehouse developer for a permanant hire role with one of our premier clients in the San Antonio area. This individual develop enterprise data warehouse system. Develop ETL layer including SSIS processes / Stored Procedures / SQL to support the data warehouse system. Develop views/tables/triggers and necessary objects. Work closely with the Artitect.



location: San Antonio, Texas

job type: Permanent

salary: $80,000 - 90,000 per year

work hours: 8am to 5pm

education: Bachelors



responsibilities:

- Develop enterprise data warehouse system.


- Develop ETL layer including SSIS processes / Stored Procedures / SQL to support the data warehouse system.


- Develop views/tables/triggers and necessary objects.


- Migrate databases on older version to new version


- 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' experience with data hosted in Microsoft SQL server environments and related technologies


- strong experience with SSIS / SSRS and preferred experience with MDM - Master data management components


- strong experience with ODS layer and Kimball or Randolf Data warehouse development approaches


- Experience with SQL performance tuning and code optimization.


- Knowledge on Data cleansing / Data profiling and Data governance


- Knowledge on Data science / Statistical analysis / SPSS is a plus






qualifications:


  • Experience level: Experienced
  • Minimum 3 years of experience
  • Education: Bachelors


skills:
  • SQL (4 years of experience is required)
  • SSIS and SSRS (2 years of experience is required)
  • Data Warehouse
  • SSRS
  • DEVELOPER
  • Database Developer
  • 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

Job Details

  • ID
    JC5436534
  • State
  • City
  • Job type
    Permanent
  • Salary
    USD $80k - 90k per year 80k - 90k per year
  • Hiring Company
    Randstad Corporate Services
  • Date
    2020-11-02
  • Deadline
    2021-01-01
  • Category

Jocancy Online Job Portal by jobSearchi.