Business Intelligence Architect bei Quevera

Job Description:

Quevera is seeking a Business Intelligence Architect to join our team. At Quevera, we don’t just offer jobs—we provide opportunities to be part of a dynamic, forward-thinking community that fosters innovation, collaboration, and personal growth. You’ll work with industry experts, take on exciting challenges, and have the creative freedom to build cutting-edge solutions, all while advancing your career in a space that truly values your skills and ideas.

HIGHLIGHT'S OF WORKING FOR QUEVERA:

Quevera employees voted Quevera as a TOP EMPLOYER in the Baltimore /DC area by the Washington Post for 2025 for the 5th consecutive year!

Excellent Quevera's Benefits:

Medical/Dental/Vision (100% Employer Paid Medical Plan)

Short/Long Term Disability (Employer Paid)

Life Insurance (Employer Paid)

Yearly $5,000 towards education/training/certification.

Employees are in control of their career path through our Career Pathway Program.

Employer paid Company Vacation Package for you and a guest!     

Retirement: Quevera will match up to 6% towards your 401K and an additional 4% profit sharing!

REQUIRED - The normal workday for the Business Analysis and Functional Support Consultant will be 8:00 AM to 5:00 PM, Monday through Friday except for observed holidays. Deadlines may require additional time.  All overtime must be pre-approved by the designated Manager before any work is performed.

Duties and Responsibilities: 

• 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 making sure the stability of applications is  maintained by resolving any data issues, user help tickets in timely manner and provide on-call availability for off-hour problem resolution.
• Environment Support - Maintenance of Non-prod and Prod Cognos environments making sure the stability of these environments is always maintained by applying any required patching and upgrades as required.
• 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 any and all interfaces and/or systems.
• Disaster Recovery Support – Defining, in conjunction with the Port Authority, the scope of periodic disaster recovery tests.   Coordinating with other Port Authority staff and third parties to ensure all required tasks are covered for these tests.
• Documentation and Training   - Responsible for providing all documentation needed for the continued operation and management of the system and for any new implementations that is accurate and available and in compliance with PA Standards. Provide training to end users on any new functionality of the application or platform by providing user guides.

Required Experience:

Minimum 10 years of experience working with in Data warehousing, Data Analysis, Source to Target Mapping, Multi-dimensional modeling and Relational modeling, Star schema, Snowflake schema, Fact and dimension tables and ETL Processes

• Minimum 10 years of experience working with in Data warehousing, Data Analysis, Source to Target Mapping, Multi-dimensional modeling and Relational modeling, Star schema, Snowflake schema, Fact and dimension tables and ETL Processes
• 10 + years’ experience in Microsoft SQL Server and relational SQL databases that include 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, Querying data from AAS to build Reports. 
• Experience in developing, optimizing, and administering Tabular Models in 'Azure Analysis services'.
• Experience in design and Create AAS/OLAP/ Tabular cubes and automate processes for analytical needs. Expertise in developing OLAP cubes and developing complex calculations, Aggregations, implementing a dynamic security model using DAX functions in - Azure Analysis services.
• Experience in writing optimized SQL queries for integration with other applications, maintaining data quality and overseeing database security, Partitions, and Index. Extensively used performance monitor/SQL profiler/DMVs to solve deadlocks, to monitor long-running queries and trouble-shoot cubes SQL and T-SQL.
•  Experience or Knowledge of reporting tools like Power BI, Cognos or tableau preferred.
• Experience in applying data visualization best practices and tell stories through data visuals and reports to inform the who, what, when, where, and how to be able to understand the key factors driving positive outcomes.
• Excellent communications, 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 fields

Quevera is an equal opportunity employer and does not discriminate on the basis of any legally protected status or characteristic. Protected veterans and individuals with disabilities are encouraged to apply. #LI-AA1