Data DeveloperIDEALFORCE has a contract position available immediately for a Data Developer to join our customer in Phoenix, AZ. Please find below additional details about this job. Kindly respond with your most up to date resume if you would like to pursue this opportunity.
Client is considering only LOCAL CANDIDATES for this role at this time.Job DescriptionThe candidate will develop solutions using SSIS, SSRS, SSAS and T-SQL in support of the Agencies business process and reporting requirements. Preferred candidate will be investigative/detective oriented, detail oriented, problem solving, and have an understanding of the power of data and criticality of its quality.Develop ETL solutions using SQL Server Integration services (SSIS)Develop reports using SQL Server Reporting Services (SSRS)Develop cubes using SQL Server Analysis Services (SSAS)T-SQL coding, create database objects for both OLTP and OLAP databasesPerforms impact analysis on change requestsAssists in documenting technical requirementsParticipates in all phases of software development and maintenance lifecycleSupport defect analysis and resolutionAssist the ETL team in the design of efficient processes to load and manage the data, including a Data Quality Assessment to ensure the quality of the source data will meet the information requirements, developing Business Rules, Data Mappings, and Transformation RulesParticipate in and document data mapping sessionResponsible for maintaining a formal description of the data and data structuresAssist the Lead Database Architect implementing data architecture principles to align and conform business capabilitiesAssist in supporting multiple SQL Server data repository, which may include documenting database architecture and analyzing datasets to identify missing, incomplete, or invalid informationQualifications• BS Degree CS or MIS or equivalent experience in related roles• 3 or more years or experience working with relational databases• Minimum 3 years of experience in SQL Server 2008/2012 T-SQL coding• 2 or more years of experience with SSIS• 2 or more years of experience with SSRS• Experience with SSAS and dimensional data models preferred• Working knowledge of Team Foundation Services 2012• Demonstrated ability to use discretion and make sound decisions• Ability to excel in a collaborative and distributed team environment• Ability to work with a minimal amount of direction while being pro-active in keeping their management informed of project related issues• Ability to work under pressure• Ability to respectfully question ideas and share a point of view with others in support of the business requirements and needs• Ability to effectively communicate with various levels of employees ranging from entry level to senior leadership• Ability to work on multiple projects at the same time and shift priorities quickly• Experience working on an Agile/Scrum team preferred• Proven strong problem-solving skills, troubleshooting, and root cause analysis• Excellent written and verbal communication skills• Strong aspiration to learn new technologies• Proven strong relationship-building and communication skills with team members and business users• Ability to maintain confidentiality• Experience in the education industryAdditional Information- "All your information will be kept confidential according to EEO guidelines". - All candidates who are authorized to work in US are encouraged to apply.
- Candidates must clear the Background check prior to commencing the assignment.