Job Description

People Operations Associate at Wiss | IO Psychology Graduate Student Wiss is seeking a Data Engineer who will be responsible for building and maintaining data pipelines and data warehouses 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 and develop data integration solutions using Microsoft Fabric (Data Factory/Fabric 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 and 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 experience, including ETL and pipeline building experience using data integration engines such as SQL Server Integration Services (SSIS) or Azure Data Factory or Synapse. Propose and implement ETL/ELT 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 Python for data engineering and scripting tasks. Familiarity with common system integration methods and technologies including SOAP/REST APIs, flat files (JSON, XML, CSV, Parquet, etc.) and transforming data for ingestion into the data warehouse. Strong interpersonal and communication skills with Agile/Scrum 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: Wiss, LLP Highlights: Accounting Today's 2024 Regional Leaders Accounting Today's 2024 Top 100 Firms Accounting Today's 2024 top firms by AUM Wiss 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. #J-18808-Ljbffr Wiss

Job Tags

Similar Jobs