Intern, Data Engineer (Spring 2025)

Wiss is seeking a Data Engineer who will be responsible for building and maintaining data pipelines and data warehouse that support business intelligence and analytics solutions to drive operational efficiency and effectiveness by enabling data-driven decisions across the organization. This role, reporting to the Director of Data Analytics & Business Intelligence will design, develop, and maintain a scalable and efficient data architecture that serves as the central source for all data-related needs, ensuring data integrity, security, and accessibility.This position will reside in our Florham Park, NJ office. ONLY NEW JERSEY CANDIDATES WILL BE CONSIDERED.Responsibilities:Collaborate with Digital Technology team members to develop enterprise data warehouse, data marts and other business intelligence projects.Design, develop data integration solutions using Microsoft Fabric (Data FactoryFabric Data Warehouse etc.) and other tools as appropriate to facilitate efficient data extraction, transformation, and loading (ETL) processes.Implement and maintain data quality checks and validations to ensure data is accurate and consistent across systems.Monitor and optimize the performance of SQL queries, ETL processes to ensure efficient data processing and data warehouse reliability.Troubleshoot and resolve data-related issues, including data integration failures, data quality problems, and performance bottlenecks.Essential Qualifications:Bachelor's degree in Computer Science, Information Systems, or a related field, master's degree highly preferred.1+ years of experience building scalable data and analytics solutions, with a focus on designing and implementing complex ETL processes.1+ years of data engineering including ETL and pipeline building experience using data integration engines such as SQL Server Integration Services (SSIS) or Azure Data Factory or SynapsePropose and implement ETLELT strategies, leveraging Azure Data Factory, Microsoft Fabric, and other tools to ensure efficient data movement and transformation.Working knowledge of business intelligence tools such as PowerBI and Tableau.Proficiency in programming language Python, for data engineering and scripting tasks.Familiarity with common system integration methods and technologies including SOAPREST APIs, flat files (JSON, XML, CSV, Parquet, etc.) and transforming data for ingestion into the data warehouse.Strong interpersonal and communication skills with AgileScrum experience.Strong problem solving and critical thinking skills with a proven record for identifying and diagnosing problems, and solving complex problems with simple, logical solutions.Preferred Qualifications:Microsoft Certified: Azure Data Engineer AssociateWiss, LLP HighlightsAccounting Today's 2024 Regional LeadersAccounting Today's 2024 Top 100 FirmsAccounting Today's 2024 top firms by AUMWiss is an Equal Opportunity-Affirmative Action Employer - Minority Female Disability Veteran Gender Identity Sexual Orientation Age ""Wiss is committed to diversity and inclusion. We seek candidates from all backgrounds to join our team and encourage our employees to bring their authentic and best selves to work. "To all staffing agencies: Wiss does not utilize 3rd party firms for any internal or client positions. Please be advised, Wiss is not responsible for any fees related to unsolicited resumes. All unsolicited resumes will become the property of Wiss.

Created: 2025-01-24