Sr Data Analyst - BTS Application Systems

• Design, develop, enhance, and maintain Microsoft Fabric Data Pipelines for extracting and loading data from enterprise source systems.
• Build integrations with JDE, Oracle, SQL Server, and other relational data platforms to ingest data into Microsoft Fabric.
• Develop and maintain PySpark notebooks for data processing and transformation within the Fabric Lakehouse, primarily supporting Bronze-to-Silver processing.
• Develop advanced SQL queries, views, stored procedures, and transformation logic within Fabric Warehouse to support Silver-to-Gold data processing.
• Implement incremental loading, change-data processing, historical loads, and other appropriate ingestion patterns based on source-system requirements.
• Design and maintain data structures in the Fabric Lakehouse and Warehouse that support enterprise analytics and downstream Power BI semantic models.
• Monitor scheduled data pipelines and data loads, troubleshoot failures, identify root causes, and implement permanent solutions for recurring issues.
• Perform data validation and reconciliation between source systems and Fabric to ensure completeness, accuracy, and consistency.
• Optimize PySpark, SQL, stored procedures, pipelines, and warehouse processes for performance and scalability.
• Maintain existing production data pipelines and enhance them as business and technical requirements evolve.
• Collaborate with analysts, Power BI developers, application teams, and business stakeholders to understand data requirements and deliver trusted data for reporting and analytics.
• data governance, security, access control, naming, and development standards across Fabric solutions.
• Maintain technical documentation for data pipelines, notebooks, data transformations, source-to-target mappings, dependencies, and operational support procedures

• BE/B.Tech/Diploma in Computer Science/Data Engineering
• 8-10 years’ experience of relevant experience
• Knowledge of the organization’s JDE data structures, business processes, and system integrations, including how data from JDE, Oracle, SQL Server, and other enterprise applications is used across business functions.

• Strong proficiency in SQL, including complex queries, joins, performance tuning, stored procedures, and data transformation.
• Hands-on experience with Microsoft Fabric, including Data Pipelines, Lakehouse, Warehouse, notebooks, and data integration capabilities.
• Proficiency in PySpark for large-scale data processing, cleansing, transformation, and movement across Bronze and Silver data layers.
• Experience designing and supporting ETL/ELT data pipelines integrating data from JDE, Oracle, SQL Server, and other enterprise data sources.
• Strong understanding of data lake, data warehouse, dimensional modeling, and Medallion architecture (Bronze/Silver/Gold) concepts.
• Ability to troubleshoot pipeline failures, data quality issues, SQL performance problems, and source-system integration issues.
• Experience with data reconciliation and validation techniques to ensure completeness and accuracy between source and target systems.
• Working knowledge of Power BI and semantic models to understand how engineered data is consumed by downstream analytics and reporting solutions

Christie is an equal opportunity employer that does not unlawfully discriminate against any employee or applicant on the basis of race, ancestry, place of origin, color, ethnic origin, citizenship, religion, gender identity, gender expression, creed, sex, sexual orientation, age, record of offences, marital status, family status or disability.