SSIS/SSAS/SSRS ETL developer - Banking

Location: San Francisco, CA
Job title: SSIS/SSAS/SSRS ETL Developer - Banking
Location: San Francisco, CA (Local candidates only)
Contract position

Job description:
Position focuses on the development and delivery of data warehousing and business intelligence solutions including: cubes, dashboards, scorecards, reports, user interfaces, and associated data structures using Microsoft applications and tools. The ETL Developer interfaces with stakeholders to understand their needs and then translates them into solutions which deliver business value.
-Design and develop data movements using SSIS and stored procedures.
-Enable data usage for business users via SSAS cubes by utilizing MDX, DAX, Power pivot and SharePoint.
-Develop reports and dashboards using reporting services (SSRS), OLAP cubes (SSAS) and relational databases.
-Iteratively develop reporting and data solutions in an agile fashion.
-Build, Optimize existing and expand Cubes to support business reporting needs using SSAS and SSIS.
-Follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes
-Collaborate with IT operations and testing organizations to ensure timely releases of projects and make sure database environments are sustainable, code migrations to production.
-Create ad-hoc queries and reports as requested and provide on-going analytical support for these requests.
-Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements
-Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) for all projects.
-Use customer requirements to improve functionality (speed, performance / usability).
-Respond quickly to bug fixes and enhancement requests and be able to take directions and complete tasks on-time with minimal supervision.
-Ensure compliance with applicable, federal and state laws, regulations and guidance, including those related to Anti-money laundering, as well as Bank policies and procedures.
-5+ years of progressive experience in developing and supporting data and reporting projects.
-In-depth experience using Microsoft stack of ETL and BI tools including SSIS, SSRS and SSAS.
-Advanced knowledge of performance tuning related to ETL Development.
-Strong experience with Source Control (VSS, TFS, Subversion, etc.)
-3+ years maintaining production SSAS and SSIS processes supporting a broad set of business users.
-Strong analytical skills and excellent attention to detail.
-Experience building cubes and reports that take advantage of OLAP/Dimensional Modeling capabilities.
-Experience with Reporting and Dashboards including BI data modeling and architecture in financial services industry.
-Experience in data warehousing practices including dimensional modeling skills.
-Financial services knowledge is preferred.
Education: Degree in Computer Science or technical subject preferred
Warmest regards,
Aileen Bradley
Addastaff Consulting, Inc.
Senior Technical Recruiter
650-638-9633 x303

this job portal is powered by CATS