Globality Data Engineer/Analyst with PowerBI(5+ year of exp) Job at Black Rock Groups, Durham, NC

U0lNRDhXZ3RHQ09xT29SajJLV3R0OEhDNXc9PQ==
  • Black Rock Groups
  • 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

Domino's Franchise

Delivery Driver - 341 Town Center Ln. Job at Domino's Franchise

 ...direct result of the loyalty and pride our team members exhibit on a daily basis. Our company is truly fortunate, as we have some of the...  ...Do you like money in your pocket? Domino's Pizza drivers arepaid cash nightly, which includes: tips and mileage reimbursement!... 

Amentum

Aircraft Mechanic Job at Amentum

The CBP Aircraft Mechanic performs maintenance, overhaul, repair, inspection, and aircraft servicing functions on assigned aircraft within an aircraft maintenance and operations environment and in accordance with applicable instructions.Principal Accountabilities:+ Perform... 

Re Focus LLC

Network Security Proxy Engineer Job at Re Focus LLC

 ...5-7 years of experience enterprise / data center env. Current experience building Web Proxy - Bluecoat Network Migration experience Network Security experience Network Automation experience Nice to Have: SASE SWG Palo Alto Broadcom... 

Casa Monica Resort and Spa

Banquet Server On Call Job at Casa Monica Resort and Spa

Banquet Server On Call Location Saint Augustine, FL : Overview: AN INSPIRING CAREER AWAITS YOU! The Kessler Collection is made up of 12 artful hotel and resort properties, 25 restaurants, and over 1,700 Grand Performers across seven states, we continue to grow and so... 

Pacific Aviation

Baggage Handler MYR Job at Pacific Aviation

Our Pacific Aviation/SAS family creates an environment where, together, we can all succeed. Pacific Aviation, Superior Aircraft Services (SAS), is an airport-handling provider committed to delivering exceptional service for some of the worlds leading airlines. For ...