BI Developer (Hybrid)

Wall Township, NJ, USA Req #2205

Thursday, May 23, 2024

New Jersey Resources is seeking a Business Intelligence Developer responsible for developing, analyzing and modifying reports and dashboard including testing, debugging and installing to support Power BI, SQL, Azure Data Factory, Data Lake, and Synapse platforms. Troubleshoot and resolve incidents related to Power BI reports, data models and ETL jobs. Perform BI configuration activities in accordance with application configuration standards and best practices. Work directly with the development team responsible for building analytical reports and dashboards and actively participate in overall design and testing using BI tools. Develop break fixes and enhancements following standards for development and testing.

Major Responsibilities:

• Work with stakeholders to define business and systems requirements, particularly in the areas of BI, analytics, and data warehousing; analysis of business requirements, create wireframes and data flows, systems interactions, higher-level project tracking, reporting and testing

• Design, develop and maintain business intelligence solutions, including data warehousing, data integration, and reporting solutions

• Ingest data from a wide variety of sources and preform ETL (ADF and IICS) to clean and process data for final consumption into Power BI

• Work with business stakeholders to build dashboards and reports using modern business intelligence tools like Power BI, Azure Data Factory, Databricks, Data Lake, and Synapse

• Maintain and enhance the existing companywide BI Platform

• Create and maintain the logical and physical data model for the Reporting and BI Platforms

• Collaborate with business users to continuously improve existing dashboards, reports and datasets

• Understand business requirements and develop data models accordingly by taking care of the resources

• Develop and maintain ETL processes to ensure data accuracy and reliability

• Develop processes and procedures to migrate data from third-party systems to the primary BI environment

• Design and develop Power BI datasets, dashboards, and reports including multiple visual reports, integrated dashboards and KPI scorecards

• Develop, publish and schedule Power BI reports as per the business requirements

• Write Complex DAX and queries, views, and procedures using SQL server

Position Specifications:

• Bachelors degree in computer science, statistics, mathematics, or related field; or equivalent combination of education and experience

• Microsoft Azure certifications preferred

• 4+ years of experience with data warehousing, Microsoft Azure Data Factory, Data Lake, and Synapse; strong data warehousing process design, development, source control and performance tuning skills

• 3+ years of experience working with Microsoft SQL Server and T‐SQL

• 3+ years of experience working Power BI development and administration; ability to connect and interact from Power BI server to Microsoft azure components

• 2+ years of experience with API connections in data warehousing technologies – SOAP and REST

• Power Query experience

• Experience with Azure DevOps is a plus

• Expert understanding of T-SQL, Azure Data Factory, IICS, Power BI, and DAX

• Strong working knowledge of SQL and OLAP databases, and data modeling

• Excellent written and verbal communication skills

• Understanding of both on-premise and a gateway

• Versed in security, setting up workspaces, creating data models, the cubes to support the data modeling, and strong understanding of the tool

• Experience using APIs and API data transfer

• Experience in administration of Power BI report repository

• Knowledge and experience in prototyping, designing, and requirement analysis

• Knowledge in connecting to data sources, importing data and transforming data for Power BI

Position is Hybrid, with 3 days onsite in Wall, NJ office, 2 days remote.

• The above job description is reflective of the primary duties of this position and in no way limits the supervisor from assigning any other duties, responsibilities or initiatives as deemed necessary.

New Jersey Resources is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, age, gender identity and/or expression, national origin, disability, veteran, or other protected status.

Other details

• Job Function Professional

• Pay Type Salary

• Wall Township, NJ, USA