Data & BI Developer

The Data and Business Intelligence Developer position supports the business processes of MTW Solutions through warehouse design and development, and the implementation of reports and dashboards across all MTW’s products. A Data and BI Developer is expected to support MTW’s Software Development team by providing guidance for effective SQL development and query optimization. A Data and BI Developer will work in coordination with MTW’s Director, Software Engineering in recommending and implementing process improvements related to MTW’s technical approach for BI‑Solution delivery to our customers.

This role will also demonstrate follow‑up skills to ensure issues and enhancements are resolved effectively, solid customer service, and a proven ability to communicate with both non‑technical and technical teams. The position will also work closely with our product development managers and client managers, assisting them with tracking and maintaining the backlog of functionality requests and issue resolution.

• Bachelor’s degree in Computer Science, Information Systems or Business Administration with a heavy emphasis on Information Systems plus a minimum of 8 to 10 years’ professional experience in Data warehousing and business intelligence development
• Experience implementing relational database concepts
• Experience implementing Data Warehouses, ETL Processing and Star Schemas
• Experience with .NET, C#, Python
• Experience with Microsoft SQL Server Reporting Services, Microsoft SQL Server Integration Services, and Microsoft SQL Server Analysis Services
• Experience supporting BI/reporting environments through well‑modeled, performant datasets
• Experience testing programs and developing test scenarios
• Experience with Performance Optimization of Database Queries and Experience on Indexing
• Demonstrated ability to work both independently and in a team environment
• Demonstrated ability to effectively manage multiple priorities while meeting deadlines.
• Strong written and verbal communication skills
• Distinctive analysis skills, ability to use quantitative analysis to derive at qualitative insights
• Demonstrates ability to determine and manage, time, and scope of concurrent projects and priorities
• Ability to pass background checks required for access to customer environments

• Experience in a customer support or technical support role preferably working in a software support environment.
• Motivated to excel
• Creative/critical thinker and problem solver
• Patient, kind, humble, and confident
• Attentive to detail with strong follow‑up skills
• Calm – able to work under pressure
• Willing to work additional or irregular hours as needed
• Team oriented
• Disciplined and strong with documentation for internal and customer facing documentation
• Ability to move between tasks with frequent interruptions

• Experience using formal issue tracking and source control systems. MTW utilizes Azure Dev Ops, Jira, and Confluence
• Experience building and maintaining BI solutions in both on‑premises and Microsoft Azure cloud‑based environments
• Experience using Data Vault 2.0 warehousing data modelling and architectural design patterns
• Microsoft SQL Server (T‑SQL, Stored Procedures, Database Design, Database Administration, Execution Plans, Performance Improvement)
• Experience building and maintaining BI solutions in both on‑premises and Microsoft Azure cloud‑based environments
• Ability to learn new systems, business logic, and software quickly
• Model and reinforce professional and technical standards
• Deepen and evolve your expertise with a focus on staying relevant.
• Apply systems thinking to identify underlying problems and/or opportunities
• Professional etiquette and superior customer service
• Experience working in an Agile or other iterative project environment

• Development and maintaining Data Warehouse environments for clients
• Development of BI Reporting solutions in support of MTW products
• Complete time reporting, in a timely fashion providing details of time spent broken down by task with details provided as appropriate
• Continually pursue opportunities to deepen your technical skills and business expertise
• Study…