Job Description :
MS BI Developer - F2F Interview - W2 or 1099 Only STZ 6698
Phoenix, AZ
Long term

Job Description:
W2 or 1099 only; no c2c - F2F Interview required - Reasonable expenses will be paid for f2f*
Responsibilities
Builds data transformations with SSIS including importing data from files, moving data from one database platform to another; helps build star schema data marts.
Ability to write reports using Microsoft SQL Server Reporting Services (SSRS)
Strong knowledge of relational databases, as well as skills in SQL query design and development.
Collaborates with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
Gathers business requirements and works with data analysts on physical database design and modeling.
Performs code reviews, analyzes execution plans, and re-factors inefficient code.
Follows data standards, resolves data issues, completes unit testing and system documentation for Extract Transfer Load (ETL) processes.
Conducts system tests and root cause analysis, troubleshoots customer issues and corrects database defects, responding quickly to bug fixes and enhancement requests.
Follows change management process to resolve application defects or to implement development enhancements.
Provides assistance with ETL standards and design for future supportability and ease of enhancements.
Assists with the creation of reusable components as they relate to the ETL framework.
Assists with the management of ETL scalability and system management.
Creates technical documentation of design logic and ETL processes based on technology best practices, guidelines and repeatable processes.
Helps prepare and run unit, integration, UAT, regression, stress and performance plan documents and tests while documenting results.
Analyzes day-to-day functions and processes to ensure they are performing within predetermined guidelines, limits, and specifications.

Job Requirements

Bachelor''s degree from a four-year college or university in the field of computer science, information science, management information systems, or related areas of study
4+ years of SSIS developer experience required.
Experience working on BI/DW projects designing, developing, testing and troubleshooting SSIS/SSRS packages that implement complex ETL financial services processes.
Experience with data modeling tools
Strong analytical ability and aptitude to derive and translate data designs from business concepts.
Has a deep awareness of all aspects of ETL.
Understands and quickly learns business concepts, functions, processes and activities
Ability to effectively prioritize and execute tasks in a high-pressure environment.
Ability to conduct research into systems issues and products as required.
Proven creative problem-solving abilities.
Ability to communicate ideas to technical and non-technical audiences.
Logical, efficient, and proactive.
Highly self-motivated and directed.
Keen attention to detail.
Strong customer service orientation.
Experience working in a team-oriented, collaborative environment.
Experience in data mining or analytics.
Certifications are highly preferred, but not required: MCSA SQL Server 2012 Certification; and/or MCSE Business Intelligence.