Software Engineer

Responsibilities

• Write, maintain, and continuously optimize SQL‑based code for data transformation and reporting
• Refactor and improve existing SQL logic to enhance performance, readability, and scalability
• Design, build, and maintain relational data models to support BI and analytics use cases
• Construct and manage dimensions, measures, and calculated fields within relational models
• Ensure consistency, accuracy, and reuse of business logic across datasets, models, and reports
• Collaborate with BI developers and business stakeholders to translate requirements into data structures and calculations
• Develop, maintain, and enhance ETL processes for ingesting and transforming data from multiple sources
• Monitor, troubleshoot, and resolve ETL job failures or performance issues
• Validate and test data pipelines and models to ensure high data quality and integrity
• Document data models, transformations, and definitions to support transparency, governance, and reuse

Skills, Knowledge & Expertise

• Strong SQL expertise with a focus on performance tuning and scalable query design
• Solid experience with relational data modeling (facts, dimensions, star/snowflake schemas)
• Experience designing and maintaining ETL processes
• Ability to define and implement consistent business logic in data models
• Strong data validation, testing, and troubleshooting skills

• Understanding of business intelligence concepts, KPIs, and analytical use cases
• Experience supporting reporting and analytics tools through well‑structured data models
• Ability to bridge business requirements and technical implementation

• Strong collaboration skills and ability to work with both technical and non‑technical stakeholders
• Structured and detail‑oriented approach to data quality, documentation, and maintainability
• Problem‑solving mindset with a focus on continuous improvement

• Experience with modern BI platforms and data warehousing environments
• Familiarity with ERP or enterprise data domains (finance, sales, supply chain, operations)
• Exposure to data governance, naming standards, and best‑practice BI architecture