Job Description Summary

Job Description

Roles and Responsibilities

• Develop and maintain robust data pipelines, data models, and ETL processes to facilitate data extraction, transformation, and loading.

• Establish secure and efficient data connections from various tools (Aha, Salesforce, ServiceNow, ADO, Oracle P6) and integrate them into the BI & Reporting platform.

• Create and schedule data processing jobs to automate data ingestion, transformation, and updates across multiple data sources.

• Collaborate closely with data engineers, analysts, and other stakeholders to understand data requirements and optimize the data flow architecture.

• Design, implement, and optimize the data architecture for large-scale data repositories such as Data Warehouses and Data Lakes.

• Ensure data quality, consistency, and integrity throughout the data lifecycle.

• Leverage SQL and big data tools (e.g., Hadoop, Spark) for data manipulation and optimization.

• Support the BI team in building data semantic layers and data marts to facilitate report generation and dashboard creation.

• Design and create visualizations, dashboards, and reports using Tableau and/or Power BI.

• Monitor, troubleshoot, and resolve issues in data pipelines and data integration processes.

• Document data processes, architecture, and best practices for future reference and knowledge sharing.

Desired Characteristics & Technical Expertise

• Bachelor’s Degree in Computer Science, Information Technology, or a related field.

• 5 to 8 years of experience in data engineering, BI development and data integration.

• Proficiency in designing and developing end-to-end data pipelines, including ETL processes.

• Hands-on experience with data integration tools and platforms.

• Strong knowledge of SQL and experience with big data technologies such as Hadoop, Spark, or similar.

• Familiarity with enterprise tools like Aha, Salesforce, ServiceNow, ADO, Marketo and Oracle P6 etc. for data extraction and integration.

• Expertise in setting up data pipelines, scheduling data jobs, and automating data workflows.

• Experience with data modeling techniques, including OLAP and data marts.

• Knowledge of data architecture principles and best practices for building scalable data solutions.

• Develop customized visuals and layouts that prioritize key KPIs, providing clear and concise insights that align with business objectives.

• Implement UX best practices to improve navigation, data storytelling, and the overall usability of dashboards, ensuring that reports are actionable and user-friendly.

• Strong problem-solving skills with attention to detail in data processing.

• Ability to work independently and collaborate effectively across teams.

• Excellent communication skills to convey technical solutions to non-technical stakeholders.

• Self-motivated with a drive to continuously improve data processes and explore new technologies.

Business Acumen:

• Understands the technology landscape, up to date on current technology trends and new technology, brings new ideas to the team.

• Displays understanding of the project's value proposition for the customer. Shows commitment to deliver the best value proposition for the targeted customer.

• Learns organization vision statement and decision-making framework. Able to understand how team and personal goals/objectives contribute to the organization vision

Leadership Attributes:

• Voices opinions and presents clear rationale. Uses data or factual evidence to influence.

• Learns organization vision statement and decision-making framework. Able to understand how team and personal goals/objectives contribute to the organization vision.

• Completes assigned tasks on time and with high quality. Takes independent responsibility for assigned deliverables.

• Seeks to understand problems thoroughly before implementing solutions. Asks questions to clarify requirements when ambiguities are present.

• Identifies opportunities for innovation and offers new ideas. Takes the initiative to experiment with new software frameworks

• Adapts to new environments and changing requirements. Pivots quickly as needed. When coached, responds to need & seeks info from other sources.

#LI-CK1

Additional Information