DVG Tech Solutions LLC · 5 hours ago
Data Analyst
Paramus, NJ
Full-time
Hybrid
Mid Level
$110K/yr - $110K/yrDVG Tech Solutions LLC is seeking a Data Analyst to enhance their data management processes. The role involves extracting legacy data, developing data pipelines, creating data models, and designing interactive dashboards to provide actionable insights for the business.
Human ResourcesIT ManagementSoftwareStaffing Agency
Responsibilities
Write complex SQL queries against DB2 (AS400/iSeries) tables to extract historical operational data
Build and maintain data ingestion pipelines (using Python, SQL, or ETL tools) to move data from on-premise legacy systems into Google BigQuery
Design clean, efficient data models in the cloud that transform cryptic legacy field names (e.g., CUST01, AMT99) into business-friendly schemas
Design interactive dashboards using Looker Studio and Power BI
Translate raw data into actionable insights for the business
Reconcile data between the source (AS400) and the destination (Cloud) to ensure 100% accuracy during migration and reporting
Qualification
Required
Strong proficiency in DB2 SQL and familiarity with AS400/iSeries file structures
Expert-level SQL skills in a cloud environment (BigQuery preferred, or Snowflake/Redshift)
Hands-on experience building data pipelines (ETL/ELT)
Proven experience building dashboards in Looker Studio or Power BI
Ability to explain technical data constraints to non-technical business stakeholders
Preferred
Experience in Utilities or regulated industries
Basic understanding of Python for scripting automation
Benefits
Benefits
Company
DVG Tech Solutions LLC
DVG is a high skilled talented Human Capital Consulting Organization with individual practices in Talent Acquisition.
Founded in 2003
501-1000 employees
H1B Sponsorship
DVG Tech Solutions LLC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (56)
2024 (73)
2023 (75)
2022 (57)
2021 (30)
2020 (40)
Funding
Current Stage
Late StageRecent News
Company data provided by crunchbase