Senior Data Engineer Pentaho

4 weeks ago

Washington, United States Mindlance Full time
Position Summary:

Title: Senior Data Engineer - Pentaho
Duration: 6 Months - Long Term
Location: Washington, DC 20005

Hybrid Onsite: 2/3 days per week from Day1

Candidate should be comfortable with picking up official laptop from Client place during the onboarding process once offered.

Summary/Objective:
The Senior Data Engineer will execute on implementing business intelligence solutions across all divisions of the organization . The individual in this role will guide the team in the design and implementation of each solution and will implement improvements of technical standards, development processes, governance, and technologies.

Essential Duties And Responsibilities:
  • Serve as a technical lead in the development of business intelligence solutions.
  • Coordinate with scrum masters / project managers on optimizing scheduling, work allocations, and story assignments.
  • Manage reporting environment including data sources, connections, security, subscriptions and metadata.
  • Assist in initiative towards data access control and integrity across the enterprise.
  • Create data models and schema for reliable and highly performant data marts and data warehouse.
  • Develops complex ETL (extract, transform and load) SQL scripts to gather data from various databases and systems to make data available for enterprise analytics and reporting.
  • Evaluate, test and implement new or upgraded software.
  • Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution.
  • Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports.
  • Identify areas for improvement within the EDS organization related to architecture, design, performance optimization, development process, workflows, governance, tools/technologies.
  • Conduct end user training on data solutions.

Core Competencies:
Forward Thinking: The ability to anticipate the implications and consequences of situations and take appropriate action to be prepared for possible contingencies.
Thinks Critically: The ability to approach ones work analytically by identifying issues/questions, gathering and evaluating data, and creating evidence-based recommendations or solutions.
Embrace Innovation & Change: The ability to respond positively to change and demonstrate flexibility, and openness to new ways of thinking and doing things.
Communicate Openly & Effectively: The ability to effectively communicate in multiple modes and in a way that fosters understanding and dialogue, as well as engages with others in a way that demonstrates emotional intelligence.
Performance Focused: The ability to take ownership for ones own or ones employees performance, by setting clear goals and expectations, tracking progress against the goals, providing feedback, and addressing performance problems and issues promptly
Apply Customer Lens: The ability to provide the best service to customers (internal and external) with the goal of exceeding their expectations while maintaining integrity.
Develop Self & Others: The ability to identify, learn, and apply new skills or habits as needed to perform successfully on the job.
Foster Collaboration: The ability to look beyond immediate teams, broaden peer networks, and finding ways to partner with internal and external stakeholders to achieve success.

Education, Experience And Skills:
  • Bachelor Degree and/or relevant technical training with no preferred certification.
  • Over 8-10 years of experience in the field of Information Technology with proficiency in ETL design/development and Data Warehouse implementation/development
  • Experienced in Design, Development and Implementation of large - scale projects in Financial, Shipping and Retail industries using Data Warehousing ETL tools (Pentaho)
  • Knowledge about Software Development Lifecycle (SDLC), Agile, CI/CD deployment
  • Experience in Architecting and building Data Warehouse systems and Business Intelligence systems including ETL using Pentaho BI Suite (Pentaho Data Integration Designer / Kettle)
  • Hands on experience on the whole ETL (Extract Transformation & Load) process
  • Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon designer and Pentaho Data Integration Designer and scheduling
  • Used various steps in Pentaho transformations including Row Normalizer, Row Demoralizer, Database Lookup, Database Join, Calculator, Add Sequence, Add Constants and various types of inputs and outputs for various data sources including Tables, Access, Text File, Excel and CSV file
  • Integrating Kettle (ETL) with Hadoop and other various NoSQL data and loaded unstructured data into Hadoop File System (HDFS)
  • Experience in performing Data Masking/Protection using Pentaho Data Integration (Kettle)
  • Strong development experience in writing PL/SQL Stored Procedures, Functions, packages and debugging the code
  • Strong development experience working with Columnar DBs preferably Client Vertica
  • Strong expertise in Developing and Debugging MSSQL or PostgreSQL SQL scripts, functions, stored
  • procedures, views, complex SQL queries, cursors, and triggers
  • Expertise in Performance tuning, Query optimization and exception handling

  • Senior Network Engineer

    4 days ago

    Washington, United States NTT DATA Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Create Alert NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Senior Network...

  • Senior Network Engineer

    2 days ago

    Washington, United States NTT DATA Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Create Alert NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Senior Network...

  • Senior Network Engineer

    4 days ago

    Washington, Washington, D.C., United States NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Senior Network Engineer to join our team in Washington, District of Columbia (US-DC), United States (US).Job...

  • Senior Network Engineer

    2 days ago

    Washington, Washington, D.C., United States NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Senior Network Engineer to join our team in Washington, District of Columbia (US-DC), United States (US).Job...

  • Senior Network Engineer

    5 days ago

    Washington, United States NTT DATA Services Full time

    Req ID: 284043  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Senior Network Engineer to join our team in Washington, District of Columbia (US-DC), United...

  • Senior Network Engineer

    11 hours ago

    Washington, United States NTT DATA Services Full time

    Req ID: 284043  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Senior Network Engineer to join our team in Washington, District of Columbia (US-DC), United...

  • Network Engineering Senior Specialist

    4 days ago

    Washington, Washington, D.C., United States NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Network Engineering Senior Specialist to join our team in Washington, District of Columbia (US-DC), United States...

  • Senior Data Engineer

    4 days ago

    Washington, Washington, D.C., United States Bates White Full time

    Bates White seeks a Senior Data Engineer in Washington, DC to design and develop ongoing data ingestion using Python and Spark. Support Requirements Gathering activities, especially from the data migration perspective. Use programming skills to create big data pipelines that can deal with both structured and unstructured data. Support other teams in...

  • Senior Data Engineer

    2 days ago

    Washington, Washington, D.C., United States Bates White Full time

    Bates White seeks a Senior Data Engineer in Washington, DC to design and develop ongoing data ingestion using Python and Spark. Support Requirements Gathering activities, especially from the data migration perspective. Use programming skills to create big data pipelines that can deal with both structured and unstructured data. Support other teams in...

  • Senior Data Engineer

    3 weeks ago

    Washington, United States Shara Inc Full time

    Job DescriptionJob DescriptionSalary: Job Title: Senior Data EngineerLocation: Ideally based in one of Shara's hubs in Washington DC, Nairobi, Lagos, or Abuja.Travel: occasional trips (2-4x per year) to Washington DC, Nairobi or LagosAt Shara, we’re building for a future where African banking is free, frictionless, and driven by user experience. Where...

  • Senior Data Engineer

    22 hours ago

    Washington, United States Shara Inc Full time

    Job DescriptionJob DescriptionSalary: Job Title: Senior Data EngineerLocation: Ideally based in one of Shara's hubs in Washington DC, Nairobi, Lagos, or Abuja.Travel: occasional trips (2-4x per year) to Washington DC, Nairobi or LagosAt Shara, we’re building for a future where African banking is free, frictionless, and driven by user experience. Where...

  • Network Engineering Senior Specialist

    5 days ago

    Washington, United States NTT DATA Services Full time

    Req ID: 284043  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Network Engineering Senior Specialist to join our team in Washington, District of Columbia...

  • Network Engineering Senior Specialist

    2 days ago

    Washington, United States NTT DATA Services Full time

    Req ID: 284043  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Network Engineering Senior Specialist to join our team in Washington, District of Columbia...

  • Senior Data Engineer

    2 weeks ago

    Washington, United States Citian Full time

    Citian is seeking a passionate and self-motivated Senior Data Engineer with expertise in architecting and building data pipelines to join our dynamic team! You will contribute to developing secure, scalable, and efficient data-driven solutions to tackle pressing needs in our transportation systems.Who We Are:Citian is a fast growing, venture backed SaaS...

  • Senior Data Engineer

    2 weeks ago

    Washington, United States Citian Full time

    Citian is seeking a passionate and self-motivated Senior Data Engineer with expertise in architecting and building data pipelines to join our dynamic team! You will contribute to developing secure, scalable, and efficient data-driven solutions to tackle pressing needs in our transportation systems.Who We Are:Citian is a fast growing, venture backed SaaS...

  • Senior Data Engineer

    1 week ago

    Washington, United States Citian Full time

    Citian is seeking a passionate and self-motivated Senior Data Engineer with expertise in architecting and building data pipelines to join our dynamic team! You will contribute to developing secure, scalable, and efficient data-driven solutions to tackle pressing needs in our transportation systems.Who We Are:Citian is a fast growing, venture backed SaaS...

  • Senior Data Engineer

    19 hours ago

    Washington, United States Citian Full time

    Citian is seeking a passionate and self-motivated Senior Data Engineer with expertise in architecting and building data pipelines to join our dynamic team! You will contribute to developing secure, scalable, and efficient data-driven solutions to tackle pressing needs in our transportation systems.Who We Are:Citian is a fast growing, venture backed SaaS...

  • Senior Data Engineer

    2 days ago

    Washington, United States Citian Full time

    Citian is seeking a passionate and self-motivated Senior Data Engineer with expertise in architecting and building data pipelines to join our dynamic team! You will contribute to developing secure, scalable, and efficient data-driven solutions to tackle pressing needs in our transportation systems.Who We Are:Citian is a fast growing, venture backed SaaS...

  • Senior Data Engineer

    1 week ago

    Washington, Washington, D.C., United States Amentum Full time

    Amentum is seeking a Senior Data Engineer (RDT&E) to support a DIA Analytic Innovations Office Advanced Analytics & Product Evaluation contract. This position is based in Washington, D.C. All employees will start in the Washington D.C office but upon request and with customer approval may be allowed to work from Reston VA, Quantico VA, or College Park...

  • Senior Data Engineer

    2 days ago

    Washington, Washington, D.C., United States Amentum Full time

    Amentum is seeking a Senior Data Engineer (RDT&E) to support a DIA Analytic Innovations Office Advanced Analytics & Product Evaluation contract. This position is based in Washington, D.C. All employees will start in the Washington D.C office but upon request and with customer approval may be allowed to work from Reston VA, Quantico VA, or College Park...