SENIOR PROGRAMMER ANALYST - ENTERPRISE DATA WAREHOUSE

Data Warehouse, Business Intelligence, PL/SQL, Informatica
Full Time
$120,000 - $140,000

Job Description

The SPA EDW provide technical expertise in designing and implementing data integrations for data warehouse/business intelligence solutions leveraging ETL/ELT tools, and creating technical design specifications from business/functional requirements, while supporting our on premise Oracle data warehouse.

 Here are some things to consider when reviewing candidates for this position:

  -Candidates should have at least 3 years’ experience programming in SQL,

  -5+ years programing/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

In regards to the technical skills:

  • Required:
    • Data Warehouse/Business Intelligence
    • SQL, PL/Sql
    • Oracle Database
    • Any ETL tool (Informatica/Talend)
  • Preferred:
    • Unix
    • Cloud Exposure (Data Lake, Data bricks, ADF, Spark Sql)
    • Java/Python scripting

 

All candidates should have work authorization for the United States.

This position would require for the individual to work on-site starting June 1, 2021.

JOB OVERVIEW:
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 companies 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 our on-premise Data Warehouse to the Cloud, and gain expertise and understanding of Snowflake cloud data warehouse.

ROLES AND RESPONSIBILITIES:
-Work closely with key stakeholders and other project team members to understand and prioritize functional requirements and information needs.  Participate in the development of functional requirements and design specifications as appropriate.
-Develop, create and document technical specifications and designs from which applications and/or technical solutions can be developed that satisfy documented business /functional requirements; envision potential future requirements and business needs to ensure solutions are flexible and extensible.
-Design and implement robust, efficient extract, transform, and load applications and processes to load data and supporting metadata into the Enterprise Data Warehouse using Informatica and other tools and languages;  this includes implementation of parsing rules to assure selection of accurate data, transformation of data into the required format and structure to support the business requirements, loading the transformed data into the target database and the associated metadata, and where applicable, aggregations of data. 
-Ensure that all code / technical configurations and other work products are thoroughly unit-tested prior to delivery.  Participate in system/integration testing as appropriate.  Perform code reviews and other QA steps as requested.
-Responsible for the ongoing operational stability and maintenance of the ETL/ELT processes, systems, and data, ensuring they are properly monitored and audited to provide data integrity, accuracy and timeliness of delivery.  This includes being on call to support production systems.
-Work closely with Data Architect/Modeler, Business Analysts and BI Developers to understand requirements and use technology and best practices to develop ETL processes in support of the requirements, validating that they meet business and technical specifications.
-Lead small projects, documenting programs and systems according to published standards.
-Adhere to Darden SDLC and technology architecture requirements.  Contribute to architecture design principles and standards as appropriate.
-Proactively identify and communicate potential problems and issues to project team members/leaders, including identifying alternatives and recommending/implementing solutions as appropriate.
-Ensure accurate project status and work estimates (ETCs) are always reported /communicated to project leaders/managers in a timely fashion.  Develop detailed project and task estimates as needed.  

-Effectively communicate with stakeholders throughout the project lifecycle.  Ensure issues are analyzed, discussed and resolved in a timely manner.  
-Consistently enhance skills and job knowledge by researching new relevant technologies and software products and trends; reading professional publications; maintaining personal networks; participating in professional organizations.
-Support replication of the on-premise Oracle data warehouse to Cloud Data Warehouse (Snowflake). 

-Begin efforts to transition ETL/ELT to the cloud, taking data through phases of a data lake and then into the cloud data warehouse, using technologies such as Databricks, Spark SQL, etc.
REQUIRED TECHNICAL SKILLS:

-5+ years programing/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
-Extensive experience in extract, transform and load, data profiling, data quality, metadata management and data intake for large complex data systems
-Demonstrated ability to analyze, verify, and document the accuracy of the developed ETL code through self-directed testing
-Hands on experience with Informatica and/or cloud ELT technologies, including demonstrated strong SQL coding skills
-A strong familiarity with general DBMS concepts
-Knowledge of best practices through relevant experience across data-related disciplines and technologies particularly for enterprise wide data architectures and data warehousing/BI
-Ability to prepare design documentation to express necessary details for review and ongoing maintenance
-Resolve end user reporting problems through collaboration with both technical and functional personnel in a team environment
REQUIRED EDUCATION:
-Bachelor's degree in IT related discipline or equivalent experience (BS / BA in MIS, Computer Science, Business Analytics, or Mathematics)

 
OTHER KEY QUALIFICATIONS:
-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
PREFERRED SKILLS AND EXPERIENCE:
-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

Dice Id : 10447565
Position Id : DWFL3
Originally Posted : 8 months ago
Have a Job? Post it

Similar Positions

Systems Engineer - Enterprise Data Warehouse
  • TekPartners
  • Orlando, FL, USA
Google Cloud Platform Data Engineer
  • Apex Systems
  • Orlando, FL, USA
SR MICROSTRATEGY Programmer/Analyst
  • TITAN TECHNOLOGIES
  • Orlando, FL, USA
Data Engineer
  • Apex Systems
  • Orlando, FL, USA
Principal Data Engineer -Remote
  • Ultimate Kronos Group (UKG)
  • Avon Park, FL, USA
Lead Big Data Architect
  • Ciber Global LLC
  • Orlando, FL, USA
Cloud Business Intelligence Engineer
  • TITAN TECHNOLOGIES
  • Orlando, FL, USA
ETL Informatica Developer
  • Nityo Infotech Corporation
  • Tampa, FL, USA
Business Data Analyst - III
  • Judge Group, Inc.
  • Temple Terrace, FL, USA