NewYorkRecruiter Since 2001
the smart solution for New York jobs

Senior BI Reporting Developer

Company: Visionet Systems Inc.
Location: Fair Lawn
Posted on: June 25, 2022

Job Description:

Senior BI Reporting DeveloperFair Lawn, New Jersey, USAContract
Role and responsibilities Analytics & ReportingUnderstand business requirements in BI context and design data models to transform raw data into meaningful insightsDevelop Power BI model for many dashboards. Design and documented the entire Architecture of Power bi Poc Write complex DAX functions in Power BI and Power Pivot. Automate Power Query refresh using power shell script and windows task scheduler. Use various sources to pull data into Power BI such as SQL Server, Oracle, SQL Azure etc. Create Workspace and content packs for business users to view the developed reports. Schedule Automatic refresh and scheduling refresh in power bi service. Write calculated columns, Measures queries in power bi desktop to show good data analysis techniques. Present to the business users about the reports and their changes as required. Work on all kind of reports such as Yearly, Quarterly, Monthly, and Daily. Work with users and team members at all level for performance improvement and suggestionsPerforms Data validation process to ensure quality and integrity of the data by using Microsoft stack of tools (SQl Management studio, excel), Oracle Developer studio, Toad, Etc
Business Requirements & SpecificationsCreate and Maintain business requirement documents and gain stakeholder approvals. Maintain version control for the solutions built to track the changes.Create customize charts and custom calculations as per requirementsUnderstand business requirements in BI context and design data models to transform raw data into meaningful insightsConvert business requirements into technical specifications and build prototypes when required.
Database- Development supportCreate stored procedures and SQL queries to pull data into power pivot model. Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning. Use Joins and Sub-Queries to simplify complex queries involving multiple tables. Develop tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL. Transform complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required. write ETL jobs to maintain and load databases/data martsSupport future data integration strategiesCreate SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files. Filter bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split. Design SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task
Data ValidationPerforms Data validation process to ensure quality and integrity of the data byusing Microsoft stack of tools (SQl Management studio, excel), Oracle Developer studio, Toad, Etc.Identify, communicate, and resolve data quality and data reconciliation issues

Keywords: Visionet Systems Inc., New York , Senior BI Reporting Developer, IT / Software / Systems , Fair Lawn, New York

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest New York jobs by following @recnetNY on Twitter!

New York RSS job feeds