Position Details

SQL SERVER ETL AND DATA WAREHOUSE DEVELOPER

SQL Server ETL and Data Warehouse Developer
San Diego, CA 92122 (UTC by the mall)
Direct Hire
Salary is 100k + 20% bonus

Required Technology/Skills:
• Microsoft SQL Server 2005\2008R2 or later
• Complex T-SQL
• ETL
• SSIS in Microsoft Visual Studio or BIDS
• SSRS
• Strong knowledge of data and the unique challenges experienced with working large data sets (100s of millions or billions)
• Strong background in data analysis
• Firm grasp of relational database theory, data modeling and data warehousing best practices

Desired Technology/Skills:
• Bachelor’s Degree in Computer Science or Similar
• Microsoft professional certifications

Responsibilities:
• Design and create databases, star schemas, fact and dimension tables
• Ensure that data warehouse and operational data store have appropriate data and are optimized
• Develop logical and physical data flow models for ETL applications; translates data access, transformation and movement requirements into functional requirements and mapping designs
• Plan and conduct ETL unit and development tests; monitor results and take corrective action, when necessary
• Oversee basic and advanced transformation activities such as normalization, cleansing, aggregation, summarizing, and integration
• Design automation processes to control data access, transformation and movement; ensures source system data availability and update accessibility, data integrity, restorability and appropriately handles errors, in a time sensitive manner
• Collect, extract, and analyze data stored in the Enterprise Data Warehouse via T-SQL, SSRS, Excel, and other various Microsoft BI tools
• Research and recommend technology solutions related to data storage, reporting, integrations and other areas
• Work with Business Analysts to translate data requirements into logical data models
• Troubleshoot issues related to the enterprise data systems

Company is an established, quickly growing, non-traditional, financial company.

Click here to send us your resume