SQL SERVER ETL AND DATA WAREHOUSE DEVELOPER
SQL Server ETL and Data Warehouse DeveloperSan 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:
Bachelors 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