Analytics Engineer

• Lead design, development, and maintenance of enterprise ETL workflows, data integration pipelines, and custom extracts
• Develop, enhance, and tune complex SQL queries, stored procedures, functions, and database objects
• Analyze Talend jobs and lead migration to Apache NiFi
• Design and implement scalable NiFi data flows for ingestion, routing, transformation, validation, and delivery
• Build, test, debug, deploy, and support ETL solutions
• Ensure data accuracy, integrity, quality, security, governance, and performance
• Implement data quality checks, exception handling, reconciliation, and logging
• Translate business and functional requirements into technical solutions
• Maintain technical design documents, data flow diagrams, source-to-target mappings, and process documentation
• Contribute to architecture reviews and the technical roadmap
• Establish and support Agile software development processes
• Collaborate with QA teams on test cases, transformation validation, and release verification
• Provide technical leadership and mentor junior developers and team members
• Support application deployment and operations in AWS environments

Senior SQL / ETL Developer

• Design, develop, and maintain Python-based data integration and automation solutions
• Develop and support ETL, batch-processing, and file-based workflows
• Build reusable tools and utilities for data processing, validation, and reconciliation
• Automate validation of inbound and outbound data feeds
• Develop end-to-end automation across file ingestion, backend processing, database results, and downstream outputs
• Develop SQL-based data validation and reconciliation
• Work with REST APIs and system integrations as part of end-to-end processing workflows
• Integrate automated processing and validation into CI/CD workflows
• Troubleshoot issues across application code, data, files, databases, APIs, and processing environments
• Participate in code reviews, technical discussions, sprint planning, and engineering delivery
• Collaborate with Product Owners, Business Analysts, DevOps, and other engineers to translate business and integration requirements into reliable software solutions

ETL Developer, Python – Contract

• Write, test, and maintain SQL queries for operational domains including customers, accounts receivable, rentals, products, inventory, and payments
• Investigate unfamiliar or poorly documented relational databases
• Profile source data for completeness, duplication, referential integrity, unusual record states, and migration risk
• Document extraction criteria, joins, filters, assumptions, control totals, audit fields, and known limitations
• Develop and maintain operational reports, extracts, exception reports, and cross-system comparisons using SQL, Excel, Power Query, or approved reporting tools
• Assist with NetSuite and Shopify saved searches, exports, and data investigations
• Trace discrepancies across source systems, transformations, import files, and target records to identify root cause
• Execute assigned data-conversion workstreams using approved requirements, source-to-target mappings, and acceptance criteria
• Develop and maintain mappings, normalization rules, exception categories, and deduplication logic
• Prepare import-ready outputs and reconcile record counts, quantities, balances, totals, duplicates, exclusions, and transformation results
• Create evidence packages and support post-import verification, corrections, and documented rerun procedures
• Develop Python, PowerShell, or comparable utilities for file ingestion, transformation, validation, reconciliation, exception reporting, and export generation
• Convert recurring SQL and Excel processes into version-controlled, tested, maintainable scripts or scheduled workflows
• Apply logging, configuration management, error handling, restartability, and safe-recovery practices
• Maintain queries, scripts, mappings, runbooks, and recovery procedures; participate in review and cross-training
• Support implementation testing, cutover activities, and issue investigation for assigned workstreams
• Work with the Software Systems Engineer and business subject-matter experts to independently execute defined technical workstreams after onboarding

Analytics Engineer jobs in New Jersey

Senior SQL / ETL Developer

ETL Developer, Python – Contract

Data Systems, ETL Engineer I