Senior Power BI & SQL Architect (Oracle, AWS, Databricks)

OMG Technology; Secaucus (NJ); Hybrid; USD 120,000 - 150,000; Full time

Job summary

OMG Technology in Secaucus, NJ seeks an experienced Senior Power BI Developer with SQL to lead enterprise BI and data integration initiatives. The role is hybrid (1 day per week) and focuses on dashboards, data modeling, and performance tuning.

You'll work with data engineers, BI developers, and business stakeholders to deliver scalable reporting solutions using Power BI, DAX, PL/SQL, Oracle SQL, and SQL Server, including Oracle RDS migrations and Databricks projects.

Qualifications

• 5 to 10+ years of overall IT experience.
• Minimum 5+ years of hands-on Database Development experience.
• Strong hands-on experience with Power BI and SQL.
• Excellent expertise in PL/SQL and SQL development.
• Strong experience developing and optimizing Oracle SQL Queries, Views, Stored Procedures, Packages and Functions.
• Experience with Oracle RDS.
• Hands-on experience with database migration projects.
• Experience with SQL Server.
• Experience with Oracle to Databricks migration.
• Experience working with AWS or Azure, with AWS preferred.
• Experience developing reports and dashboards using Power BI.
• Strong knowledge of DAX.
• Strong problem-solving and database troubleshooting skills.

Responsibilities

• Design, develop, and maintain Oracle database solutions.
• Develop complex SQL/PL-SQL code including procedures, packages, functions and views.
• Performance tune and optimize queries, indexing, and troubleshooting.
• Develop and maintain solutions within Oracle RDS environments.
• Lead database migrations and modernization initiatives.
• Work on Oracle to Databricks migration projects.
• Develop and support Power BI reports and dashboards.
• Collaborate with data engineers, BI developers, architects, and stakeholders.
• Troubleshoot performance, data quality, migration, and production issues.
• Work with AWS/Azure cloud environments.

Skills

Power BI

SQL

PL/SQL

DAX

Databricks

AWS

Azure

Tools

Oracle RDS

SQL Server

Databricks

AWS

Azure

Job description

OMG Technology in Secaucus, NJ seeks an experienced Senior Power BI Developer with SQL to lead enterprise BI and data integration initiatives. The role is hybrid (1 day per week) and focuses on dashboards, data modeling, and performance tuning.

You'll work with data engineers, BI developers, and business stakeholders to deliver scalable reporting solutions using Power BI, DAX, PL/SQL, Oracle SQL, and SQL Server, including Oracle RDS migrations and Databricks projects.