Description The Municipal Reporting System project will replace an unsustainable workflow currently dependent on six massive Excel spreadsheets, each containing hundreds of columns. These spreadsheets are used to manage municipal assets, track year‑over‑year asset growth percentages, and consolidate critical operational data. This setup is high‑risk, inefficient, and fragile, relying on a single individual to maintain and operate it—creating both capacity issues and significant organizational vulnerability. We need a Business Analyst who is not afraid to challenge the status quo, streamline complex data processes, and design actionable, scalable solutions. This individual will assess current workflows, lead requirements gathering with stakeholders, and recommend a clear strategy to migrate from Excel dependency to a robust, Microsoft‑based database environment (such as SQL Server, Dataverse, or Power Platform). The BA will play a pivotal role in shaping a modern, secure, and sustainable reporting system that can support operational needs for years to come. Skills Business analysis, Requirements gathering, data modeling, database design Top Skills Details Business analysis,Requirements gathering Additional Skills & Qualifications Responsibilities Gather requirements and produce actionable next steps. Recommend database strategy and integration approach. Influence stakeholders and drive process change. Document workflows and create migration roadmap. Ensure scalability and sustainability of the new solution. Qualifications 5+ years BA experience with modernization projects. Strong understanding of database design and ETL processes. Experience with Azure SQL, Data Factory, or similar platforms. Ability to pull and consolidate data from multiple sources. Excellent communication and stakeholder management skills. UX/UI, Developer, Product Owner would be a nice to have. Experience Level Intermediate Level Job Type & Location This is a Contract position based out of Halifax, NS. Pay and Benefits The pay range for this position is $70.00 - $90.00/hr. Workplace Type This is a hybrid position in Halifax,NS. À propos de TEKsystems et TEKsystems Global Services Nous sommes un fournisseur de services aux entreprises et de technologies. Nous accélérons la transformation de nos clients. Notre compétence en stratégie, conception, exécution et opérations libère la valeur de l’entreprise par un éventail de solutions. Nous sommes une équipe de 80 000 personnes qui collaborent avec plus de 60 000 clients, notamment 80 % du Fortune 500 en Amérique du Nord, Europe et Asie, qui collaborent avec nous dans le cadre de nos capacités full-stack et notre rythme. Nous sommes des penseurs stratégiques, des collaborateurs pratiques qui aident les clients à exploiter le changement et maîtriser le dynamisme de la technologie. Nous bâtissons le futur en livrant les résultats et en créant un impact positif dans nos communautés mondiales. TEKsystems et TEKsystems Global Services sont des entreprises d’Allegis Group. Découvrez d’autres informations à TEKsystems.com. About TEKsystems and TEKsystems Global Services We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com. The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.