POSITION: IT SENIOR ENGINEER – POWER BI
LOCATION: PIFFARD, NY – ONSITE/HYBRID
DEPARTMENT: IT
REPORTS TO: DIRECTOR OF IT
POSITION SUMMARY
We are seeking a high-impact Senior BI Engineer to serve as the technical backbone of our financial data and operations. This is a ‘full-stack’ data role for a senior professional comfortable performing deep-level MSSQL Database Administration and collaborating with executive stakeholders to re-engineer complex business processes.
The ideal candidate translates complex financial requirements into scalable technical architecture, ensuring our systems are as agile as our business.
KEY RESPONSIBILITIES
- Systems Architecture: Serve as the primary architect for our bespoke ERP system, managing data integrity, database performance, and vendor integrations.
- BI Development Leadership: Own the end-to-end lifecycle of SSRS and PowerBI development, from initial requirement gathering to development delegation and maintenance.
- Business Process Re-engineering: Act as a strategic partner to Finance and Operations, identifying friction points in current workflows and designing automated, data-driven solutions.
- Advanced Data Engineering: Develop, optimize, and maintain complex stored procedures, CTEs, and SSIS packages within a high-availability MSSQL environment.
- System Health & Governance: Lead preventive maintenance workflows, manage software updates, and ensure long-term stability of the database environment.
- Knowledge Leadership: Create comprehensive system documentation and lead training sessions to empower internal teams and improve data literacy across the organization.
EDUCATION AND EXPERIENCE
Education: Bachelor’s degree in information systems, Business Analytics, Computer Science, or a related field.
Experience: 5+ years of progressive experience in business intelligence, data engineering, or financial systems analysis.
TECHNICAL STACK MASTERY:
- MSSQL Expert: Advanced proficiency in SSMS, SSRS, and SSIS.
- Data Modeling: Proven ability to design efficient, scalable data structures.
- Visualization: Expert-level PowerBI (or similar) dashboard development.
- Analytical Mindset: Strong ability to parse complex financial data and identify actionable trends.
- Communication: Exceptional ability to ‘bridge the gap’ between technical IT requirements and non-technical business needs.
PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Individuals may need to sit or stand as needed. May require walking primarily on a level surface for periodic periods throughout the day. Reaching above shoulder heights, below the waist or lifting as required to file documents or store materials throughout the workday. Proper lifting techniques required. May include lifting to 25 pounds for files and computer printouts on occasion.
COMPENSATION
- Position Pay Range: $95,000 – $115,000 Annually
- Phone Reimbursement: $120/month
- This position is eligible for Healthcare, 401K, and PTO benefits.
- This position is eligible for the company’s discretionary bonus.
- In-person position at 3768 Main Street Piffard, NY 14533. Potential to go Hybrid.
- Working Days: Monday – Friday
- Occasional evening and/or weekend hours as needed.
PLEASE DOWNLOAD OUR APPLICATION, FILL OUT, SAVE YOUR CHANGES AND THEN UPLOAD USING THE FORM BELOW. THANK YOU!
Application:
https://americanrocksalt.com/wp-content/uploads/2022/08/ARS_Application_6_2021.pdf
