BI Developer

Wagner Equipment Co. offers challenging career opportunities, extensive training and employee development along with an opportunity to grow your career and thrive under Wagner's reputation for excellence. We offer excellent benefits and supply you with the tools you need to maximize your potential and grow within Wagner.

Benefits include:

Paid Time Off (PTO) Plan

• Up to 96 hours of PTO in your first year + 8 company paid holidays Medical, dental, and vision insurance Life and AD&D InsuranceLife and AD&D Insurance Retirement Plans
• Life and AD&D InsuranceRetirement Plans
• 401K and Roth 401K , eligible employees can receive a company contribution up to 7% Tuition Reimbursement Employee Assistance Program (EAP) CEFCU
• Employees have access to services include payroll deductions savings, accounts, loans, VISA card, and more.

Additional Benefits include:

Supplemental life Insurance, Critical Illness + Accidental Insurance, ID WatchDog and discounted employee phone plans. We're on a journey to transform our BI landscape, and this role is critical to that mission. Our current environment includes multiple SQL Servers and varied, often inconsistent data sources. While the dashboards may not yet reflect a modern, sleek design, there's a significant opportunity to build order from complexity and drive real improvements. The ideal candidate is someone who is not only proficient in Power BI and DAX but also excels in data modeling and can navigate a challenging data environment. This role offers a chance to develop new technical skills in cloud technologies and modern Microsoft tools while driving critical business insights. What's in It for

You:

This is a unique opportunity to shape the future of our BI department. If you're ready to address complex data challenges and develop new technical skills in a supportive yet evolving environment, you'll find both professional growth and the chance to make a meaningful impact. While the current data landscape has its challenges, it also offers the potential for significant innovation and career development.

Pay Range:

$66,697.52

• $91,768.

39 Annually Pay range is dependent upon education & experience.

Job Overview Responsibilities may include:

Database & Data Modeling:

Develop, document, and maintain databases on SQL Server and Azure. Analyze and integrate distributed data sources, even when faced with inconsistent naming conventions and fragmented documentation. Design master tables that consolidate data into a coherent framework.

BI Tool Administration & Governance:

Enhance and maintain Power BI dashboards that effectively communicate insights to a diverse audience. Write and optimize complex SQL and DAX queries to support robust reporting and analytics. Support our ongoing transition to the cloud by leveraging Azure, Fabric, and related Microsoft technologies, including Power Apps, Power Automate, pipelines, and forms.

ETL and Data Management:

Implement ETL processes to consolidate data from various sources, ensuring data integrity and reliability despite initial challenges. The architecture followed is the medallion method, ideally for modular and scalable data foundations, which is going to be continued in the cloud.

Documentation & Process Improvement:

Develop clear documentation for data sources, processes, and system relationships. Collaborate with business analysts and use Jira for structured ticket-based development, ensuring that evolving business requirements are accurately captured and addressed.

Collaboration & Communication:

Work closely with cross-functional teams to bridge the gap between technical complexities and business needs. Provide clear communication on data challenges and propose pragmatic solutions to stakeholders. Mentor colleagues on best practices in BI, data modeling, and dashboard design.

Training & Mentorship:

Educate internal teams on BI products and emerging cloud tools within the Microsoft ecosystem. Share expertise to help foster a more data-driven culture across the organization.

Data Governance :

Understanding of data security levels. Understanding data types. Assist with creating standards for data and database objects. Work with the team to create templates for reporting.

Basic Requirements:

Must be legally authorized to work in the United States on a full-time basis for anyone other than current employer. 5 or more years of experience with database development and data visualization. Proficiency in SQL Server, Power BI, and DAX. Strong data modeling expertise with the ability to synthesize disparate data sources into a unified model. Willingness to embrace a cloud-first strategy and adapt to evolving BI technologies. Excellent communication skills, capable of articulating technical challenges to both technical and non-technical stakeholders. A collaborative mindset with a focus on continuous improvement and process documentation. A proactive approach to problem solving, recognizing that while challenges exist, they also present opportunities for growth and innovation.

Preferred Qualifications:

Python experience is a plus for advanced data manipulation and automations tasks. Experience with Azure, Microsoft Fabric, and related tools (Power Apps, Power Automate, pipelines, and forms) is highly desirable.

Physical Demands & Competencies:

Standing, walking, talking, sitting, use of hands & hearing Data Entry, telephone, reading/writing, reasoning, organizational, communication & math skills

Safety & Product Knowledge Other Duties:

Job Offers are contingent upon all required pre-employment screenings which may include but are not limited to background checks, drug/alcohol testing, fit for duty testing, and any other job-related tests/screenings. Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. Requirements are representative of minimum levels of knowledge, skills and/or abilities. To perform this job successfully, the employee must possess the abilities or aptitudes to perform each duty proficiently. Wagner Equipment Co. is an EEO/AA/Veterans/Disabled employer.