Globality Data Engineer/Analyst with PowerBI(5+ year of exp) Job at Vinsys Information Technology Inc, Durham, NC

TUE1OXFpelBzRzZTMTJoUVRnZmtKMmtiV2c9PQ==
  • Vinsys Information Technology Inc
  • Durham, NC

Job Description

Candidate must sit in Smithfield, RI. As a 2nd option, Westlake, TX can also be a location.

Must Have Skills:

  • 10+ years of Data Engineer/Analytics Exp
  • Strong database design, relational and dimensional modeling, and SQL skills
  • PowerBI and Tableau
  • Experience working with Snowflake
  • Python
  • MySQL
  • Business Analyst Skills

Plus Skills:

  • Informatica

Preferred Skills: data warehousing and database performance tuning
Domain Knowledge: Retirement, 401K, Defined Contribution
Location: onsite 2 weeks per month in Smithfield, RI (2nd option is WLK Texas)

Connect Week: Candidate will be required and commit to sit on site 2 weeks (5 days)/each Month on a rotation at Locations below:

  • Smithfield, RI
  • 2nd Option: Weltlake, TX

Data migration requirements
The data types and attributes to be mapped and migrated include all data points from source systems. This includes derived data sets, reference data, and data points used in analytic packages, investment trends, scatter plots, and seismic outputs. The process involves analyzing and documenting all tables and data elements, mapping them to data lake, identifying gaps, and validating for accuracy. Data completeness will be ensured by performing a thorough gap analysis, documenting all attributes, and addressing missing data elements through work intake processes with data lake team. Additionally, obsolete data sets will be identified and removed to streamline the migration process.

Responsibilities: Collaborate with business stakeholders to understand reporting requirements and data analysis needs. Assist in the design of the database by providing insights into data usage and reporting patterns. Validate data quality and integrity in the new AWS RDS database. Support the development of data governance and data quality frameworks.

Qualifications: Strong analytical skills with experience in data analysis methodologies. Knowledge of database design principles and experience with SQL queries. Familiarity with AWS, Azure and data visualization tools (e.g. Power BI). Understanding of financial data and reporting standards.

Required Skills : Data Analysis

Basic Qualification :

Additional Skills :

This is a high PRIORITY requisition. This is a PROACTIVE requisition

Background Check : No

Drug Screen : No

Job Tags

Similar Jobs

Tacton

3D Artist Job at Tacton

The main purpose of the 3D Artist role is to efficiently create high-quality visualization models for real-time applications, primarily focusing on product configuration. This involves creating 3D content for various customer projects, processing 3D data, managing CAD...

Satori Mortgage (NMLS: 4190)

Mortgage Loan Officer Job at Satori Mortgage (NMLS: 4190)

 ...takes" to smash your goals, showing you know what's up in the mortgage game and have the grit to stick it out. This is one of the...  ...weekend doesn't work, gear up to visit 10, 25, or 50! Our Loan Officers grind beyond "banking hours" and pick up the phone after 5 pm... 

Our National Conversation

Graphic Design Intern Job at Our National Conversation

 ...educational materials and facilitate dialogue intended to make America a better country. Job Description Job Title: Graphic Design Intern Reports To: Graphic Design Team Lead, Director of Marketing, and COO MISSION STATEMENT OUR NATIONAL CONVERSATION (... 

City of Mason City

Library Clerk Job at City of Mason City

 ...essential part in providing excellent service to library patrons. Youll get hands-on experience in various library operations, from assisting patrons at the service desk to helping organize collections. Every day will bring something new as you support the community's... 

Uber

Product Designer II - Rider Job at Uber

**About the Role**The Rider Design team is looking for a Product Designer II to craft thoughtful, scalable solutions to help people go...  ...and the on-trip experience), Mobility Verticals (like Airports, Car Rentals, Shared Rides, and Reserve), and the future of Autonomous...