ETL Developer Consultant

Robotics Prcocess Automation, LLC; New York (NY); On-site; USD 80,000 - 120,000; Full time

Job summary

A consulting firm specializing in data services seeks an experienced consultant for data extraction, transformation, and automation. The role involves designing and implementing ETL processes, collaborating with cross-functional teams and ensuring data integrity. Candidates should have strong analytical skills, experience with Oracle and SQL Server, and be proficient in developing APIs. This position offers opportunities for mentorship and participation in key technical projects while also ensuring compliance with industry standards.

Qualifications

• Experience with Oracle and SQL databases.
• Proven skills in automating ETL processes.
• Strong analytical skills for data processing.

Responsibilities

• Extract and transform data for analysis and reporting.
• Automate data pipelines using SSIS.
• Design and document ETL processes to ensure data integrity.
• Monitor and optimize ETL workflows and database performance.
• Develop APIs for data access and integration.

Skills

Data extraction from databases

ETL process design

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)

API development

Data modeling

Collaboration with cross-functional teams

Technical documentation

Tools

Oracle

SQL Server

Job description

DCP seeks an experienced consultant that can:

• Extract geographic and non-geographic data from Oracle and SQL Server databases, ensuring the integrity and quality of the data.
• Transform raw data into structured formats suitable for analysis, reporting, and system integration.
• Design and implement data pipelines for efficient handling of large datasets.
• Automate ETL integrations using SQL Server Integration Services (SSIS).
• Perform data analysis to drive key business objectives.
• Document ETL processes, data models, and API specifications for transparency and knowledge sharing.
• Develop, test, and maintain ETL workflows and scripts to automate data processing.
• Monitor ETL processes to ensure reliability, scalability, and performance.
• Perform data modeling and database design for application development and product implementation initiatives under the guidance of Database Administrator and Architect.
• Create reporting solutions using SQL Server Reporting Services (SSRS) by analyzing user needs and information availability.
• Troubleshoot and resolve data-related issues promptly.
• Create APIs to enable data access and integration with various applications and systems.
• Ensure APIs are secure, performant, and adhere to industry standards.
• Collaborate with developers and analysts to design API endpoints that meet business requirements.
• Work with GIS analysts, developers, and stakeholders to understand data requirements.
• Participate in requirements definition, analysis and design.
• Work closely with business analysts, subject matter experts and development teams in design,
• development, testing, implementation, and support of application projects.
• Facilitate creation, migration and maintenance of database objects across development/ QA/ production environments.
• Follow best practices in data modeling including use of standard naming conventions, processes and templates to ensure consistency of data models.
• Monitor and optimize database performance and capacity utilization to provide high availability and redundancy.
• Take ownership of database performance, scalability and security.
• Define and implement data testing strategies with business stakeholders, application development teams and QA groups.
• Participate in the software testing process, including identification and resolution of defects.
• Contribute to and support roll-out strategies.
• Participate in and contribute to formal/informal technical reviews and presentations.
• Accurately estimate time required to complete development tasks.
• Demonstrate the ability to cooperate with a variety of people and achieve results.
• Mentor and guide development team members on database-related tasks.
• Provide technical support and knowledge transition to team members and end users as needed.
• Communicate effectively with team members, stakeholders, and project managers to gather requirements, provide updates, and manage expectations.
• Create and maintain technical documentation, including system designs, workflows, and user guides.
• Ensure solutions comply with industry best practices, standards, and security protocols.
• Prepare documentation and conduct knowledge transition to support adoption across the organization and other city agencies.
• Stay current with industry trends and emerging technologies to propose innovative solutions and improve development processes.

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract