What are the responsibilities and job description for the Senior Developer - BI & Data Analytics position at MacAllister Machinery?
Description
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 SSIS
Position Duties / Responsibilities
Primary Responsibilities :
- Design and develop business intelligence solutions for reporting and dashboards, data modelling, data warehousing, required for new and existing systems and / or applications
- Develop 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 users
- Develop Corporate Dashboards to provide insight into corporate financials
- Assist 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 Sales
- Work 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 reporting
- Work with the business and other members of the IT department to gather specifications regarding business requests
- Design and develop necessary databases, libraries, and systems support functions required for new and existing systems and / or applications
- Generate code at the Enterprise Level, utilizing advanced programming techniques, logic flow, and data file processing features such as record locking, commitment control and security control
- Conducts 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 needs
- Provides complete documentation for new or modified information systems and / or application software programs
- Assist Help Desk on technical computer hardware and software issues as required
Supervisory Responsibilities :
Required :
Preferred :
Knowledge, Skills and Abilities
All MacAllister Machinery companies are an Equal Employment Opportunity Employer, including Disabled and Veteran applicants.
