Data Warehouse Associate LOC : San Francisco CA

100,000 - 200,000

Job Description:

Job description

PRIMARY RESPONSIBILITIES:

  • Provide technical and systems design expertise in the development of new and maintenance of existing databases and data warehousing facilities.
  • Manage data and data warehouse accuracy, quality and integrity.
  • Design and build ETL workflows resulting in either a systems integration and / or business intelligence source table from multiple data sources.
  • Provide detailed analysis, design, tuning, testing, implementation and documentation of the data warehouse and/or business intelligence systems.
  • Ability to translate business requirements into technical solutions leveraging existing systems and automation.
  • Develop and define business reporting dashboards and requirements.
  • Responsible for data warehouse / business intelligence quality testing, stakeholder approval and user acceptance testing.
  • Develop and maintain technical specification documentation for all reports and processes.
  • Conduct periodic analysis of infrastructure and application performance and contributes to the strategic technology plan.
  • Provide support for and implement data driven technologies and platforms such as workflow and CRM tools.

QUALIFICATIONS:

  • 3-6 years experience with data warehouse or business intelligence technologies and concepts.
  • Experience analyzing very large, complex, multi-dimensional data sets with the ability to pull together compelling narratives.
  • Experience creating and defining data architectures and metadata definitions.
  • Fluent in SQL and relational database, familiarity with Big Data technologies is a plus.
  • Experience with Salesforce and software development lifecycles is preferred.
  • Experienced in report analysis and development using business intelligence tools a plus.
  • Outstanding grasp of technology concepts and processes.
  • Experience in private equity, venture, or trading environments a plus.
  • Highly motivated, self-driven, solution and detail oriented individual with the desire to work in a fast-paced, entrepreneurial environment.


Share Profile