NEED LOCALS TO NEW JERSEY (NJ) OR NEARBY LOCATION CANDIDATES.
Job Title: Data Engineer
Client: Port Authority of New York & New Jersey
Location: Jersey City, NJ (Onsite)
Visa: NO H1B/CPT/OPT
Interview Mode: Video
JOB RESPONSIBILITIES:
- Designing Synapse tables and implementing data solutions within the Azure ecosystem.
- Design , develop and implement Synapse tables to support data ingestion, transformation and storage processes.
- Utilize Spark Scala / SQL to build scalable and efficient data pipelines within Azure Synapse.
- Design and develop Power BI dashboards by understanding user requirements.
- Optimize data storage, ensuring high performance and reliability in Synapse environment.
- Provide expertise in troubleshooting and resolving data related issues within Azure Synapse.
- Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions.
- Proven experience working with Azure Synapse Analytics.
- Proficiency in Spark Scala/SQL for data processing and transformation.
- Strong understanding of data modelling concepts and database design principles within Synapse.
- Ability to optimize and tune Synapse tables for performance and scalability.
- Excellent communication skills and the ability to work collaboratively in a team environment.
MINIMUM EXPERIENCE AND QUALIFICATIONS:
- Minimum 10 years of relevant experience in architecting, design, and development of data warehouse systems (SQL Server based on Cloud/on premise and Analytics) at enterprise scale.
- Experience in building end to end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc.
- Experience with Azure Data Services, such as Azure Data Factory, Azure Databricks, Azure Synapse Analytics, and Azure Data Lake Storage.
- Proficient in Python and SQL.
- Designing and building of data pipelines using API ingestion and Streaming ingestion methods.
- Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code is essential.
- Experience in developing NO SQL solutions using Azure Cosmos DB is essential.
- Thorough understanding of Azure and AWS Cloud Infrastructure offerings.
- Strong experience in common data warehouse modelling principles including Kimball, Inmon.
- Knowledge of Microsoft BI Stack (SSRS/SSAS (Tabular with DAX & OLAP with MDX) SSIS) is desirable.
- Bachelor’s degree in information technology, computer science or business administration required.
Regards,
Sucheta Chauhan
[email protected]
LinkedIn: linkedin.com/in/sucheta23
Voto Consulting LLC | http://www.votoconsulting.com
1549 Finnegan Lane, 2nd floor, North Brunswick, NJ 08902