
Data Analyst
Dynatron Software, Inc.
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $95,000 - $120,000 per year
Job Level
Mid-LevelSenior
Tech Stack
Amazon RedshiftBigQueryCloudETLNumpyPandasPythonSQLTableau
About the role
- Analyze large, complex datasets to identify discrepancies, trends, anomalies, and root-cause data issues.
- Perform historical data research to validate business logic, reconcile legacy data, and ensure long-term data accuracy and consistency.
- Write advanced SQL and Python scripts for data extraction, profiling, validation, automation, and analytical modeling.
- Support and validate data modeling activities, including dimensional modeling and warehouse structure reviews.
- Strengthen data quality through meticulous metadata documentation, validation of business definitions, and participation in data governance efforts.
- Build dashboards, reports, and analytical insights using Tableau, Power BI, Looker, Sigma, or Excel.
- Collaborate closely with Data Engineering, Product, and Business stakeholders to translate analytical findings into actionable recommendations and data-driven decisions.
Requirements
- 4-5 years of progressive data analysis experience in enterprise or large-scale data environments.
- Expert-level SQL skills, including joins, window functions, CTEs, aggregations, and performance tuning.
- Strong Python skills (Pandas, NumPy, Jupyter) with experience building automated validation and analysis workflows.
- Proficiency with modern BI tools such as Tableau, Power BI, Looker, Sigma, and Excel.
- Strong understanding of data warehousing concepts, ELT/ETL processes, and dimensional modeling (Star/Snowflake).
- Experience working with cloud data platforms such as Snowflake, Redshift, BigQuery, or Databricks.
- Familiarity with metadata management, data lineage, and data governance frameworks.
- Excellent communication skills with the ability to explain complex data findings clearly to technical and non-technical audiences alike.
- High attention to detail, strong ownership mentality, and a proactive, problem-solving mindset.
- Ability to thrive in a fast-paced environment while managing multiple priorities and meeting deadlines.
Benefits
- Comprehensive health, vision, and dental insurance
- Employer-paid short- and long-term disability and life insurance
- 401(k) with competitive company match
- Flexible vacation policy and 11 paid holidays
- Remote-first culture
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLPythondata extractiondata profilingdata validationdata automationanalytical modelingdimensional modelingdata warehousingELT/ETL processes
Soft skills
communication skillsattention to detailownership mentalityproblem-solving mindsetability to manage multiple prioritiesability to meet deadlines