CDI Corporation SQL ETL - Data Programming in Brier, Washington
This role will be responsible for designing, building and maintaining databases for a fast paced reporting team. They will have the ability to work with large and complex volume data sets and must have a clear understanding of the full database systems. This position demands both business analysis and reporting expertise with ownership of the business need for data quality assurance processes required to support critical business intelligence initiatives. 8+ years of experience in SQL programming in T-SQL building stored procedures and jobs 5+ years data integration and ETL experience with SQL Server Integration Services (SSIS) or other industry leading tools including ability to configure SQL Server agent 5+ years of experience in designing and developing ETL processes including naming conventions, connection to variety of systems and processing of large volume of data 5+ years of experience in identifying and mapping data elements across multiple systems including creating templates and best practices to maintain the mapping information Strong understanding of data integration, quality and validation Experience with SQL Reporting Services (SSRS) and Reporting tools (Excel, PowerPivot) 4+ years of experience extracting data from Salesforce.com database objects using API calls via SSIS, DataLoader, and other ETL tools; familiarity with SOQL (Salesforce SQL) Understanding of MDM, Data warehouse / Data mart Experience with SQL Server in a VMWARE or AWS environment Experience moving data across different types of databases Excellent performance tuning and TSQL skills SQL Automation experience Good with Data Warehousing Concepts 2-3 years of Tableau experience Excellent written and verbal communication skills and be able to interact with multiple IT teams and business partners both formally and informally Preferred: Clear understanding and experience with Microsoft platforms, including Windows operating systems for both desktop and server. Knowledge of physical database administration with SQL Server a plus Experience in logical and physical data modeling Employer's Job# BBBH356255 Please visit job URL for more information about this opening and to view EOE statement.