SQL Developer SSIS / SSRS / SSAS

Company: TekPartners ( Learn More )

General Information
US-OR-Hillsboro
$65.00 - $75.00 /Hour
Not Specified
Contractor
Not Specified
Not Specified
False
False
Job Description

Title:  SQL Developer SSIS / SSRS / SSAS

Work Authorization: Citizen or Green Card Holder ONLY

Duration: 6-18 Months

Compensation: $65-75 hourly on W2 or C2C (Commensurate with experience)

SQL Developer SSIS / SSRS / SSAS  Overview The SQL Developer will play a critical role in the creation of an enterprise data warehouse. The role requires complete comprehension of enterprise data models and utilization of both relational and dimensional data sources. Responsibilities The SQL developer will: - Design, develop, and test ETL procedures - Design and implement data marts necessary to consume the data warehouse data - Perform detailed analysis of the data (via SQL) to confirm assumptions about the data - Participate in design workshops, providing technical insight and knowledge - Interpret written business requirements and technical specification documents - Create and maintain technical design documentation - Perform quality coding to business and technical specifications
Job Requirements

SQL Developer SSIS / SSRS / SSAS Technical Qualifications The ideal candidate will have the following technical characteristics. Required - Full understanding of the processes of data quality, data cleansing and data transformation - Full understanding of Extract Transform Load (ETL) concepts and technologies - Ability to write complicated yet efficient SQL queries and stored procedures (3-5 years of experience) - Advanced experience SQL Server (Including T-SQL & SSIS) (3-5 years of experience) - Modeling data by applying dimensional and star schema models with an understanding of the techniques used by both Kimball and Inmon - Knowledge of formal database architecture and design - Ability to interpret written requirements and technical specification documents - Ability to code software according to published standards and design guidelines - Advanced knowledge and use of Excel - A bachelor's degree in computer science, information systems, or a related discipline SQL Developer SSIS / SSRS / SSAS Nice to Have - Experience working with Postgres databases as source systems - SSAS Development experience

- Relational and Star Schema Design and Development.

- OLTP/ OLAP Data Model Functional Qualifications The ideal SQL Developer SSIS / SSRS / SSAS candidate would be described as follows. - Self-motivated with a sharp customer focus - Enthusiastic about learning large and complex systems - Detail-oriented with strong organizational, analytical and communication skills - Results-driven with the ability to take initiatives and meet deadlines - Able to multi-task in a fast-paced, dynamic environment

Title:  SQL Developer SSIS / SSRS / SSAS

Work Authorization: Citizen or Green Card Holder ONLY

Duration: 6-18 Months

Compensation: $65-75 hourly on W2 or C2C (Commensurate with experience)