Project Solution Architect for Microsoft Access Database Replacement
Primary stack
Power BI
Nice to have's
AI InnovationAutomationData IngestionData ProcessingChange TrackingBusiness ReportingKey Performance Indicators (KPIs)Web Access ManagementMicrosoft Business IntelligenceBusiness RulesAutomated Calculation Logics
Job description
About the Position
We are seeking a Project Solution Architect for Microsoft Access Database Replacement to lead the migration of an Access database to a modern architecture in Vienna, Austria.
Start and Duration
- Start: September 2026
- Duration: 6 months ++
Workload
- Type: Full-time
- On-site: 1 day per week in Vienna (required)
Languages
- Fluent English (required)
- Fluent German (required)
Responsibilities
- Development and operation of a central reporting and billing solution along the entire data process from data acquisition to results delivery.
- Integration and automated import of data from different sources and formats.
- Ensuring data quality through validation, plausibility, and consistency checks.
- Consolidation, calculation, and enrichment of data as well as implementation of complex business rules.
- Establishment of a transparent and audit-proof data storage system with complete traceability of all processing steps.
- Automated creation of KPIs, reports, and management analyses for operational areas, steering committees, and executives.
- Further development of reporting and analysis functions, so that new KPIs and reports can be created with minimal development effort.
- Implementation and optimization of automated billing and calculation processes.
- Migration of existing calculation logics from an Access database to a modern target architecture.
- Creation of solution, architecture, and automation concepts including data flows, migration, testing, rollout, as well as operational and support concepts.
- Conducting training courses and knowledge transfer for specialist departments and users.
- Close collaboration with business stakeholders to enable independent maintenance of reports, KPIs, and business rules by the specialist departments.
Requirements
- Several years of experience in data management, reporting, and business intelligence.
- Excellent knowledge of the design and implementation of data integration and automation solutions.
- Experience with Microsoft technologies, especially Microsoft Access, Power BI, and modern Microsoft data platforms.
- Solid expertise in data processing, data quality, data validation, and KPI management.
- Experience in migrating and modernizing existing applications and databases.
- Knowledge of system and solution architectures as well as the development of scalable applications.
- Experience with role-based access control (RBAC) concepts, audit trails, and change tracking.
- Understanding of billing, reporting, and business processes.
- Experience in defining and implementing business rules and automated calculation logics.
- Knowledge in the field of AI and automation solutions for optimizing business processes.
- Experience in creating technical concepts, documentation, and test and rollout strategies.
Technologies/Methods/Tools
- AI Innovation
- Automation
- Data Ingestion
- Data Processing
- Data Quality
- Data Validation
- Project Architecture
- Role-Based Access Control (RBAC)
- System Migration
- Web Access Management
- Microsoft Access
- Microsoft Business Intelligence
- Power BI
- Business Reporting
- Change Tracking
- Key Performance Indicators (KPIs)
We Offer
- Opportunity to work with cutting-edge technologies.
- Collaborative and innovative work environment.
- Professional growth and development opportunities.
About the Company
The Workly s.r.o.
4D CENTER, Kodaňská 1441/46,
101 00, Praha 10.
Contact:
[email protected]
- 420 775 371 991
©2023, All right reserved.
© The Workly. This job description was sourced from the employer's public career page. TheJob is not the employer — we index the posting and route candidates to the source. All content rights and hiring decisions belong to the employer.
More at The Workly
All 270 rolesVeeva Vault Platform Configuration Specialist
The Workly · Prague
Salary not specified checked 1w ago
Technical Product Analyst
The Workly
Salary not specified checked 1w ago
Technical Communications Manager
The Workly · Prague
Salary not specified checked 1w ago
Sr. Data Engineer
The Workly · Prague
Salary not specified checked 1w ago