Job Post Date: 12/16/2024
Location: New Jersey USA (Remote)
Job Type: Full-time
Experience Level: 1-3+ Years
Qualifications / Requirements:
Applicants for the Data Analyst role are required to possess a Bachelor’s degree in computer science or a closely related discipline.
Job Duties and Responsibilities:
- Design and implement database solutions in Azure SQL Data Warehouse,
- Azure SQL.10%
- Enhancements to Vertex Configuration utilizing Tax Assist, Taxability
- Drivers, creating and editing Taxability Categories and Tax Rule overrides.10%
- Performed ETL operation using SSIS and loaded data into Secure DB.10%
- Maintain and develop complex SQL queries, views, functions and
- Reports that qualify customer requirements on Snowflake.10%
- Develop stored procedures/views in Snowflake and use in Talend for loading
- Dimensions and Facts.10%
- Work with the ETL team to document the transformation rules for Data
- Migration from OLTP to Warehouse.10%
- Work on building EC2 instances, Creating IAM user’s groups and defining policies.20%
- Use various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.20%
Problem-Solving:
- Ability to translate business problems into analytical frameworks and develop data-driven solutions.
Communication Skills:
- Strong interpersonal and communication skills with the ability to explain complex concepts to non-technical stakeholders.
Team Collaboration:
- Demonstrated ability to work effectively in a collaborative team environment.