Job Description Summary
The BI & Reporting Data Engineer will play a key role in building the data infrastructure and platform necessary for the BI & Reporting COE. This position focuses on the end-to-end development of data solutions, including data pipeline creation, data transformation, and tool integration, to support business analytics and reporting. The Data Engineer will work with various data sources, such as Aha, Salesforce, ServiceNow, ADO, Marketo, Oracle P6, etc. to establish reliable data connections and streamline the data flow for reporting and analysis.
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.
Additional Information
Relocation Assistance Provided: Yes
