TITLE: Business Intelligence Developer

REPORTS TO: Director of IT

DIRECT REPORTS: None

LOCATION (CHOICE OF):

Bonner, MT

DeLand, FL

Hartford, WI

Portland, ME

Sioux Falls, SD

Winslow, ME

Waco, TX

DATE: January 2023

SUMMARY:

Alcom’s IT Business Intelligence is essential for our business success, which is centered on empowering our employees and customers. We are seeking a motivated Business Intelligence Developer who is eager to utilize and grow his or her technological skills to help Alcom maintain its industry-leading position and scale to new heights. Our ideal candidate will be passionate about applying their skills to a technology-based business model that best facilitates smooth and efficient business operations. The Business Intelligence Developer is responsible for the creation and maintenance of various BI reports and analysis, data models, and analytical tools to provide data analytical support to various operations competencies of an organization. The Business Intelligence Developer will be the ERP system champion and assist users with SOPs and error resolution.

FUNCTIONS AND RESPONSIBILITIES:

• Define and deliver metrics, reporting platforms, dashboards, and analytical models vital for tracking and managing the business
• Identify business challenges and initiate process improvement projects
• Facilitate the computerization of analytics and data collection processes
• Provide analyses for large datasets necessary for decisions using actionable insights
• Collaborate with Marketing, Sales, Engineering, Operations, etc. to build scalable processes and metrics
• Responsible for carrying out complex analysis of datasets and conduct appropriate data validation
• Responsible for gathering and cleaning of datasets across multiple data sources
• Responsible for spotting vital insights and developing the framework of the organization’s data system
• Provide information on analytic results to business and functional leaders using visualizations to communicate data and metrics, including data maps, leveraging Tableau, etc.
• Define vital people data performance indicators
• ERP ETL functions to migrate systems
• Power BI reporting and maintenance
• SSRS reporting and maintenance
• DBA tasks as required
• Create SOPs and process improvements for the ERP system
• Work with ERP support to solve errors, report bugs, and coordinate upgrades to new versions
• Other duties as assigned

*Basic Qualifications*

• Experience with: ERP Systems, ETL, SQL, Power BI, SSRS, Microsoft Office Suite
• Excellent communication, interpersonal skills, and attention to detail
• Excellent problem-solving and troubleshooting skills. Motivated self-starter and self-sufficient
• Bachelor’s degree in Analytics, Computer Science with 4+ years of relevant work experience. Work experience equivalence will be considered

*Preferred Qualifications*

• 4+ years of experience with data analytics
• ETL experience; migrating ERP systems
• Made 2 Manage, QuickBooks, and Genius Manufacturing ERP experience
• Other programming language experience
• Experience with SQL development to manage creating and maintaining functions, stored procedures, packages, triggers, and data structures
• 3 years of experience working with Microsoft Business Intelligence Stack having Power BI, SSAS, SSRS, and SSIS
• Experience in data preparation, data gateway, and data warehousing projects
• Working knowledge of entity relationship modeling

Salary Commensurate with Experience

EOE

Job Type: Full-time

Pay: $65,000.00 - $80,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee discount
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Referral program
• Retirement plan
• Vision insurance

Schedule:

• Day shift
• Monday to Friday

Work Location: One location

ohsreunions.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, ohsreunions.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, ohsreunions.com is the ideal place to find your next job.