SQL/ETL Developer (Jr-Mid Level)

  • Prosum,
  • Phoenix, AZ
sql
Full Time
$55,000 - $80,000
Work from home not available Travel not required

Job Description

Position Responsibilities:

  • Work with business users to understand and document business and technical requirements to drive design and development
  • Collaborate on the design of physical structure and implementation of database objects
  • Document and build physical database objects from table, column, index and view definitions
  • Develop scripts for the creation of the physical data warehouse tables, views and macros
  • Adhere to data security and protection policies
  • Monitor and troubleshoot Extract-Transform-Load (ETL) and system performance, including optimization and tuning of data loads
  • Understand job and activity schedules to promote optimal performance, maximize availability and minimize data latency and data load duration
  • Provide off hours on-call support to resolve production issues within the stated service level agreement
  • Maintain a positive work atmosphere by acting and communicating in a manner which facilitates the success of business operations in order to meet company demands and expectations
  • Perform additional duties as assigned
  • Proactively seek opportunities to broaden and deepen knowledge base and proficiencies and share acquired skills with team members through formal and informal channels
  • Maintain a positive work atmosphere by acting and communicating in a manner which facilitates the success of business operations in order to meet company demands and expectations
  • Ability to multi-task, prioritize workload and communicate timelines clearly

Position Qualifications:

  • Bachelor s degree required
  • 2-3 years experience as an ETL developer in data warehouse / business intelligence environment
  • Strong knowledge of data warehousing methodologies and concepts, including and not limited to: star schemas, snowflakes, ETL processes and dimensional modeling
  • Experience with system integration across multiple systems and platforms utilizing various technologies such as ODBC, FTP, Window, Unix/Linus, and AS400
  • Experience working with high volume databases with partitioned data, performance and tuning
  • Experience working with cross functional development, QA, test and production teams
  • Proven track record of meeting project deadlines and delivering high quality consulting services

    Skills and Abilities:

  • Excellent analytical skills and a proactive approach to problem solving
  • Strong SQL development skills, including complex joins, aggregations, analytical functions, derived tables, stored procedures, triggers and macros
  • Strong application development and programming skills such as SAS, Window batch scripting, Unix/Linux shell scripting or other procedural programming
  • Strong written and verbal communication skills

Posted By

JD Frank

Private Office El Segundo, CA, 90245

Dice Id : prosum
Position Id : JF19220
Have a Job? Post it