Data Analyst

Persistent Systems; New York (NY); On-site; USD 133,000 - 166,000; Full time

Job summary

Persistent Systems, LLC seeks a Data Analyst for its New York City headquarters. You will transform diverse data into actionable insights, build trusted datasets, semantic models, and dashboards, and partner with executives across Finance, Operations, Marketing, Sales, and Product to define KPIs and reporting logic.

The role requires strong SQL, Power BI, Tableau, Python/pandas, data quality focus, and clear communication.

Qualifications

• 2–5 years of professional experience in data analytics, BI, reporting, or equivalent
• Bachelor's degree in a quantitative field or equivalent practical experience
• Advanced proficiency in SQL with joins, CTEs, window functions, and performance-aware analysis
• Strong Power BI experience (Power Query, DAX, semantic modeling) and Tableau depth
• Advanced spreadsheet skills and experience reconciling, cleaning, and validating data from multiple sources
• Knowledge of dimensional data modeling, KPI design, data dictionaries, ETL/ELT concepts, and source-to-target mapping
• Experience with Python and pandas or R for data manipulation and analysis
• Understanding of descriptive statistics, sampling, confidence intervals, hypothesis testing
• Ability to gather requirements, manage priorities, communicate findings, and influence decisions with evidence
• Must have a United States Security Clearance or be able to obtain one

Responsibilities

• Own analytical work from requirements discovery through transformation, modeling, validation, visualization, delivery, and support
• Partner with leaders across Finance, Operations, Marketing, Sales, Product to define KPIs and reporting logic
• Develop reliable analytics assets and documentation for metrics, transformations, and data lineage
• Apply statistical methods and communicate uncertainty; distinguish correlation from causation
• Promote secure, governed, self-service analytics across the organization
• Design, build, and maintain dashboards and reports using Power BI and Tableau
• Write and optimize complex SQL queries across databases and lakehouse platforms
• Clean, profile, map, join, and transform structured data using Power Query, Python/pandas, and spreadsheets
• Create ETL/ELT workflows using dbt, Azure Fabric/Data Factory, AWS Glue, Databricks; monitor failures
• Analyze historical data to identify trends, risks, opportunities; perform segmentation, forecasting, cohort, and experiment analyses
• Create validation rules, reconciliations, and quality checks; investigate discrepancies and implement fixes
• Translate questions into measurable definitions and data mappings; establish KPI definitions and a business glossary
• Reduce manual reporting with automated refreshes, workflows, and governed self-service datasets
• Present findings to both technical and nontechnical audiences with clear narratives
• Support embedded analytics using JavaScript libraries (Recharts, D3, Plotly) and shadcn/ui components
• Explore AI frameworks to accelerate discovery while validating outputs against trusted data

Skills

SQL

Power BI

Python/pandas

Data modeling

Tableau

Stakeholder comms

Data quality

KPI design

Security clearance

Education

Bachelor's degree in a quantitative field

Tools

dbt

Azure Data Factory

Fabric Data Factory

AWS Glue

Databricks

Job description

Job Description & Responsibilities

Persistent Systems is seeking a Data Analyst to join our team in our New York City headquarters. The Data Analyst will transform complex operational, financial, customer, product, and program data into accurate, timely, and actionable insights. This role will build trusted datasets, semantic models, dashboards, and analyses that help leaders understand performance, identify opportunities, manage risk, and make evidence-based decisions.

The ideal candidate is a disciplined problem solver and an effective "data translator" who can move comfortably between business questions and technical details. They combine strong SQL, data preparation, visualization, statistical reasoning, and stakeholder communication skills with a sharp eye for data quality and user experience.

Position Responsibilities

• Own analytical work from requirements discovery and source-data assessment through transformation, modeling, validation, visualization, delivery, and ongoing support
• Partner with leaders and subject-matter experts across Finance, Operations, Marketing, Sales, Product, and other functions to define key performance indicators (KPIs), reporting logic, and success measures
• Develop reliable, reusable analytics assets and clear documentation so that metrics, assumptions, transformations, and data lineage can be understood and maintained
• Apply statistical and analytical methods appropriate to the business question, communicate uncertainty and limitations, and distinguish correlation from evidence of causation
• Promote secure, governed, accessible, and responsible use of data while improving self-service analytics across the organization
• Design, build, and maintain intuitive dashboards, scorecards, semantic models, and recurring reports using Power BI as the primary platform and Tableau where appropriate
• Write, review, and optimize complex SQL queries across relational databases, cloud warehouses, and Lakehouse platforms; reconcile results to source systems and explain query logic
• Clean, profile, map, join, and transform structured and semi-structured data using Power Query, Python/pandas, spreadsheets, and related tools; design fact and dimension models using star-schema principles
• Build or contribute to repeatable extraction, transformation, and loading workflows using frameworks and platforms such as dbt, Azure Data Factory, Fabric Data Factory, AWS Glue, and Databricks; monitor failures and document lineage
• Analyze historical and current data to identify trends, drivers, anomalies, risks, and opportunities; perform segmentation, variance analysis, forecasting, cohort analysis, and experiment analysis when relevant
• Create validation rules, reconciliations, exception reporting, and quality checks; investigate discrepancies, perform root-cause analysis, and coordinate durable fixes with data owners and engineering teams
• Translate open-ended questions into measurable definitions, source-to-target mappings, acceptance criteria, and analytics plans; establish consistent KPI definitions and a shared business glossary
• Reduce manual reporting through scheduled refreshes, parameterized workflows, Power Automate, reusable templates, and governed self-service datasets
• Present concise findings and recommendations to technical and nontechnical audiences, using accessible visual design and clear narrative rather than relying on charts alone
• Support embedded or custom analytics experiences using JavaScript visualization libraries and component-based charting tools such as Recharts, D3.js, Plotly.js, Chart.js, and shadcn/ui chart components
• Explore responsible uses of Copilot Studio, Microsoft Foundry, and generative AI frameworks to accelerate discovery, natural-language analytics, documentation, and workflow assistance while validating outputs against trusted data

Job Qualifications & Experience

Minimum Qualifications

• 2–5 years of professional experience in data analytics, business intelligence, reporting, or a closely related role
• Bachelor’s degree in data science, statistics, mathematics, economics, finance, computer science, information systems, or a related quantitative field, or equivalent practical experience
• Advanced proficiency in SQL, including joins, common table expressions, window functions, aggregation, query validation, and performance-aware analysis
• Strong hands-on experience with Power BI, including Power Query, DAX, semantic modeling, interactive report design, refresh strategies, workspace management, and row-level security; comparable Tableau depth is also valued
• Advanced spreadsheet skills and practical experience reconciling, cleaning, and validating data from multiple sources
• Working knowledge of dimensional data modeling, KPI design, data dictionaries, ETL/ELT concepts, and source-to-target mapping
• Experience using Python with pandas and/or R for data manipulation, exploratory analysis, or statistical work
• Understanding of descriptive statistics, sampling, confidence intervals, hypothesis testing, and common analytical pitfalls
• Demonstrated ability to gather requirements, manage multiple priorities, communicate findings clearly, and influence decisions with evidence
• Must have a United States Security Clearance or be able to obtain a United States Security Clearance

Relevant certifications or credentials, such as:

• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
• Tableau Certified Data Analyst
• Tableau Desktop Specialist certification
• Experience operating in a regulated, security-sensitive, government, or defense-adjacent environment

Preferred Qualifications

• Experience with ETL/ELT frameworks and orchestration platforms such as dbt, Azure Data Factory, Fabric Data Factory, AWS Glue, Databricks, or comparable tools
• Experience building solutions with Power Platform, Power Apps, and Power Automate, including governed connections to enterprise data
• Experience with Microsoft Copilot Studio and Microsoft Foundry for secure AI-assisted analytics, agent experiences, or workflow augmentation
• Familiarity with generative AI frameworks such as LangChain, LangGraph, or LlamaIndex and the ability to identify appropriate, verifiable analytics use cases
• Experience with JavaScript visualization libraries such as Recharts, D3.js, Plotly.js, or Chart.js, including shadcn/ui chart components built on Recharts
• Experience with cloud data warehouses or Lakehouse platforms such as Microsoft Fabric, Databricks, Snowflake, Google BigQuery, or Amazon Redshift
• Experience with Git, analytics testing, version-controlled SQL or semantic models, CI/CD, and collaborative development practices
• Experience with data catalogs, lineage, access controls, sensitivity labels, or governance platforms such as Microsoft Purview
• Experience designing experiments, performing A/B test analysis, building forecasts, or applying regression and other classical statistical methods

The total compensation for this role can vary from $133,000 to $166,000 a year based on individual qualifications. Eligibility for yearly discretionary bonus. Persistent Systems, LLC offers a comprehensive benefits package including medical, dental, vision, life, and disability insurance; paid time off (sick time and vacation time); flexible spending accounts; 401(k) plan with company match; fitness membership reimbursement; tuition assistance; mental health benefits; and pet discounts.

Company Overview

Headquartered in New York City since 2007, Persistent Systems, LLC is a global communications technology company which develops, manufactures, and integrates a patented and secure Mobile Ad Hoc Networking (MANET) system: Wave Relay®. The company’s industry leading R&D team has designed wireless networking protocols to support their cutting-edge Wave Relay® system and technology. Wave Relay® is capable of running data, video, voice and other applications under the most difficult and unpredictable conditions. Their suite of products is field proven and utilized in Commercial, Military, Government, Industrial, Agriculture, Robotics, and Unmanned System markets.