Why MacAllister Machinery? We offer more than just a job—we offer a career path with endless possibilities. Stability is important in the way we operate. Our current team members fill more than 30% of our jobs internally and on average, just over 40% of those individuals are being promoted! If you want endless opportunities to further your career, we work hard to provide you with those choices! Our average tenure in the company is 9.2 years and our turnover is well below industry average because of the culture we have built! We serve thousands of customers and have a massive operation that spans across 40+ locations across Indiana and Michigan! Be Part of Something Bigger At MacAllister Machinery, your work matters. You will play a key role in providing the infrastructure that powers industries, builds communities and forms the roads we commute on! Our team members don’t just fill positions—they make a real impact in the communities we live in each and every day! Position Summary This position is responsible for serving as a technical expert on designing, developing, testing and debugging new and existing Dashboards, Reports, and Data Models (cloud and/or in-house) using a variety of concepts, techniques and programming languages including, but not limited to: SQL, Power BI, SSRS, SSAS, and SSISPosition Duties/ResponsibilitiesPrimary Responsibilities:Design and develop business intelligence solutions for reporting and dashboards, data modelling, data warehousing, required for new and existing systems and/or applicationsDevelop and Architect Power BI reporting, SQL Server Report Services (SSRS) and, tabular data models (SSAS)Develop Operational reports to assist in day-to-day processes, focus on empowering end usersDevelop Corporate Dashboards to provide insight into corporate financialsAssist business units with Ad Hoc reporting and design and enhance data models to encourage Ad Hoc reporting. Build a BI ecosystem that enables power users to self serve the data they need, including recurring reporting. Coordinate and/or participate in special projects Analyzing business application requirements for functional areas such as Finance, Marketing, Human Resources, Parts, Service, and SalesWork with the business and other members of the IT Department to implement Data Models that will enable the business to do more advanced Ad Hoc reportingWork with the business and other members of the IT department to gather specifications regarding business requestsDesign and develop necessary databases, libraries, and systems support functions required for new and existing systems and/or applicationsGenerate code at the Enterprise Level, utilizing advanced programming techniques, logic flow, and data file processing features such as record locking, commitment control and security controlConducts system integration and user acceptance testing, ensuring successful and error-free production implementation.Partner with end-user to prototype, refine, test, and debug programs to meets needsProvides complete documentation for new or modified information systems and/or application software programsAssist Help Desk on technical computer hardware and software issues as requiredSupervisory Responsibilities:Typically, responsible for leading, coordinating and mentoring the work of others who perform the same type of work as this job. Lead responsibilities typically include training, coaching, and checking the work of others.Required:Candidate must be able to report onsite to Novi, MI or Indianapolis, IN (Hybrid work-schedule) Bachelor’s Degree in business related field (Software Engineering, Computer Science, Data Science) or equivalent years of experience7 years or more of experience in developing and implementing Dashboards, Reports, Data ModelsAbility to successfully complete an in-house code testSignificant hands on BI experience with Power BI, SSRS, SSAS – Tabular, Multi DimensionalProficiency in SQL, DAX. Preferred:10 years or more of experience in software development and testing5 years or more of experience with relational databasesExperience with DWH ETL tools like – SSIS, WhereScape Experience with the Azure suite of products for data, other BI products Custom Data visualization, front end UI, BI reporting, charts and dashboard template design experienceKnowledge, Skills and AbilitiesThe requirements listed below are representative of the knowledge, skills, and/or abilities required to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functionsAbility to build and maintain effective customer and professional relationships through strong interpersonal skills with emphasis on relationship-building and consistent demonstration of solid professional judgment.Ability to work in a fast-paced, high-pressure, deadline driven environment.Skills in complex problem solving, critical thinking, and creative thinking.Excellent communication skills, including verbal, written and listening skills.Strong project management skills and the ability to manage change and conflict.Ability to develop and implement processes and monitor performance with key process indicators.Detail-oriented and a team player with the ability to manage change, conflicts and projects.Ability to work independently without the need for daily direct supervision and a strong sense of urgency.Strong skill set with SQL Databases, Power BI, SSRS, Data Models.All MacAllister Machinery companies are an Equal Employment Opportunity Employer, including Disabled and Veteran applicants.