Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Data Architect

Tom Ferry

Data Architect

Santa Ana, CA
Full Time
Paid
  • Responsibilities

    Job Description

    The Data Architect ensures that access to disperse enterprise data is easily consumable by end-users.  The ideal architect will partner with team members, customers, and business owners in creating robust and scalable solutions to accomplish the enterprise goals of the team.

    ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

    1. Design and implement a flexible platform for operational data stores, data warehouses, data marts and data lakes using standard practices as well as documenting the systems of record, data dictionaries and data flow diagrams for strategic data management
    2. Develop and maintain ETL jobs
    3. Actively contribute towards data migration tasks from on-premises to cloud
    4. Multi-task across several ongoing projects and daily duties of varying priorities as required
    5. Ability to make good judgments, decisions, negotiate and problem solve
    6. Create detailed technical specifications and release documentation for assigned ETL and reporting projects
    7. Log and track system problems through resolution.
    8. Create and maintain documentation on processes, policies, application configuration and help-related materials as applications are developed.
    9. Maintain technical documentation of existing and future applications.
    10. Attendance and on-time reporting.
    11. Maintain compliance with company policies, practices and procedures.
    12. Participate in proactive efforts to achieve departmental and company goals.
    13. Work effectively and communicates clearly with other employees.
    14. Handle changing deadlines and priorities.
    15. Review work for accuracy, completeness and proper authority.
    16. Other duties as assigned.

    EDUCATION AND/OR EXPERIENCE

    Bachelor’s Degree; and 5+ years’ experience and/or training; equivalent combination of education and experience.

    OTHER SKILLS AND ABILITIES

    Project Management

    Business Analysis

    COMPUTER SKILLS

    • Experience with Data Warehousing methodologies and concepts (Kimball)
    • Extensive experience with BI/DW lifecycle including source data analysis, ETL, data marts, reporting, dashboards, and analytics
    • 5+ years of experience developing ETL processes with large scale data warehouses required
    • Experience with NoSQL data (JSON, etc.) a big plus

    LANGUAGE SKILLS

    Ability to read, analyze, and interpret documents such as technical procedures, operating and maintenance instructions, and procedure manuals.  Ability to write routine reports and correspondence.  Ability to speak effectively before groups of customers or employee of organizations.

    MATHEMATICAL SKILLS

    Calculate figures and amounts such as proportions, percentages, area, circumference, volume, statistical equations and probability equations.  Interpret and apply statistical and probability tables and graphs.  

    PLANNING AND ORGANIZATION

    Handle multiple projects simultaneously.

    PHYSICAL DEMANDS 

    This is sedentary work which requires the following physical activities:  reaching, sitting, lifting (≤25 pounds), finger dexterity, grasping, feeling, repetitive motions, talking, hearing and visual acuity.  

    WORK ENVIRONMENT

    Well-lighted, heated and/or air-conditioned indoor office setting with adequate ventilation.

    The office work environment is boisterous.  Attire is business casual.

    TRAVEL

    None

    Powered by JazzHR

    9k5hA4ZrH9