Senior Data Engineer Pentaho
4 months ago
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 Data Engineer
1 day ago
Washington, United States Mindlance Full timeTitle: Senior Data Engineer - Pentaho Duration: 6 Months - Long Term Location: Washington, DC 20005 Hybrid Onsite: 2/3 days onsite per week from Day1. Candidate should be comfortable to pick official laptop from client location (Washington, DC 20005) after the onboarding process once offered. Summary/Objective: The Senior Data Engineer will execute on...
-
Data Engineering Lead, Senior
13 hours ago
Washington, United States Booz Allen Hamilton Full timeEver-expanding technology like IoT, machine learning, and artificial intelligence means that theres more structured and unstructured data available today than ever before. As a data engineer, you know that organizing big data can yield pivotal insig Data Engineer, Engineer, Lead, Senior, Technology, Data, AWS
-
Data Engineering Lead, Senior
22 hours ago
Washington, United States Booz Allen Hamilton Full timeEver-expanding technology like IoT, machine learning, and artificial intelligence means that theres more structured and unstructured data available today than ever before. As a data engineer, you know that organizing big data can yield pivotal insig Data Engineer, Engineer, Lead, Senior, Technology, Data, AWS
-
Senior Data Engineer
3 weeks ago
Washington, United States Citian Full timeJob DescriptionJob DescriptionCitian is a fast growing, venture backed SaaS technology company based in Washington, DC. Our software solutions revolutionize how our transportation systems – roads, rail, transit, bicycle, pedestrian – operate.Our tech solutions:Reduce traffic fatalitiesEnhance pedestrian accessibilityEmpower system operators to save time...
-
Senior Federal Data Engineer
15 hours ago
Washington, United States International Business Machines Corporation - IBM Full timeA career in IBM Consulting-Federal is rooted by long-term relationships and close collaboration with clients across the globe. You'll work with visionaries across multiple industries to improve the hybrid cloud and AI journey for the most innovative Data Engineer, Engineer, Senior, Database Administrator, Data
-
Senior Informatica Data Engineer
2 weeks ago
Washington, United States TriOptus LLC Full timeRandstad is seeking a Senior Informatica Data Engineer for a client in Washington, DC. This role focuses on designing, implementing, and optimizing data pipelines using Informatica, IDMC, and cloud technologies to manage and transform both structured and unstructured data. The engineer will collaborate with teams to create data solutions aligned with...
-
Senior Big Data Engineer
17 hours ago
Washington, Washington, D.C., United States Blend360 Full timeJob Title: Senior Big Data EngineerBlend360 is seeking a skilled Data Engineer to join its team of experts. As a Data Engineer, you will play a vital role in the company's data engineering team, working with various technologies to deliver high-quality solutions for top clients worldwide.About Blend360:We are a premier AI services provider dedicated to...
-
Senior Data Engineer
2 days ago
Washington, United States US News Full timeDescription U.S. News & World Report is a multifaceted digital media company dedicated to helping citizens, consumers, business leaders and policy officials make important decisions in their lives. We publish independent reporting, rankings, data journalism and advice that has earned the trust of our readers and users for nearly 90 years. Our platforms on...
-
Senior Data Engineer
19 hours ago
Washington, United States US News Full timeDescription U.S. News & World Report is a multifaceted digital media company dedicated to helping citizens, consumers, business leaders and policy officials make important decisions in their lives. We publish independent reporting, rankings, data journalism and advice that has earned the trust of our readers and users for nearly 90 years. Our platforms on...
-
Senior Security Engineer
2 weeks ago
Washington, United States Micro Data Systems Full timeSenior Security EngineerRemote - Washington DC Metro Area preferredYour ImpactWork full-time at the customer siteCommunicate with the customer(s), sales teams, peers, engineering and support teams as appropriateUnderstand the customer environment, requirements, and security roadmap to implement the appropriate security solutionConfigure, implement, and...
-
Data Engineer
2 days ago
Washington, United States Intellibridge Full timeJob Description: (3+) years of experience supporting the development and maintenance of data pipelines and infrastructure on AWS. Help ensure data is accessible, reliable, and efficiently processed to support business analytics and decision-making. Location: DC,Chantilly office Tuesdays and Rosslyn office Wednesdays Responsibilities: Assist in the...
-
Data Scientist
5 days ago
Washington, United States Data Society Full timeWe Are:At Data Society, we provide bespoke, leading-edge data and AI solutions for Fortune 1,000 companies and federal, state, and local governmental organizations. We partner with our clients to educate, equip, and empower their workforces with the skills they need to achieve their goals and expand their impact. We are empowering the workforces of the...
-
Senior Data Engineer
1 month ago
Washington, Washington, D.C., United States Working America Associa Full timeJob SummaryWe are seeking a highly skilled Data Architect to join our team at Working America Associa. As a key member of our data engineering team, you will be responsible for designing, developing, and maintaining robust data pipelines and infrastructure to support our organization's data-driven initiatives.Key ResponsibilitiesTeam Management & Staff...
-
Senior AI Researcher and Data Engineer
17 hours ago
Washington, United States The World Bank Full timeOverviewThe World Bank is seeking a highly skilled Senior AI Researcher and Data Engineer to join our technical team. As a key member of our unit, you will play a pivotal role in developing, assessing, and deploying cutting-edge tools and best practices for applying machine learning and AI to drive positive socio-economic impact in low-income countries.
-
Senior Software Engineer
3 weeks ago
Washington, United States Tyler Technologies Full timeWe are looking for a remarkable Senior Software Engineer to join us! We've built a team of not just the best engineers, but some really awesome humans as well. This team builds cloud software (platform + apps + ecosystem) to accelerate the flow of government data into the hands of citizens, developers, businesses and researchers. With our Data & Insights...
-
Data Engineer
1 week ago
Washington, United States Client Server Software Solutions Full timeJob DescriptionJob DescriptionJob Description:Constellation West is looking for an entry-level to senior-level Data Engineer to support the CDAO's Mission Analytics Directorate through the Advana program, which provides core and data analytics across various domains, including procurement and financial management (FM). By enhancing the integration of...
-
Data Engineer
2 days ago
Washington, United States Constellation West Full timeJob Description: Constellation West is looking for an entry-level to senior-level Data Engineer to support the CDAO's Mission Analytics Directorate through the Advana program, which provides core and data analytics across various domains, including procurement and financial management (FM). By enhancing the integration of procurement and FM datasets, the...
-
Senior Engineer
7 days ago
Washington, United States DAn Solutions, Inc Full timeHigh-Level Description: The Senior Engineer will be responsible for designing, deploying, and maintaining secure, high-performance cross-domain solutions. This role involves collaboration with multiple stakeholders and ensuring adherence to security standards.Detailed Description: The Senior Engineer will take a lead role in designing and implementing...
-
Senior Engineer
2 days ago
Washington, United States DAn Solutions Inc Full timeHigh-Level Description: The Senior Engineer will be responsible for designing, deploying, and maintaining secure, high-performance cross-domain solutions. This role involves collaboration with multiple stakeholders and ensuring adherence to security standards. Detailed Description: The Senior Engineer will take a lead role in designing and implementing...
-
Senior Data Engineer
2 days ago
Washington, United States ACL Digital Full timeJob Title: Senior Power BI Developer">Overview">ACL Digital is seeking a seasoned Senior Power BI Developer to spearhead the development of reporting solutions for its IT Project Management Office (IT PMO). This role will be responsible for designing, implementing, and maintaining BI reporting solutions, ensuring seamless integration with existing...