Software Engineer II - BI

Who Are We?

M3 is a Top 150 Workplaces winner named by the Atlanta Journal Constitution! Employee-owned, family-oriented, and a great place to grow your career, our company-wide personal commitment to both clients and employees is simple: do the right thing and invest in long-term relationships. Together, we work to provide the highest standard of financial services and technology to deliver on our mission to drive hospitality company success. M3 helps make hospitality companies successful through technology that drives financial performance.

Our hotel accounting software is used and trusted by the biggest names in the hospitality industry. We are looking for talented professionals to join our team!

We're located in a beautiful and modern new building with the Headquarters in Gwinnett County, GA just off I-85. Our office is complete with an employee gym, bright, open work spaces, and games in the break room (pool, shuffle board, video games).

Compensation and Benefits: 

M3 offers a strong benefits package including 100% employer paid medical as well as dental, and vision for the employee and family; life, long and term disability, and Long Term Care insurance that the company provides free of charge; 401k with a 6% match; three weeks paid time off; discretionary profit sharing; a great culture, and competitive salary.  We are a certified Drug Free Workplace and Equal Opportunity Employer. 

Description Summary: M3 is seeking a Software/Automation Engineer II - Business Intelligence (BI) to join our team and contribute to the development of software applications that focus on automating business processes, business intelligence, and analytics. The ideal candidate should have experience with PowerShell, REST APIs, SSIS packages, SQL Server, SSRS reports, and Power Automate. The ideal candidate is creative, organized, looking for a challenge and an opportunity to grow into a lead.

Essential Duties:

The duties listed below are the essential functions of this position, and they may change as the needs of the company demand. All associates are expected to do what is necessary to get the work done and to cooperate fully with their supervisor’s requests for additional or altered duties.

• Build and maintain PowerShell scripts to automate tasks and processes.
• Build and maintain Power Automate flows to automate business processes.
• Build and maintain Azure DevOps build and release pipelines.
• Develop and maintain REST APIs to support business intelligence and automation projects.
• Create and maintain SSIS packages for data integration and ETL processes.
• Design, develop, and maintain SQL queries and scripts to extract, transform, and load data from various data sources.
• Design, develop, and maintain SQL databases as needed.
• Develop and maintain SSRS reports for data visualization and analysis.
• Collaborate with team members to identify and troubleshoot software issues related to business intelligence and automation projects.
• Participate in and define code reviews to ensure code quality and consistency.
• Stay up to date with emerging technologies and software development practices that are focused on business intelligence and automation.
• Other duties as assigned. 

Education/Training/Experience:

• A minimum of 3 years of experience in a directly related position required;
• Completion of a Bachelors Degree is required. Strong preference for the completion of a major in IT, MIS or Computer Science ; or an equivalent combination of education and experience.
• Proficient in PowerShell, REST APIs, SSIS packages, SQL Server, SSRS reports, and Power Automate is a plus.
• Familiarity with .NET framework, C#, and Visual Studio
• Must be familiar with Git and source code management.
• Experience with Agile development methodologies is a plus.
• Strong analytical and problem-solving skills
• Ability to work independently and as part of a team.
• Must have strong written and verbal skills in English and ability to communicate effectively.
• Must be able to build and maintain positive business relationships with co-workers and other business contacts.
• Must have knowledge of a variety of computer software applications especially in MS Office.
• Specific certifications and trainings adding to the global experience of this professional welcomed and desired.

Physical Requirements:

• Ability to sit and/or stand for extended periods.
• Ability to perform work on a computer for extended periods.
• Ability to attend work per assigned schedule and attend meetings with excellent attendance and punctuality.
• Ability to bend and lift up to 25 lbs.