Pentaho Data Warehouse Engineer - Virginia, United States - Cloud Analytics Technologies LLC

Cloud Analytics Technologies LLC Virginia, United States

3 weeks ago

Description

Work Authorization:
US Citizen, Green Card, H-1B, GC-EAD, L2-EAD, TN Visa

Local Candidates Preferred. Non-local candidates must be willing to pay for your own interview travel expenses and relocation costs
**Candidates submitted over the max. bill rate will be automatically disqualified and counted as a submittal. For each position CBD allows only 2 (two) submittals from our
sub-vendors/partners. So please send us only the exact matching profiles for better chances of shortlisting and quick response.
Job Description

Role :
Pentaho Data Warehouse Engineer

Location :

FALLS CHURCH
Duration : 12 Months

Rate :
$55 On C2C (Max)

Job Description:
Data Warehouse Engineer - Pentaho Data Integration (PDI)

Key requirements:

MUST HAVE:
Pentaho Data Integration (PDI)

ETL
MS-SSIS
Erwin

Type of Experience Needed:
Pentaho Data Integration (PDI)
8 years with Relational Databases
4-8 years with
ETL
8 years with Data Mart Modeling Schemas
8 years with SQL Server management
8 years with SQL Server Analysis Services, Reporting Services and Integration Services
8 years with Requirements Gathering
8 years with SQL Programming
8 years with Microsoft Office

Project:

Project is for the development of data marts using Pentaho Data Integration (PDI) for data analytics for clients ongoing Enterprise Data Strategy program.

Specific client OLTP (Oracle) databases will be used and
ETL jobs will be developed.
The project also involves the technical documentation of the
ETL jobs developed.

Overall Purpose:
Leads projects in designing enterprise data reporting architecture that includes strategic reporting databases, data marts and data warehouses.
Creates complex
ETL packages to extract data from various data sources and load into data warehouse.
Takes ownership of system structure integrity and data integrity.

Serves as technical team leader in the development of business intelligence solutions and other reports based on data from various sources.

The positions essential duties include the following:

Works together with IT management in defining enterprise data architecture strategy
Teams up with clients Programs and Architecture on implementing the data architecture consistently across vendor-hosted and client-operated data centers
Leads in designing and revising data model for data warehouse, and meta data and data dictionaries across the enterprise
Meets and collaborates with business users on requirements and objectives
Leads in reviewing and revising database designs and scripts on an ongoing basis
Leads in documenting meta-data about Data Warehouse System according to computer industry standards and knowledge of database management systems.
Manages data loads, and security, storage and performance strategies and implementations.
Serves as technical team lead in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems

Conducts complex analyses of strategic issues based on analysis of trends and interrelationships of key performance drivers documented in the data warehouse, especially the identification of test and control groups and comparison and evaluation of their relative performance; synthesizes research results and develops actionable strategic recommendations; communicates research results and strategic recommendations to nationwide and division strategy managers.

Devises ER diagrams and identifies unique foreign keys, entities, attributes, relationships and business rules for data warehouse

Please identify the key requirements (must-haves) for this candidate.
a. Experience with Pentaho Data Integration
b. Experience with Data Modelling
c. Experience with Data Warehousing
d. Experience with
ETL, Jobs, Scheduling Maintenance etc
e. Experience with Pentaho Business Analytics
f. Experience working with HP Vertica or any other Columnar Database

Equal Opportunity Employer Cloud Big Data Technologies is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V).

Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status.

Cloud Big Data Technologies will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters.

Nor will Cloud Big Data Technologies require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract

Equal Opportunity Employer Cloud Big Data Technologies is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V).

Business Information Developer Consultant

3 weeks ago

Elevance Health Virginia, United States

Business Information Developer Consultant (Level 3 Data Engineer) · Location: · This position will work a hybrid model (remote and in office 1 - 2 days per week). Ideal candidates will live or be willing to relocate to within 50 miles of our Pulse Point location in Richmond, VA. ...
Business Information Developer

1 week ago

Elevance Health Virginia, United States

Business Information Developer (Level 1 Data Engineer) · Location: · This position will work a hybrid model (remote and in office 1 - 2 days per week). Ideal candidates will live within 50 miles of our Pulse Point location in Richmond, VA · The · Business Information Developer ...
Software Engineer, Reporting Services, EDW

3 weeks ago

Hellenic Bank Group Virginia, United States

Software Engineer, Reporting Services, EDW · Hellenic Bank Public Company Limited, one of the leading Financial Institutions in Cyprus, is seeking to recruit a Data Engineer at Enterprise Data Warehouse (EDW). · As a member of EDW you will play a significant role in organization ...
Industrial Engineer

3 weeks ago

Kion Group AG Virginia, United States

Industrial Engineer is the responsible to assure work balance in assembly lines, define correct standar work , define cycle times, with proper lay out and material flow, confirming ergonomy correct for personal working on production lines. · What we offer: · Dematic is an intra ...
Lead Azure Data engineer

3 weeks ago

Accord Technologies Inc Virginia, United States

Title: Lead Azure Data engineer · Location: Glen Allen, VA · Duration: 12 months contract · Hire type : Hybrid (3 days min onsite mandatory) · Nbr of positions: 1 · Job requirement: · 9+ years of experience in leading the design and development of data and analytics project ...
Senior Database Architect

2 weeks ago

Syms Strategic Group, LLC Virginia, United States

Syms Strategic Group (SSG) · is seeking a talented · Senior Database Architect · Department: · Veterans Affairs · Location: · On-site, Washington, DC · Type: · Full Time · Min. Experience: · Experienced · Security Clearance Level: · Public Trust (MBI) · Salary Range: · $1 ...
Cloud Data Engineer

2 weeks ago

Abs Data Virginia, United States

Job title: · Cloud Data Engineer – Active US Security Clearance Required · Company: · Deloitte · Job description : · Position Summary · Cloud Data Engineer · In this age of disruption, organizations need to navigate the future with confidence by tapping into the power of d ...
Cloud Data Engineer

3 weeks ago

Abs Data Virginia, United States

Job title: · Cloud Data Engineer – Active US Security Clearance Required · Company: · Deloitte · Job description : · Position Summary · Cloud Data Engineer · In this age of disruption, organizations need to navigate the future with confidence by tapping into the power of d ...
Senior Cloud Data Engineer

3 weeks ago

Abs Data Virginia, United States

Job title: · Senior Cloud Data Engineer – Active US Security Clearance Required · Company: · Deloitte · Job description : · Position Summary · Senior Cloud Data Engineer · In this age of disruption, organizations need to navigate the future with confidence by tapping into ...
IT Network Administrator

3 weeks ago

Standard Motor Products Virginia, United States

SMP, 7070 Golf Course Drive, Disputanta, Virginia, United States of America · Req #246 · Monday, March 11, 2024 · Established in 1919 and traded on the NYSE, Standard Motor Products, Inc. (SMP) is a leading independent manufacturer and distributor of premium automotive replaceme ...
Sr. IT Business Systems Analyst

4 weeks ago

Ferguson Enterprises Virginia, United States

Sr. IT Business Systems Analyst - Warehousing & Distribution (Hybrid) page is loaded · Sr. IT Business Systems Analyst - Warehousing & Distribution (Hybrid) · Apply · locations · Newport News, VA · time type · Full time · posted on · Posted 28 Days Ago · job requisition ...
Cloud Data Engineer

2 weeks ago

Leidos Virginia, United States

Looking for an opportunity to make an impact? · Leidos is seeking a seeking a customer experience focused · Microsoft · Azure · Cloud · Data Engineer · to work with a team of subject matter experts and developers to design and implement full lifecycle data pipeline services ...
Data Scientist

4 weeks ago

Motion Recruitment Partners LLC Virginia, United States

A provider of analytics and software services for the intelligence and defense communities is seeking a Data scientist. You would be at the forefront of designing, developing, and validating AI/ML solutions. In summary, this position offer a unique opportunity to shape data-drive ...
Database Developer

2 weeks ago

Leidos Virginia, United States

Ready for a rewarding career opportunity? · Unleash Your Potential at Leidos, where we deliver innovative solutions through the efforts of our diverse and talented people who are dedicated to our customer's success. We empower our teams, contribute to our communities, and operate ...
manager, osp construction

2 weeks ago

Lumos Inc Virginia, United States

Company Overview: · We're Lumos, a provider of 100% Fiber Optic Internet, Total-Home Wi-Fi, · voice and streaming services across North Carolina, South Carolina and Virginia. · We believe that the possibilities of tomorrow cannot be built on the infrastructure of yesterday. Tha ...
Lead Data Modeler

5 days ago

Ábaco Strategy, LLC Virginia, United States

Abaco Strategy, LLC (Abaco) is an 8(a) Certified, HUBZone, Woman Owned, Small Business located in Leesburg, VA. Abaco provides Information Technology and Consulting Services to Commercial customers and the Federal Government. We deliver technology enabled, results oriented soluti ...
Program Analyst

3 weeks ago

Amentum Virginia, United States

Amentum is seeking a full time Program Analyst to support and advise the Program Manager (PM) in planning, managing, and evaluating programs, operations, and processes. The candidate will collaborate with the Program Management Office (PMO) Team to provide technical support servi ...
Senior Consultant Financial Risk Management

3 weeks ago

FI Consulting Virginia, United States

For more than 20 years, financial institutions in the Federal,privateand public sectors have called on FI Consulting to address complex and high-stakes analytical challenges that are closely scrutinized by executives, auditors,regulatorsand stakeholders. We help clients succeed b ...
Quality Engineering Lead

3 weeks ago

Ferguson Enterprises Virginia, United States

Quality Engineering Lead - Supply Chain Technology (Hybrid) page is loaded · Quality Engineering Lead - Supply Chain Technology (Hybrid) · Apply · locations · Newport News, VA · time type · Full time · posted on · Posted 2 Days Ago · job requisition id · R · Job Postin ...
Area Manager 2024

2 weeks ago

Amazon Virginia, United States

Area Manager 2024 (Virginia) Entry Level · Job ID: | Services LLC · Amazon is looking for bright leaders to lead large non-exempt teams across our cutting-edge fulfillment network This is not a corporate, office-based position. This is a full-time position located within one of ...