BI Developer
Jericho, NY Jericho, NY Full-time Full-time $70,000 - $85,000 a year $70,000 - $85,000 a year 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.
Estimated Salary: $20 to $28 per hour based on qualifications.
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.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
