Senior Programmer Analyst - Enterprise Data Warehouse

Darden Restaurants Inc.; Orlando, Northern (FL, KY); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Darden Restaurants Inc. seeks an experienced data integration engineer to design, implement, and optimize ETL/ELT pipelines for the data warehouse/BI environment. You will create design specs from business requirements and collaborate with stakeholders to ensure accurate data delivery.

You will develop robust ETL processes using Informatica and cloud ELT tools, maintain quality through unit tests, and support production systems. Hybrid work and SDLC adherence are expected.

Qualifications

• Minimum 5+ years of programming/analysis experience.
• 3+ years developing complex ETL integrations (Informatica preferred).
• 3+ years SQL programming experience.
• 2+ years Python coding experience.
• Experience with large data systems, metadata management and data quality.

Responsibilities

• Develop, document and implement robust ETL/ELT processes for the Enterprise Data Warehouse.
• Create technical design specifications from business requirements and ensure quality pipelines.
• Work with stakeholders to clarify data integration and system needs.
• Lead small projects and document them per standards.
• Ensure code is unit-tested and participates in QA activities.
• Maintain operational stability and monitor data pipelines; be on-call for production support.
• Collaborate with Data Architect/Modeler, BAs and BI Developers to meet requirements.

Skills

Informatica

SQL

Python

ETL/ELT

Snowflake

Azure Databricks

Data architecture

Linux

Shell scripting

Education

BS / BA in MIS, Computer Science, Business, Mathematics or Engineering

Tools

Informatica

SQL

Python

Snowflake

Azure Databricks

Linux

Job description

Location: 1000 Darden Center Dr, Orlando, FL, 32837

Job Overview

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 and reliable data pipelines. Leverage automation, AI-assisted development tools, and productivity-enhancing technologies to improve development efficiency and code quality. Work within Darden's 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. Assist IT and business users to effectively understand and leverage data, making it available to the consumers in a useful, usable format. Explore and adopt modern Cloud ELT tools, data integrations in both batch and real-time, AI-enabled data engineering capabilities and modern data architectures.

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.

Required Technical Skills

• 5+ years programing/analysis experience
• Minimum of 3 years’ experience with developing complex ETL integrations in a large organization (Informatica preferred)
• Minimum 3 years’ experience programming in SQL
• Minimum 2 years’ experience coding in Python
• 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
• Experience working on Snowflake
• 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

• BS / BA in MIS, Computer Science, Business, Mathematics or Engineering

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

#LI-Hybrid #LI-KP1