Enterprise Data Warehouse (EDW) Programmer/Analyst

  • RiseIT Solutions
  • Orlando, Florida
  • May 23, 2021
Full time Other

Job Description

Title: Enterprise Data Warehouse (EDW) Programmer/Analyst

Location: On Site - Orlando, FL

Type: Full Time Direct Hire

Rate: $110 Annual Salary + Bonus Plan + Relocation

Position Description:

Ideal Candidates for this position will have the following:

· Candidates should have at least 3 years experience programming in SQL

· 5+ years programming/analysis experience

· Minimum of 3 years experience with developing complex ETL integrations in a large organization (Cloud ETLs IICS/Talend preferred)

· Minimum 3 years experience programming in SQL, PL/SQL application development/skills

· Extensive experience in extract, transform and load, data profiling, data quality, metadata management, and data intake for large complex data systems

· Candidates need to have experience working on Oracle Platforms



The Sr. Programmer Analyst - EDW will provide technical expertise in designing and implementing data integrations for data warehouse/business intelligence solutions leveraging Extract, Transform and Load (ETL/ELT) tools such as Informatica. Create technical design specifications from business/functional requirements. Work with internal stakeholders to clarify data integration and system requirements as appropriate. Configure, program/create ETL solutions and unit test development work to ensure quality. Work within the SDLC methodology and adhere to technical architecture standards. Proactively identify potential problems and issues and actively communicate and manage issues to resolution. Work closely with multiple functional areas to understand data and assist in data architecture design. Provide assistance to IT and business users to effectively understand and leverage data and make it available to the business in a useful, usable format. Begin to use and explore Cloud ELT tools and development. Support replication of the on-premises Data Warehouse to the Cloud, and gain expertise and understanding of Snowflake cloud data warehouse.


· Bachelor's degree in IT related discipline or equivalent experience (BS / BA in MIS, Computer Science, Business Analytics, or Mathematics)


· Ability to work independently, take ownership of tasks and follow through to implementation/resolution

· Strong verbal and written communication skills with an ability to express complex technical concepts in business terms and complex business concepts in technical terms

· Ability to prioritize and multi-task across numerous work streams

· Highly developed analytical, problem-solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirements


· Experience with PL/SQL Developer

· Working experience with revision control systems, Linux platform, Shell scripting, and big data

· Microsoft Azure, Databricks, Spark SQL, cloud technologies and tools

· Understanding of SDKs and Rest API calls

· Experience with customer/guest data and systems; knowledge of restaurant business