Description

The Senior ETL and Reports Developer will be instrumental in delivering business and systems analysis, modeling, design, and programming for FNS/SNAP reports development and maintenance operations utilizing ORACLE and PL/SQL programming technologies. This role involves gathering and documenting requirements for new data extracts and modifications to existing reports, as well as developing complex queries against large tables that store CLOBS/XML and supporting data structures. You will write efficient SQL queries to ensure optimal performance even when handling substantial datasets.

Company Culture and Environment

The workplace fosters an environment that values analytical thinking and a proactive approach to problem-solving. Collaboration and thorough documentation are essential to ensure that team members are aligned with project goals and changes in requirements.

Career Growth and Development Opportunities

This position offers opportunities to enhance technical skills in ETL processes and SQL programming while providing exposure to critical business functions. As you develop reports and performance metrics, you will also gain insights into operational improvements and efficiency metrics, facilitating career advancement within the organization.

Detailed Benefits and Perks

While specific benefits are not mentioned, the role implies a commitment to quality and operational excellence, suggesting that the company values its employees’ contributions and provides a supportive work environment.

Compensation and Benefits

• Competitive salary based on experience
• Health, dental, and vision insurance
• Retirement savings plan with company matching
• Generous vacation and paid time off policy
• Opportunities for professional development
• On-call support rotation

Why you should apply for this position today

This role presents a unique opportunity to impact the development and maintenance of critical reports that support business operations. By joining this team, you will engage in meaningful work that influences decision-making processes while enhancing your technical expertise.

Skills

• Proficient in ORACLE and PL/SQL programming technologies
• Strong SQL query development skills
• Experience working with large datasets, including CLOBS/XML
• Ability to analyze existing queries and data for performance optimization
• Knowledge of validation and audit strategies for data extracts
• Strong analytical and problem-solving skills

Responsibilities

• Gather and document requirements for new and existing data extracts and reports
• Develop complex SQL queries against large tables
• Analyze existing queries and reports to identify and address issues
• Create and analyze operational performance metrics and reports
• Ensure the quality and integrity of data extracts through validation strategies
• Participate in 24x7 on-call support rotation

Qualifications

• 5+ years of experience in ETL and report development
• Strong background in ORACLE and PL/SQL programming
• Proven ability to work with large datasets and complex queries
• Excellent analytical and problem-solving skills

Education Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field

Education Requirements Credential Category

• Bachelor’s Degree

Experience Requirements

• At least 5 years of relevant experience in ETL and report development
• Proven experience in SQL query optimization and performance analysis

Why work in Raleigh, NC

Raleigh offers a vibrant and growing tech scene, making it an attractive location for professionals in the industry. The city is known for its rich cultural offerings, diverse dining options, and strong community feel. With access to beautiful parks and outdoor activities, Raleigh provides a balanced lifestyle conducive to both personal and professional growth.