Job description

Your Role on our Team

The Business Intelligence and Data Management team of 1800Flowers.com has an exciting opportunity to join an established team focusing on Enterprise Analytics and Data Management initiatives for the enterprise. The Business Intelligence Developers are responsible for designing and creating the data warehouse and all related extraction, transformation and load of data functions in the company.

Duties & Responsibilities:

• Design, document and implement new ETL enhancements and modify existing code. Work independently to develop, configure, and unit test programs from specs (source to target mappings)
• Work closely with data architects, reporting team and application team on ETL development efforts including analysis and design of integration solutions and enhancements. Must be able to explain and support decisions and actions taken
• Understanding the clients/customers’ requirements. Deliberating different viable options of implementing technical solutions to the customer’s requirements
• Develop and document the functional details of the procedures work within the data quality applications
• Proficient in SAS Enterprise Guide to modify existing, or develop new reports, for business users based on requirements documentation
• Proficient in Tableau to modify existing, or develop new report dashboards, for business users based on requirements documentation
• Use Informatica Data Quality to profile the project source data, define or confirm the definition of the metadata, cleanse and validate the project data, check for duplicate or redundant records
• Build IT Controls to protect the processed data or output in accordance to confidentiality, integrity, as well as availability of the application

Requirements:

• Bachelor’s degree or equivalent work experience
• Must be passionate about delivering an exceptional customer experience and demonstrate an ability to solve business and technical challenges with the customer in mind
• Must be well-organized and able to balance work on multiple concurrent projects and support issues in an Agile development environment
• Must be available to participate in an on-call support rotation in a 7x24x365 environment
• SAS and Tableau experience required
• Minimum 2 years of experience of Informatica ETL development professional work experience with a preference of 1-year hands-on experience with Informatica Data Quality (IDQ) tool set.
• 2+ years of hands-on experience with the databases such as Snowflake, Oracle, SQL Server, DB2 etc.
• Proficiency in data quality development around address validation services, data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling
• Excellent knowledge on Informatica platform independently integrate other different Informatica components and services preferred
• Excellent data analysis and data profiling skills.
• Strong experience on data quality development process, issue management, and data remediation
• Experience and understanding with unit testing, release procedures, coding design and documentation protocol as well as change management procedures
• Proven, hands on experience with development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes desired
• Expertise with integration technologies and processes
• Experience with ETL development using API’s is a plus.

Job Type: Full-time

Pay: $70,000.00 - $85,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Employee discount
• Life insurance
• Paid time off
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday

Ability to commute/relocate:

• Jericho, NY 11753: Reliably commute or planning to relocate before starting work (Required)

Experience:

• Informatica: 3 years (Required)
• SAS: 3 years (Required)
• Tableau: 3 years (Required)

Work Location: In person

arclintfl.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, arclintfl.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, arclintfl.com is the ideal place to find your next job.