STAFFXPERT LLC
Business Intelligence Architect
STAFFXPERT LLC, Jersey City, New Jersey, United States, 07390
Overview
Join to apply for the
Business Intelligence Architect
role at
STAFFXPERT LLC .
Job Title:
BI Architect Duration: 24+ Months MOI: Skype
Job responsibilities
DESCRIPTION OF WORK (SCOPE OF WORK): ERAD currently hosts Cognos and Microsoft Power Platform technologies to provide data, reporting and application development to various departments in an Agency. It is anticipated that this platform will be exploited to a much greater extent in the near future to address all aspects of corporate reporting needs and application development which enables the organization to make decisions that achieve better outcomes, flexible deployment options, and to enable to easily scale analytics to meet changing business needs.
New development: Working with PA technical manager, responsible for understanding and documenting business requirements, providing project plans for new implementation, develop, test and deploy solutions to prod environment following PA processes for tracking user requirements, project development status and testing and deploying solutions following change/release management process.
Systems Testing and Deployment: Responsible for unit and system integration testing, coordinating with business users for user acceptance testing and getting sign off from business users to implement solutions in the production for any new enhancements or development following PA\'s change/release management process.
Systems Support: Provide maintenance, enhancements and support of platform ensuring the stability of applications by resolving any data issues, user help tickets in a timely manner and provide on-call availability for off-hour problem resolution.
Environment Support: Maintenance of Non-prod and Prod Cognos environments ensuring stability by applying required patching and upgrades as needed.
System administration: Provide system administration for installation and configurations of different components of Cognos platform, upgrades and responsible to maintain and establish user accounts, security profiles, controlling access to applications and reports following the process.
Troubleshooting and Problem Management and Resolution: Logging, documenting, tracking and resolving system problems while ensuring ongoing data integrity with interfaces and/or systems.
Disaster Recovery Support: Define, in conjunction with the Port Authority, the scope of periodic disaster recovery tests and coordinate with other Port Authority staff and third parties to ensure all required tasks are covered for these tests.
Documentation and Training: Provide all documentation needed for the continued operation and management of the system and for any new implementations, and provide training to end users on new functionality by creating user guides.
Minimum experience and qualifications
Minimum 10 years of experience in Data Warehousing, Data Analysis, Source to Target Mapping, Multi-dimensional modeling and relational modeling, star/snowflake schemas, fact and dimension tables and ETL processes.
10+ years of experience in Microsoft SQL Server and relational SQL databases including data modeling, development, and management.
Experience in designing database tables and structures, creating views, functions and stored procedures as required.
5+ years of experience with Azure Analysis Services in AAS Data Model Development, AAS Data model Deployment in Azure, and querying data from AAS to build reports.
Experience in developing, optimizing, and administering Tabular Models in Azure Analysis Services.
Experience in designing AAS/OLAP/Tabular cubes and automating processes for analytical needs; expertise in developing OLAP cubes with complex calculations, aggregations, and a dynamic security model using DAX in Azure Analysis Services.
Experience in writing optimized SQL queries for integration with other applications, maintaining data quality and overseeing database security, partitions, and indexing. Proficient with performance tools to solve deadlocks and monitor long-running queries.
Experience or knowledge of reporting tools like Power BI, Cognos or Tableau is preferred.
Experience applying data visualization best practices and communicating insights through visuals and reports to inform business decisions.
Excellent communication and presentation skills with ability to interact at all levels of the organization on a regular basis.
Bachelor\'s degree in computer science/engineering or related field.
Any certification in related technologies is preferred.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Business Development and Sales (related)
Industries
Business Consulting and Services
Referrals increase your chances of interviewing at STAFFXPERT LLC by 2x
Get notified about new Business Intelligence Architect jobs in
Jersey City, NJ .
New York, NY $150,000.00-$200,000.00 3 weeks ago
New York, NY $220,000.00-$276,000.00 2 days ago
#J-18808-Ljbffr
Business Intelligence Architect
role at
STAFFXPERT LLC .
Job Title:
BI Architect Duration: 24+ Months MOI: Skype
Job responsibilities
DESCRIPTION OF WORK (SCOPE OF WORK): ERAD currently hosts Cognos and Microsoft Power Platform technologies to provide data, reporting and application development to various departments in an Agency. It is anticipated that this platform will be exploited to a much greater extent in the near future to address all aspects of corporate reporting needs and application development which enables the organization to make decisions that achieve better outcomes, flexible deployment options, and to enable to easily scale analytics to meet changing business needs.
New development: Working with PA technical manager, responsible for understanding and documenting business requirements, providing project plans for new implementation, develop, test and deploy solutions to prod environment following PA processes for tracking user requirements, project development status and testing and deploying solutions following change/release management process.
Systems Testing and Deployment: Responsible for unit and system integration testing, coordinating with business users for user acceptance testing and getting sign off from business users to implement solutions in the production for any new enhancements or development following PA\'s change/release management process.
Systems Support: Provide maintenance, enhancements and support of platform ensuring the stability of applications by resolving any data issues, user help tickets in a timely manner and provide on-call availability for off-hour problem resolution.
Environment Support: Maintenance of Non-prod and Prod Cognos environments ensuring stability by applying required patching and upgrades as needed.
System administration: Provide system administration for installation and configurations of different components of Cognos platform, upgrades and responsible to maintain and establish user accounts, security profiles, controlling access to applications and reports following the process.
Troubleshooting and Problem Management and Resolution: Logging, documenting, tracking and resolving system problems while ensuring ongoing data integrity with interfaces and/or systems.
Disaster Recovery Support: Define, in conjunction with the Port Authority, the scope of periodic disaster recovery tests and coordinate with other Port Authority staff and third parties to ensure all required tasks are covered for these tests.
Documentation and Training: Provide all documentation needed for the continued operation and management of the system and for any new implementations, and provide training to end users on new functionality by creating user guides.
Minimum experience and qualifications
Minimum 10 years of experience in Data Warehousing, Data Analysis, Source to Target Mapping, Multi-dimensional modeling and relational modeling, star/snowflake schemas, fact and dimension tables and ETL processes.
10+ years of experience in Microsoft SQL Server and relational SQL databases including data modeling, development, and management.
Experience in designing database tables and structures, creating views, functions and stored procedures as required.
5+ years of experience with Azure Analysis Services in AAS Data Model Development, AAS Data model Deployment in Azure, and querying data from AAS to build reports.
Experience in developing, optimizing, and administering Tabular Models in Azure Analysis Services.
Experience in designing AAS/OLAP/Tabular cubes and automating processes for analytical needs; expertise in developing OLAP cubes with complex calculations, aggregations, and a dynamic security model using DAX in Azure Analysis Services.
Experience in writing optimized SQL queries for integration with other applications, maintaining data quality and overseeing database security, partitions, and indexing. Proficient with performance tools to solve deadlocks and monitor long-running queries.
Experience or knowledge of reporting tools like Power BI, Cognos or Tableau is preferred.
Experience applying data visualization best practices and communicating insights through visuals and reports to inform business decisions.
Excellent communication and presentation skills with ability to interact at all levels of the organization on a regular basis.
Bachelor\'s degree in computer science/engineering or related field.
Any certification in related technologies is preferred.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Business Development and Sales (related)
Industries
Business Consulting and Services
Referrals increase your chances of interviewing at STAFFXPERT LLC by 2x
Get notified about new Business Intelligence Architect jobs in
Jersey City, NJ .
New York, NY $150,000.00-$200,000.00 3 weeks ago
New York, NY $220,000.00-$276,000.00 2 days ago
#J-18808-Ljbffr