Sr. Data Analyst (ETL/SSIS)

Intone Networks is seeking a Sr. Data Analyst (ETL/SSIS) for an onsite role in Pennsylvania. This position prioritizes turning data into actionable insights through data mapping, validation, reporting, and analysis, helping inform business decisions. You will collect, interpret, and transform data to support cross‑system data integration and reliable analytics, collaborating with business users, developers, and stakeholders to resolve data issues and optimize mapping logic.

Responsibilities

• Analyze large datasets to uncover trends, patterns, and actionable business insights.
• Map data across source and target systems to support data integration, migration, and reporting efforts.
• Gather and interpret business requirements for data related projects.
• Develop and maintain mapping documents, data dictionaries, and metadata definitions.
• Validate data accuracy, completeness, and consistency across multiple systems.
• Collaborate with business users, developers, and stakeholders to resolve data issues and ensure correct mapping logic.
• Write and optimize SQL queries for data extraction, transformation, and analysis.
• Support ETL and data migration activities by identifying source to target field relationships.
• Monitor data quality and propose process improvements.
• Assist with testing, reconciliation, and troubleshooting during system implementations or data conversions.
• Document data flows, business rules, and transformation logic.

Requirements

• Experience in data mapping.
• Experience in data validation.
• Experience in reporting.
• Experience in analysis.
• Strong analytical capabilities.
• Proficiency with data tools.
• Ability to map data accurately between systems, sources, and business requirements.
• SQL proficiency, including writing and optimizing queries.
• Experience with ETL and data migration.
• Ability to work with business users, developers, and stakeholders to resolve data issues.
• Data quality monitoring experience.

Technologies

• SSIS
• SQL