Business Intelligence (BI) Developer

HYTORC Middle East FZE; Mahwah (NJ); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Health insurance

Paid time off

Paid holidays

Retirement savings opportunities

Job summary

HYTORC Middle East FZE seeks a data analytics engineer to support the analytics and reporting platform. You will build Databricks ingestion pipelines and transform layers, monitor jobs, and create star schemas with robust governance.

Proficiency in SSRS and Sigma-based reporting is highly valued, along with Power BI/Tableau/Qlik experience. You will collaborate with stakeholders to deliver operational reports and dashboards, working in a small team with external partners as needed, under

Qualifications

• Enterprise-scale Databricks Lakehouse development experience.
• Knowledge of logical and physical data modeling (relational and dimensional).
• Bachelor's degree in CS/Business/IS.
• Ability to design and build insightful reports and dashboards.
• Strong multitasking and prioritization.
• Excellent written and verbal communication.
• Experience with PySpark and Python.
• Experience with Sigma, Power BI, Tableau or Qlik.
• Experience with SSRS or Crystal Reports.

Responsibilities

• Build and maintain Databricks ingestion pipelines.
• Support Bronze, Silver and Gold layer transformations.
• Monitor Databricks scheduled jobs and resolve failures.
• Support star schema and maintain fact/dimension/bridge tables.
• Ensure data governance and Unity Catalog initiatives.
• Document lineage and transformation logic.
• Provide technical assistance and cross training to team members.
• Develop and maintain SQL Server queries and views.
• Create and maintain operational reports and dashboards in SSRS and Sigma.
• Suggest improvements to reduce load times and storage costs.

Education

Bachelors in Computer Science, Business (Accounting) and/or Information Systems

Tools

Databricks Lakehouse

SSRS

Sigma

Power BI

Tableau

Qlik

PySpark

Python

SQL Server T-SQL

Databricks SQL

Job description

This individual will be responsible for supporting the company's analytics and reporting platform. Development experience with the Databricks Lakehouse or similar product utilizing medallion architecture is essential. Knowledge of SSRS desired and Sigma or other BI Tool preferred. The successful candidate should be flexible with performing a variety of BI related tasks within a small team that includes third party partner(s). The role also entails interacting with business stakeholders to produce operational reports and dashboards.

Essential Duties and Responsibilities

• Build and maintain Databricks ingestion pipelines
• Support Bronze, Silver and Gold layer transformations
• Monitor Databricks scheduled jobs and resolve failed pipeline executions
• Support creation of star schema and maintain fact/dimension/bridge tables
• Ensure adherence to data governance standards and support Unity Catalog initiatives
• Document lineage and transformation logic
• Provide technical assistance and cross training to other team members.
• Develop and maintain SQL Server queries and views
• Create and maintain operational reports and dashboards in SSRS and Sigma
• Recommend improvements to reduce load times and storage costs
• Must be able to perform duties with moderate to low supervision
• Working with key stake holders to make sure deliverables are on clear and concise.

Supervisory Responsibilities

• This position will not be supervising any other employees at this time. However, the position does require the indvidual to be personable and team-oriented.

Education/Experience Required

• 3+ years experience developing and implementing at enterprise-scale within Databricks Lakehouse or similar platform
• Knowledge of logical and physical data modeling concepts (relational and dimensional)
• A Bachelor's degree in Computer Science, Business (Accounting) and/or Information Systems degree
• Ability to design and build insightful reports and dashboards
• Ability to multi-task and manage priorities.
• Excellent communication skills, both written and oral
• Self-motivated and driven to achieve success within a consulting environment
• Data Warehouse Medallion architecture, Databricks strongly preferred
• Experience with BI tool like Sigma (preferred),Power BI, Tableau or Qlik
• Crystal Reports, SSRS, or similar reporting tools
• Microsoft SQL Server T-SQL
• Databricks SQL
• Knowledge of PySpark and Python programming
• Microsoft Office Applications

Physical Demands/Requirements

• Primarily sedentary role requiring extended periods of sitting, frequent use of computers, and regular communication. Must possess strong analytical, attention to detail, and problem-solving skills.
• Working in high-energy office environment with several ongoing projects.

Salary Range:

$85,000 - $110,000 annually, with an anticipated hiring range of $90,000 - $100,000 depending on experience and qualifications. This position is bonus eligible. HYTORC offers a competitive benefits package that includes health insurance, paid time off, paid holidays, retirement savings opportunities, and other employee benefits.

#ZR

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws.

For further information, please review the Know Your Rights notice from the Department of Labor.