LakeForestRecruiter Since 2001
the smart solution for Lake Forest jobs

Database Analyst

Company: Irvine Technology Corporation
Location: Lake Forest
Posted on: November 17, 2021

Job Description:

*NEW* Database AnalystDatabase AnalystAccountabilities:

  • Gathering and analyzing data on the data warehouse (80%)
    • Understanding data elements needed for the Data Warehouse and dashboards from disparate sources (including Google Analytics, Sitecore, netForum, miniPeak, and other sources of data)
    • Creating transformation algorithms to convert the data sources to Data warehouse consumable elements
    • Analyzing data for the data warehouse (which is a consolidation of inputs including Google Analytics, Sitecore, netForum, miniPeak, and other sources of data) for use for business line dashboards.
    • Work with developers to provide the necessary data for website applications (stored procedures) (10%)
    • Help manage taxonomy across the digital platforms including Digital AssetManagement system, Sitecore, Engagement, Data Warehouse, Information Architecture, (10%) Functions:
      • Design/develop reports and applications using SQL, SSIS, Power BI, SSRS and other technologies
      • Develop algorithms for forecasting and predictive analytics purposes
      • Gather and analyze data on the data warehouse
      • Use SSAS for data analysis and at times work with data marts
      • Perform unit testing and produce system documentation for ETL
      • Export data from Google AnalyticsRequirements:
        • 5 years of strong Transact SQL skills, with ability to write/optimize-stored procedures, triggers and SQL queries
        • Data Warehouse knowledge
        • Strong Power BI skills
        • Extensive experience with SSRS, SSIS, and SSAS
        • Bachelor's Degree in Computer Science or related fieldPlease send your resume to Colin Crane, Senior Technical Recruiter for immediate consideration. Let us help you secure an interview!ABOUT USIrvine Technology Corporation (ITC) is an award-winning Information Technology Solutions and Staffing provider with roots in Southern California. For over fifteen years, we have had the privilege of serving exceptional client organizations as both a local and national resource. Our team is comprised of seasoned technologists, staffing industry thought leaders, top-notch recruiters, dedicated account executives, and a world class support staff.Irvine Technology Corporation provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Irvine Technology Corporation complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.

Keywords: Irvine Technology Corporation, Lake Forest , Database Analyst, IT / Software / Systems , Lake Forest, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Lake Forest RSS job feeds