About the role
The Software Developer will design, develop, and optimize ETL processes and business intelligence (BI) solutions to support enterprise data needs. This role involves loading operational data from multiple sources, cleaning and transforming datasets, and creating self-service BI solutions for business teams. The developer will enhance Power BI dashboards using REST APIs, build Power BI Embedded reports for external websites, and lead the migration of legacy reports from GCP BigQuery and Tableau to Power BI. The role requires developing complex DAX expressions and implementing strategies to improve report efficiency and data accessibility.
Key Responsibilities
- Analyze, design, and develop ETL processes to load data from Oracle, DB2, SQL Server, and flat files into transient tables.
- Clean and transform data using business rules to ensure accuracy and consistency.
- Develop and enhance Power BI dashboards using REST APIs to provide report-level lineage information.
- Create self-service BI solutions for business teams to reduce dependency on the BI team.
- Build Power BI Embedded reports for hosting on external websites.
- Lead the BI strategy for migrating legacy reports in GCP BigQuery and Tableau to Power BI.
- Develop complex DAX expressions using both Import and Direct Query modes to optimize performance.
- Collaborate with stakeholders to ensure BI solutions meet business requirements.
Required Qualifications
- Bachelor’s degree or foreign equivalent in Computer Science, Information Technology, or Engineering.
- Minimum 5 years of relevant experience in software development, ETL, and BI solutions.
- Proficiency in ETL processes, Power BI, and data modeling.
- Strong understanding of database systems including Oracle, DB2, and SQL Server.
- Experience in developing BI strategies and self-service analytics solutions.
Preferred Skills
- Advanced knowledge of Power BI Embedded and REST API integrations.
- Expertise in DAX expressions and report optimization techniques.
- Familiarity with cloud platforms such as GCP BigQuery and Tableau migration.
- Strong analytical, problem-solving, and communication skills.
What We Offer
- Competitive salary and performance-based bonuses.
- Comprehensive health insurance.
- Learning and professional development opportunities.
- Flexible working hours and remote work options.
Application Process