Advisory Software Engineer

Advisory Software Engineer with the following duties:

1. Design, implement, test, debug, and troubleshoot data pipelines across cloud platforms like GCP, AWS, DBT Labs, and integration tools like Informatica Power Center, MuleSoft, or SQL Server Integration Services. Proficient in scripting using Google Cloud Functions, Python, batch/bash scripts.
2. Create scripts to build new database objects. Develop stored procedures, functions, packages, triggers, and views using tools such as MS SQL Server, MySQL, Neo4J, and BigQuery.
3. Develop schema objects, generate data reports, and create intelligent dashboards using analytical tools such as PowerBI, Tableau, Looker, SSRS, and more to empower data-driven decision-making. Identify and address performance issues, ensuring that data analytics processes run efficiently.
4. Provide production support for running applications, ensuring uninterrupted business operations. Address escalations, take charge of resolving issues, and develop corrective action plans to maintain system stability.
5. Provide thorough functional and analytical reviews to ensure the data integrity and accuracy of solutions. Create and assess technical design documents before presenting them to customers, ensuring alignment with business requirements.
6. Work closely with Customer’s Project Managers to prioritize and plan work assignments, contributing to project success. Assist project managers in estimating and planning complex project activities to meet project timelines and deliverables.
7. Continually evaluate software components and tools for software applications, making recommendations for system improvements as required. Upgrade and improve data and application schema, preparing design documents and functional specifications.
8. Collaborate with cross-functional teams to analyze complex business problems and design innovative solutions that leverage data-driven insights.
9. Understanding of third-party applications includes Simon CDP, LiveRamp, Tealium, Salesforce, Moody’s, AccuWeather, Microsoft C360, SleepScore, Podium, Inmoment, and Cloudingo. 

Requirements:

Educational Requirements: Bachelor of Science in Computer Science, or a related field.

Work Experience Requirements: 2 years of experience either in the offered position or Sr. Software Engineer or a related occupation.

Skill Set Requirements: 2 years of experience in the retail industry or a related domain with following skill sets:

1. Cloud Technologies:

Google Cloud Platform (Cloud Functions, Cloud Composer (Airflow), Dataproc, Big Query, Google Kubernetes Engine (GKE), Cloud Spanner, Source Repositories, Bigtable, Datastore)

AWS (S3, Lambda, Apache Spark, AWS RDS)

DBT Labs

2. Database:

Neo4j (Graph DB), Cypher Query Language (CQL)

MS SQL Server, MySQL, TSQL, MDX,

Relational Database Management Systems (RDMS), Data warehouse Design.

3. ETL Tools:

SQL Server Integration Service (SSIS), Informatica, MuleSoft

4. Analytical Tools:

MS Power BI, Tableau, Looker, SSRS

5. Strong programming skills in languages such as Python, Java, or Scala.
6. Experience with data warehousing and big data technologies.
7. Understanding of data governance, security, and compliance best practices.
8. Excellent problem-solving and communication skills.

Employer will accept any suitable combination of education, training or experience.

Job site:

The job is currently located in Cranbury, New Jersey. There is a possibility of medium to long term relocation to either Pittsburgh, PA or other unanticipated sites throughout the U.S. The position is 40 hours per week, 9:00 a.m.- 5:00 p.m., Monday-Friday.  
Please send resume to:

Suvarna Nikam
SVP – Human Resources
Visionet Systems, Inc.
4B CedarBrook Drive
Cranbury, NJ 08512
(609) 452-0700
REF: MRN