This job has expired, please see additional jobs below
Data Infrastructure Developer
First Republic Bank
San Francisco, CA, United States
Job Details - this job has expired, please see similar jobs below
Overview
This 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.
Responsibilities
• o 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 ShareP
◦ Develop reports and dashboards using reporting services (SSRS), OLAP cubes (SSAS) and relational databases.
◦ The ability to 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
◦ Support IT staff and business users in the development, usage and troubleshooting of database-driven applications
◦ 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.
Qualifications
Additional Duties and Responsibilities:
• Attends meetings as required.
• Supporting production reporting systems.
• Perform other duties when assigned.
• Adhering to and complying with the applicable, federal and state laws, regulations and guidance, including those related to Anti-money laundering (i.e. Bank Secrecy Act, US Patriot Act etc.)
• Adhering to Bank policies and procedures
Experience/Skills Required:
• Requires 10+years of progressive experience in developing and supporting data and reporting projects.
• Requires 5+ years of in-depth experience using Microsoft stack of ETL and BI tools including SSIS, SSRS and SSAS
• Expert Microsoft SQL Development (T-SQL) and Microsoft SSIS Development (2005, 2008, 2012)
• Advance 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.
• Demonstrated experience building cubes and reports that take advantage of OLAP/Dimensional Modeling
• Requires experience with Reporting and Dashboards including BI data modeling and architecture in financial services industry.
• Requires experience in data warehousing practices including dimensional modeling skills.
• Experience with Informatica suite of tools – Power center, IDQ, Metadata, MDM etc is nice to have.
• Experience in Financial services is required, banking is nice to have.
• Must possess excellent written and oral communications skills and the ability to clearly define projects, objectives, goals, schedules and assignments.
• Requires strong analytical skills and excellent attention to detail.
Education Requirements:
• Four-year college degree preferred with an emphasis in a computer related field or the equivalent skill, knowledge and mental development