Senior Developer, BI Data Services

Job Description

Job Description

Job Title : Senior Developer, BI Data Services

The Senior Developer, BI Data Services involves leading the design, development, and implementation of enterprise data solutions, ensuring robust data systems, and enhancing data consumption capabilities across the organization. The ideal candidate will have expertise in data systems architecture, ETL / ELT development, and modern data technologies, with a strong focus on cloud platforms. This position requires collaboration with various departments, providing technical support, optimizing data queries, and driving business intelligence initiatives to support a data-driven decision-making process.

Responsibilities :

Execute the design, build, and implementation of enterprise-grade data solutions for large-scale, multi-tenant data systems, including data warehouses, data marts, and data lakes.

Perform complex systems development and design work, including logic and architecture design for on-premise and cloud-based data solutions. Produce high-quality, well-architected solutions with an upfront focus on testing and long-term support.

Analyze and identify source-to-target mappings, develop ETL / ELT specifications, and perform ETL / ELT development, deployment, and monitoring for enterprise data systems.

Execute Data Services strategy utilizing modern data technologies, including Cloud data platforms and services (e.g., Azure, AWS, GCP, SAP), data pipeline tools, and analytics services.

Deliver on Business Intelligence & Analytics strategy for assigned domains leveraging SAP Business Warehouse, Business Objects (BW 7.5 on HANA, BO Enterprise, Analysis for Office, Lumira Designer & Discovery, and WebI), PowerBI, and drive alignment with business partners for execution support.

Own technical responsibility for assigned BW backend data architecture for SAP and non-SAP data sources.

Review completion and implementation of system additions and / or enhancements and make recommendations for future development.

Collaborate with engineering and business stakeholders to understand data requirements and coordinate activities to facilitate internal and user acceptance testing.

Design and build BI reports & queries using applicable SAP, Business Objects, PowerBI, or other reporting tools and support query optimization.

Provide production support for existing BI applications and systems. Resolve second- and third-tier Help Desk tickets related to data sources, data warehouses, and reporting solutions; troubleshoot data issues, ETL / ELT chains, and reports. Provide daily technical and functional support as well as during maintenance.

Maintain day-to-day tracking and follow-up on issues and questions of daily operations, including tracking, updating, and resolving issues.

Stay updated on tools, methods, and techniques, acting as an internal resource for Data technologies and solutions.

Participate in the design and planning of projects in conjunction with external partners and other IT members.

Support and adhere to data & reporting standards and frameworks ensuring consistency and quality.

Drive workshops or training sessions with the business user community to further their knowledge and use of Data, Reporting, and Visualization tools.

Additional duties as assigned by supervisor or management.

Qualifications :

Bachelor’s Degree in a related field or equivalent work experience in a quantitative and engineering discipline. In lieu of a degree, 7 years of experience or an equivalent combination of education and experience required. A Bachelor of Science or Master’s degree in Computer Science, Software Engineering, Computer Engineering, Information Systems, or a similar field is preferred.

5 years of experience in Business Intelligence / Decision Support / Data Engineering / Data Warehousing roles working with multiple disparate, large, complex datasets required. 7 years of experience with SAP BW and BI solutions with a detailed understanding of SAP BI technology and its application preferred.

Advanced knowledge of and experience in Data Warehouse concepts (modeling, tuning, maintenance), data modeling, SQL, and ETL / ELT technologies.

5 years of proven system / application experience in building SAP BW and BI solutions.

Experience in business analytics, including enterprise reporting, executive dashboards, scorecards, alerts, and subscription push reporting.

Strong knowledge & experience in SAP BW & HANA modeling, ABAP / 4, and AMDP code design and development, including ABAP Programs, Custom Objects, and HANA Views.

Hands-on experience with ABAP to write Data source Enhancements Function Module, extractors, and Transformation Routines; experience in writing Transformations using AMDP scripts.

Strong experience with BI analytical tools (Power BI or similar) and Business Objects (Analysis for Office AO Reports, Web I, Design Studio) based development integrated with an SAP BW and non-SAP environment (SAP as the primary data source). SAP Data sphere, SAP Analytics Cloud, and Tableau experience is a plus.

Preferred :

3 years of experience with Cloud data platforms and services, building Data Marts / Warehouses / Lakes, Pipelines, and Datasets utilizing Microsoft Azure, AWS, or Datasphere.

Experience with ERP systems and familiarity with manufacturing industry processes, including supply chain management.

Experience with modern reporting and analytics tools such as Business Objects, Power BI, Tableau, Domo, Qlik, Looker, and Alteryx.

Experience in advanced analytics, including corporate performance management and predictive analysis.

Exposure to cloud architecture for BI, Data Warehousing, Data Marts, Data Lakes, in-memory data exploration tools, and other data warehousing analytics solutions.

Experience managing large volumes of data and designing / building / optimizing for performance.

Work experience with external partners or third parties in an offshore / onshore delivery model.

Experience working with Python and R, particularly for ETL or Data Science-related tasks.

Ability to identify, propose, and influence technology solutions to improve and maintain optimal data and architecture to support business requirements.

Some background in data structures, algorithms, and debugging.