ZipRecruiter
Job Description
Job Title :
DATAWAREHOUSE ARCHITECT Location : 2 Montgomery Street, Jersey City, New Jersey Job Type : Contract Duration : 2+ Years Work schedule : Normal business hours Monday-Friday 8-5 Pay Rate : $80 per hour 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, enabling the organization to make better decisions, offering flexible deployment options, and scaling analytics to meet changing business needs. The successful candidate may work independently as well as with consultants and staff resources across departments, under the direction of a project manager, to deliver projects including but not limited to: JOB RESPONSIBILITIES: New development:
Collaborate with PA technical manager to understand and document business requirements, develop project plans for new implementations, and develop, test, and deploy solutions following PA processes for tracking requirements, development, testing, and deployment. Systems Testing and Deployment:
Conduct unit and system integration testing, coordinate user acceptance testing, and obtain sign-off from business users before deploying solutions to production, following change/release management processes. Systems Support:
Provide ongoing maintenance, enhancements, and support to ensure platform stability, resolve data issues and user tickets promptly, and be available for off-hour problem resolution. Environment Support:
Maintain Non-prod and Prod Cognos environments, applying patches and upgrades as needed to ensure stability. System administration:
Manage installation and configuration of Cognos components, perform upgrades, and control user access and security profiles according to PA standards. Troubleshooting and Problem Management:
Log, track, and resolve system issues, ensuring data integrity across interfaces and systems. Disaster Recovery Support:
Define scope of disaster recovery tests, coordinate with staff and third parties to execute these tests. Documentation and Training:
Provide accurate documentation and user guides, and train end-users on new functionalities. MINIMUM EXPERIENCE AND QUALIFICATIONS: Minimum 12 years of relevant experience in architecting, designing, and developing databases or Datawarehouse systems, both on-premises and in the cloud, following industry best practices. Experience building end-to-end data warehouses and analytical systems using SQL Server, Analysis Services, Power BI, etc. Maintain complex Data Warehouse models, develop and administer ETL functions supporting Cognos TM1 and Cognos BI frameworks. Experience with Azure SQL, Azure Data Factory, Azure Storage, Azure Pipelines, and related Azure IaaS/PaaS services. Knowledge of data governance, management, modeling, cleansing, extraction, transformation, analysis, migration, and integration. Proficiency with SQL Server Integration Services (SSIS), SSAS, SSRS for analysis and reporting. Ability to write complex T-SQL queries, stored procedures, views, and ETL scripts, and re-design databases/data warehouses. Experience with Cognos BI or similar tools like Power BI or Tableau. Hands-on, technically skilled, and familiar with latest data platform features, capable of coding and mentoring junior engineers. Excellent communication, presentation, and interpersonal skills, with the ability to interact at all organizational levels. Ability to independently resolve issues, with strong critical and analytical thinking skills. Bachelor's degree in computer science, engineering, or related fields. Relevant certifications are a plus.
#J-18808-Ljbffr
DATAWAREHOUSE ARCHITECT Location : 2 Montgomery Street, Jersey City, New Jersey Job Type : Contract Duration : 2+ Years Work schedule : Normal business hours Monday-Friday 8-5 Pay Rate : $80 per hour 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, enabling the organization to make better decisions, offering flexible deployment options, and scaling analytics to meet changing business needs. The successful candidate may work independently as well as with consultants and staff resources across departments, under the direction of a project manager, to deliver projects including but not limited to: JOB RESPONSIBILITIES: New development:
Collaborate with PA technical manager to understand and document business requirements, develop project plans for new implementations, and develop, test, and deploy solutions following PA processes for tracking requirements, development, testing, and deployment. Systems Testing and Deployment:
Conduct unit and system integration testing, coordinate user acceptance testing, and obtain sign-off from business users before deploying solutions to production, following change/release management processes. Systems Support:
Provide ongoing maintenance, enhancements, and support to ensure platform stability, resolve data issues and user tickets promptly, and be available for off-hour problem resolution. Environment Support:
Maintain Non-prod and Prod Cognos environments, applying patches and upgrades as needed to ensure stability. System administration:
Manage installation and configuration of Cognos components, perform upgrades, and control user access and security profiles according to PA standards. Troubleshooting and Problem Management:
Log, track, and resolve system issues, ensuring data integrity across interfaces and systems. Disaster Recovery Support:
Define scope of disaster recovery tests, coordinate with staff and third parties to execute these tests. Documentation and Training:
Provide accurate documentation and user guides, and train end-users on new functionalities. MINIMUM EXPERIENCE AND QUALIFICATIONS: Minimum 12 years of relevant experience in architecting, designing, and developing databases or Datawarehouse systems, both on-premises and in the cloud, following industry best practices. Experience building end-to-end data warehouses and analytical systems using SQL Server, Analysis Services, Power BI, etc. Maintain complex Data Warehouse models, develop and administer ETL functions supporting Cognos TM1 and Cognos BI frameworks. Experience with Azure SQL, Azure Data Factory, Azure Storage, Azure Pipelines, and related Azure IaaS/PaaS services. Knowledge of data governance, management, modeling, cleansing, extraction, transformation, analysis, migration, and integration. Proficiency with SQL Server Integration Services (SSIS), SSAS, SSRS for analysis and reporting. Ability to write complex T-SQL queries, stored procedures, views, and ETL scripts, and re-design databases/data warehouses. Experience with Cognos BI or similar tools like Power BI or Tableau. Hands-on, technically skilled, and familiar with latest data platform features, capable of coding and mentoring junior engineers. Excellent communication, presentation, and interpersonal skills, with the ability to interact at all organizational levels. Ability to independently resolve issues, with strong critical and analytical thinking skills. Bachelor's degree in computer science, engineering, or related fields. Relevant certifications are a plus.
#J-18808-Ljbffr