Software Developer

Quantum Integrators Group; West Windsor (NJ); Hybrid; USD 85,000 - 110,000; Full time

Benefits offered by this job

Competitive salary and performance-based bonuses

Learning and professional development opportunities

Flexible working hours and remote work options

Job summary

A data solutions company is seeking a Software Developer to design, develop, and optimize ETL processes and business intelligence solutions. The role involves working with various data sources, enhancing Power BI dashboards, and leading the migration of legacy reports to Power BI. The ideal candidate should have a Bachelor's degree and at least 5 years of experience in software development and BI solutions. Competitive salary and benefits are offered including flexible work options.

Qualifications

• Minimum 5 years of relevant experience in ETL and BI solutions.
• Proficiency in developing power BI dashboards and data modeling.
• Strong understanding of database systems including Oracle and SQL Server.

Responsibilities

• Design, develop, and optimize ETL processes for data loading.
• Create self-service BI solutions to reduce dependency on BI teams.
• Migrate legacy reports from GCP and Tableau to Power BI.

Skills

ETL processes

Power BI

DAX expressions

Data modeling

Database systems (Oracle, DB2, SQL Server)

Education

Bachelor's degree in Computer Science, IT, or Engineering

Tools

Power BI Embedded

GCP BigQuery

Tableau

Job description

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.
• Learning and professional development opportunities.
• Flexible working hours and remote work options.