Data & BI Developer

DescriptionDescriptionThe 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 QualificationsBachelor’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 developmentExperience implementing relational database conceptsExperience implementing Data Warehouses, ETL Processing and Star SchemasExperience with .NET, C#, PythonExperience with Microsoft SQL Server Reporting Services, Microsoft SQL Server Integration Services, and Microsoft SQL Server Analysis ServicesExperience supporting BI/reporting environments through well-modeled, performant datasetsExperience testing programs and developing test scenariosExperience with Performance Optimization of Database Queries and Experience on IndexingDemonstrated ability to work both independently and in a team environmentDemonstrated ability to effectively manage multiple priorities while meeting deadlines.Strong written and verbal communication skillsDistinctive analysis skills, ability to use quantitative analysis to derive at qualitative insightsDemonstrates ability to determine and manage, time, and scope of concurrent projects and prioritiesAbility to pass background checks required for access to customer environmentsDesired TraitsExperience in a customer support or technical support role preferably working in a software support environment.Motivated to excelCreative/critical thinker and problem solverPatient, kind, humble, and confidentAttentive to detail with strong follow-up skillsCalm – able to work under pressureWilling to work additional or irregular hours as neededTeam orientedDisciplined and strong with documentation for internal and customer facing documentationAbility to move between tasks with frequent interruptionsDesired Skills And TechnologiesExperience using formal issue tracking and source control systems. MTW utilizes Azure DevOps, Jira, and ConfluenceExperience building and maintaining BI solutions in both on-premises and Microsoft Azure cloud-based environmentsExperience using Data Vault 2.0 warehousing data modelling and architectural design patternsMicrosoft 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 environmentsAbility to learn new systems, business logic, and software quicklyModel and reinforce professional and technical standardsDeepen and evolve your expertise with a focus on staying relevant.Apply systems thinking to identify underlying problems and/or opportunitiesProfessional etiquette and superior customer serviceExperience working in an Agile or other iterative project environmentResponsibilitiesDevelopment and maintaining Data Warehouse environments for clientsDevelopment of BI Reporting solutions in support of MTW productsComplete time reporting, in a timely fashion providing details of time spent broken down by task with details provided as appropriateContinually pursue opportunities to deepen your technical skills and business expertiseStudy and understand the core business processes solved by MTW’s productsDevelop and document data models and data flow diagramsAdhere to data governance and security policiesWork closely with other staff to ensure that the best solution possible is being developedEffectively prioritize tasks and provide accurate estimates on how long a task will takeDevelop 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 EngineeringFollow specifications and requirements communicated by product managers and analysts regarding assignmentsComplete assignments at a reasonable duration for the complexity of the taskEnsure all assignments are completed with high quality and are fully testedDocument technical changes and designs in reasonable, non-cryptic detailDocumentation completed using correct English grammar to avoid ambiguity, with careful use of acronyms and other jargon – especially when documentation is intended for client eyesPrepare drafts of product feature documentation for inclusion in system documentationCorrectly and completely update appropriate build documentation regarding solutions requiring deploymentsPerform ad-hoc analysis as needed