Microsoft .NET Developer in South Beloit, IL at Altra Industrial Motion Corporate

Date Posted: 11/1/2019

Job Snapshot

Job Description

Seeking a motivated and experienced back end and SQL Server developer who will be responsible for developing applications and integrations using Microsoft tools and technologies.  Key development role in supporting and enhancing existing applications, databases and interfaces supporting the Altra Industrial Motion Corp Procurement Suite. The AIMC Procurement Suite is comprised on multiple components and application functionalities leveraging standard Microsoft technologies and multiple 3rd-party applications which are interfaced to the suite.

A key component of the Procurement Suite is a Microsoft SQL Server-based data warehouse fed from multiple ERP systems/sources with key supplier, materials and transactional data to enable global consolidation and analysis of procurement data and activities. Dashboards, scorecards and other analysis objects are part of the solution and will need to be understood and supported in collaboration with procurement analysts, front-end web development and 3rd party software experts.

Essential Duties and Responsibilities

  • Take on in-house business application development projects in a fast-paced work environment
  • Design, develop and maintain ASP.NET MVC websites, working collaboratively with front-end web developers and contractors, and defining requirements and functional specifications with key procurement team members
  • Design and develop Microsoft BI Solutions including SSIS, data models and OLAP cube solutions using Visual Studio
  • Build effective and visually pleasing SSRS and Power BI dashboards/reports to answer those business questions with the help of data.
  • Be responsible for on-boarding new data sources from various ERPs. Maintain configurations and related SSIS packages.
  • Serve as a key technical and architectural expert in supporting the back-end environment of the procurement suite, including troubleshooting and creative problem solving
  • Support end user requests and troubleshoot application issues
  • Perform data analysis, assess data quality, perform data cleanup and develop benchmarks and reporting
  • Working within the framework of a team

The company in which you have expressed employment interest is a subsidiary or affiliate of Altra Industrial Motion Corp. The subsidiary or affiliate is referred to as an ""Altra Company."" Altra Industrial Motion Corp. and all Altra Companies are equal opportunity employers that evaluate qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity or expression, or other characteristics protected by law. The ""EEO is the Law"" poster is available at: http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf. Individuals who need a reasonable accommodation because of a disability for any part of the employment process will have the opportunity to request accommodation during the application process.

Job Requirements

Critical Competencies

  • Enterprise experience developing and maintaining SQL Server 2016
  • Strong understanding of Microsoft SQL Server Tools including SQL Server Management Studio (SSMS), Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
  • Strong skills in designing and maintaining existing SSAS and SSIS solutions
  • Proficient in writing complex SQL queries. Hands down experience in writing SQL Server stored procedures, functions and triggers
  • Experience with multidimensional and Tabular data warehouse design, including a solid understanding of MDX/DAX, calculated measures, hierarchies, slowly changing dimensions, and data/time dimension analysis
  • Knowledge in designing Power BI Reports and working with Power BI Reports server.
  • Ability to solve complex problems, strong analytical skills and the ability to trace issues to the root cause
  • Ability to work on multiple projects concurrently with a strong attention to detail
  • Able to synthesize the variety of technologies and tools to solve complex problems and deliver usable technical solutions
  • Excellent written/oral communication skills
  • Strong blend of communication and technical skills

Education and Experience Requirements

  • 4-year degree in Computer Science or related field or equivalent combination of education and experience
  • Prior ASP.NET Development or similar experience
  • 3 + years of experience in tools like SSMS, Visual Studio (SSIS, SSAS, SSRS), Power-BI
  • 3 + years of experience in working with TSQL, MDX, DAX, Large data files, XML, Web Services, SOAP, REST protocols
  • 3 + years of experience in relational database design including referential integrity, with strong understanding of key data elements, table indexing and database tuning around Data Warehouses
  • Prior ETL project experience working with large Data Warehouses, configuring using parametrization, coding and calling jobs with Batch, C#, Python like programs.
  • Experience with Microsoft Internet Information Server configuration and management
  • Prior experience configuring and managing Azure services or related experience with Amazon Web Services hosting a Microsoft-based front-end/back-end application environment is a plus

EEO Statement: The company in which you have expressed employment interest is a subsidiary or affiliate of Altra Industrial Motion Corp. The subsidiary or affiliate is referred to as an ""Altra Company."" Altra Industrial Motion Corp. and all Altra Companies are equal opportunity employers that evaluate qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity or expression, or other characteristics protected by law. The ""EEO is the Law"" poster is available at: http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf. If you have a disability and need assistance accessing or using this website to apply for a position, you can request assistance by sending an email to assistance@altramotion.com.