The company is looking to maintain, enhance, and support applications that utilize Microsoft Access, SQL Server, and Power BI. This includes addressing issues, developing data connections and visualizations, ensuring seamless integration with the ATS, and improving reporting capabilities for better business decision-making.
Requirements
- 3–5 years of experience developing and maintaining applications in Microsoft Access and SQL Server environments.
- Hands-on experience building and maintaining Power BI reports and dashboards.
- Strong understanding of relational database design, data modeling, and SQL queries.
- Experience with data validation, data migration, and ETL processes.
- Experience with ATS (Applicant Tracking Systems) or similar enterprise systems.
- Knowledge of Power Automate or Power Apps for workflow automation.
- Experience supporting system integrations or API-based data exchanges.
Responsibilities
- Maintain, troubleshoot, and enhance existing Microsoft Access applications, including front-end forms, queries, and reports.
- Manage and optimize SQL Server databases, ensuring data integrity, performance, and proper linkage with Access front-end components.
- Design, develop, and publish Power BI dashboards and reports using data from Access and SQL Server.
- Add new data fields, tables, and relationships to support evolving business requirements.
- Recreate and develop new Power BI reports to replace or enhance existing Access reports.
- Update and maintain the data upload process into the ATS, ensuring accuracy and efficiency.
- Implement new system validations and business rules to strengthen data quality and compliance.
Other
- This is 3 month contract role.
- 100% remote
- Excellent analytical, troubleshooting, and problem-solving skills.
- Strong communication and documentation abilities, with attention to detail.
- Collaborate with business analysts and end users to understand reporting and process improvement needs.
