Data & BI Developer

Description

Description

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.

Minimum Qualifications

• 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
  
  

Desired Traits

• 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
  
  

Desired Skills And Technologies

• Experience using formal issue tracking and source control systems. MTW utilizes Azure DevOps, 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
  
  

Responsibilities

• 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 and understand the core business processes solved by MTW’s products
• Develop and document data models and data flow diagrams
• Adhere to data governance and security policies
• Work closely with other staff to ensure that the best solution possible is being developed
• Effectively prioritize tasks and provide accurate estimates on how long a task will take
• Develop the BI Solutions using the selected technologies appropriate for the products assigned. Solutions should be in keeping with good design principles and those standards established MTW’s Director, Software Engineering
• Follow specifications and requirements communicated by product managers and analysts regarding assignments
• Complete assignments at a reasonable duration for the complexity of the task
• Ensure all assignments are completed with high quality and are fully tested
• Document technical changes and designs in reasonable, non-cryptic detail
• Documentation completed using correct English grammar to avoid ambiguity, with careful use of acronyms and other jargon – especially when documentation is intended for client eyes
• Prepare drafts of product feature documentation for inclusion in system documentation
• Correctly and completely update appropriate build documentation regarding solutions requiring deployments
• Perform ad-hoc analysis as needed