Job Description:
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. We are proud to offer candidates a PERMANENT hybrid work arrangement.
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 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, 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.
- 2-3 years of experience building scalable data and analytics solutions, with a focus on designing and implementing complex ETL processes.
- 2+ 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 Synapse
- In-depth knowledge of SQL and experience working with relational databases like SQL Server, MySQL, or Azure SQL etc.
- Propose and implement ETL/ELT strategies, leveraging Azure Data Factory, Microsoft Fabric, and other tools to ensure efficient data movement and transformation.
- Good understanding of data warehousing concepts and experience with data warehouse design and implementation.
- Proficiency in programming language 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.
- Experience with version control and CI/CD approach that involves promoting features through a VCS and multiple environments.
- Strong interpersonal and communication skills with Agile/Scrum experience.
- Working knowledge of business intelligence tools such as PowerBI and Tableau.
- 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 Associate
What we offer you:
- Growth Champion Program to help facilitate ongoing performance feedback
- Covered Becker costs to assist with the completion of the CPA exam
- Team atmosphere that promotes collaboration and communication designed to enhance efficiencies, as well as provide professional development
- Competitive salaries with comprehensive benefits package including M/D/V
- Flexible PTO policy
- 401k plan + match
- Hybrid work arrangement
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. "
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.
