Data and Analytics Architect Developer

  • $101,000.00 - $150,000.00/year
  • Responsibilities for this role is the development and implementation of a new data warehouse environment which includes but are not limited to design, data collection, transformation, and delivery of data to our reporting tool.

    Responsibilities:

    • Work with business to understand objectives of data warehouse
    • Understand source system data, process and flow
    • Data modeling for new data marts including data definitions, data flow diagrams, and process definitions
    • Develop ETL build modules using TimeXtender’s Discovery Hub
    • Design and develop database objects, tables, stored procedures, views and SSIS packages
    • Performance tuning of the stored procedures and T-SQL
    • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
    • Document and test work products and automate data quality checks
    • Research Interpret business needs of stakeholders and develop analytical solutions

    Requirements:

    • Experience developing with an ETL tool
    • Experience developing SSIS packages
    • Strong Experience in relational and dimensional data modeling
    • Strong Experience with T-SQL programming, writing advanced queries, stored procedures, functions, joins, etc.
    • Experience in tuning queries using Data Base Tuning Advisor, Query Statistics and Execution plans
    • Exceptional organizational skills and ability to handle large projects while meeting deadlines and immediate business needs
    • Ability to work in a team environment
    • Good written and oral communication
    • Adhere to standards and best practices
    • Detail-oriented with strong organizational, analytical and communication skills
    • Ability to translate requirements into developed code
    • Investigates problems to establish real or hidden causes
    • Places emphasis on client satisfaction and customer experience
    • Enthusiastic about learning large and complex systems, and new tools

    ADTRAV Corporation is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, veteran status or disability.

    Want to apply later?

    Type your email address below to receive a reminder

    Apply to Job

    ErrorRequired field
    ErrorRequired field
    ErrorRequired field
    Error
    Error
    insert_drive_file
    insert_drive_file