Senior Technical Analyst - RDBMS, ETL/ELT & AI/ML (W2 Only)

Macpower Digital Assets Edge Private Limited
  • Brooklyn, NY
  • $50–$52 Per Hour
  • Quick Apply
6 days ago

Job Description

Key Responsibilities:
  • Lead workshops with stakeholders to document processes, pain points, user stories, functional specs, acceptance criteria.
  • Perform feasibility analysis for AI/ML, automation, decisioning, workflow optimization.
  • Develop process maps (BPMN), system flows, data lineage, integration docs.
  • Translate business requirements into technical specs: APIs, data flows, validation rules, model inputs/outputs.
  • Analyze apps, databases, integrations, AWS environments for solution design.
  • Collaborate with architects, developers, data scientists, engineers on requirements interpretation.
  • Define data needs, metrics, rules, validation logic, AI/ML model behavior with teams.
  • Lead AI pilots/POCs: define metrics, track outcomes, document lessons for scale-up.
  • Conduct root cause analysis; recommend improvements for accuracy, efficiency, compliance, UX.
  • Support dashboarding, analytics KPIs, reporting for leadership.
  • Support UAT, traceability, defect triage, business sign-offs.
  • Partner with QA for testing coverage, especially AI scenarios.
  • Liaise between business, IT, vendors, SMEs for alignment.
  • Produce status updates, docs, executive summaries.
  • Support training, SOPs, knowledge transfer, rollouts.
Required Skills and Experience:
Technical Skills:
  • 10+ years functional/technical analysis for enterprise apps, data solutions.
  • 10+ years BRDs, FSDs, user stories, workflow diagrams, system docs.
  • 7+ years data analysis (structured/unstructured); interpret for decisions.
  • 7+ years complex SQL, query optimization, RDBMS (SQL Server, Oracle, PostgreSQL).
  • 5+ years data warehouses, ETL/ELT, data modeling.
  • 5+ years statistics/ML on datasets: validation, iteration.
  • 5+ years data libraries (Python, pandas); CI/CD/MLOps exposure.
  • 5+ years evaluating AI tools/frameworks/vendors; recommendations.
  • 7+ years leading pilots/POCs, metrics, scale-up/roadmap planning.
  • 5+ years AI/ML concepts, automation frameworks, data fundamentals.
Functional Skills:
  • Feasibility studies and solution design translation.
  • Root cause analysis and process optimization.
Behavioral Skills:
  • Strong collaboration and liaison across stakeholders.
  • Leadership in workshops, pilots, and documentation.
Requirements:
  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • 10+ years total relevant experience.
  • NY local resident preferred.
  • English native or bilingual proficiency.

Numbers & Facts

LocationBrooklyn, NY
Salary$50–$52 Per Hour

Skills

  • Acceptance Testingunmatched
  • Amazon Web Services (AWS)unmatched
  • Application Programming Interface (API)unmatched
  • Artificial Intelligence (AI)unmatched
  • Automationunmatched
  • Bug Tracking/Defect Managementunmatched
  • Computer Scienceunmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Integrationunmatched
  • Data Analysisunmatched
  • Data Modelingunmatched
  • Data Scienceunmatched
  • Database Analysisunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • English Languageunmatched
  • Enterprise Applicationsunmatched
  • Feasibility Analysisunmatched
  • Functional Analysisunmatched
  • Information Technology & Information Systemsunmatched
  • Knowledge Transferunmatched
  • Leadershipunmatched
  • Metricsunmatched
  • Microsoft SQL Serverunmatched
  • Model Validationunmatched
  • Multilingualunmatched
  • Oracle Databaseunmatched
  • Performance Metricsunmatched
  • PostgreSQLunmatched
  • Process Developmentunmatched
  • Process Improvementunmatched
  • Python Programming/Scripting Languageunmatched
  • QA Partner Testing Softwareunmatched
  • Query Optimizationunmatched
  • Relational Databases (RDBMS)unmatched
  • Reporting Dashboardsunmatched
  • Requirements Managementunmatched
  • Root Cause Analysisunmatched
  • SQL (Structured Query Language)unmatched
  • Standard Operating Procedures (SOP)unmatched
  • Statisticsunmatched
  • Technical Analysisunmatched
  • Testingunmatched
  • Traceabilityunmatched
  • Training Data Setsunmatched
  • User Interface/Experience (UI/UX)unmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder