Job ID : 34633
Location : San Diego, CA
Company Name : Apollose
Job Type : Full-Time, Part-Time, Contract, Training
Industry : Information Technology
Salary : $31000 - $44000 per hour
No. of Positions : I have ongoing need to fill this role
Required Skills : Unit Testing, Debugging, Data Flow Diagramming..
Benefits : Medical Insurance, Dental Insurance, Vision Insurance, 401K, Life Insurance
Job Description :Qualifications:
- Four years of experience working with data warehouses.
- Three years of experience designing, implementing and maintaining normalized, operational data store, and dimensionally modeled database systems.
- Bachelor’s degree or equivalent work experience in Computer Science or a related discipline
- Strong experience using SQL including complex stored procedures, common table expressions, analytic functions, query optimization, and indexing.
- Working knowledge of data management and data warehousing technologies related to data modeling, database administration and performance tuning, archiving and disaster recovery.
- Experience building solutions with object-oriented languages.
Responsibilities:
- Build and maintain ETL and Data Warehouse objects.
- Participate in the transition from on-prem databases to cloud based solutions.
- Support legacy products based on the SQL BI Stack, Transactional Replication, MicroStrategy’s semantic model, and scripts written in PowerShell etc.
- Contribute to the design and optimization of our data layer as the company’s single layer of the truth.
- Translate business requirements into detailed, production-level technical specifications and data models.
- Contribute to our ETL framework by learning our current capabilities and leveraging your unique insights and experience.
Key Skills:
- Data Marts.
- Cubes.
- ETL.
- Quality Assurance/Quality Control.
- Software Development Lifecycle Management.
- Unit Testing.
- Debugging.
- Data Flow Diagramming.