Full Time Role
Location: Latham, NY
- Required work schedule is in the office Monday through Thursday, with remote work on Friday being optional.
Overview:
The client is looking for an experienced Business Intelligence Analyst/Developer who will work closely with business users to understand functional requirements and develop business solutions that improve the company's processes and increase the overall operational efficiencies.
- In this role, the BI Analyst/Developer mines data, develops analytics tools, and reports back on findings and solutions to executives and business users.
- Proficiency in SQL for data extraction, transformation, and manipulation is essential, along with the ability to design and implement efficient queries and stored procedures.
- Experience with data integration from various sources and a strong grasp of data warehousing concepts are crucial.
- The candidate should also be adept at troubleshooting, optimizing performance, and ensuring data accuracy.
- An action-oriented individual – You will leverage business intelligence tools such as Power BI to present data and visualization from the data warehouse or operational databases for actionable business insights. You are methodical at providing troubleshooting and have strong attention to detail as well as a passion for learning.
- Customer focused and find ways to get the job done – You have excellent business acumen skills, a customer focused demeanor, and know how to engage your team to position the client + customers to win.
- Someone who loves frequent data reports. In this role you will need to be accustomed to developing/modifying/analyzing up to a quantity of 15-20 reports/day. You will bring familiarity with Microsoft Fabric and data lakes, experience with other BI tools (e.g., Tableau), knowledge of programming languages such as Python or R, and experience in data visualization best practices. You understand agile methodologies and experience in working within a collaborative team environment will be advantageous.
Requirements:
5 plus years’ hands-on experience with the following:
Power BICreating SQL queries and views within MS SQL ServerMS Excel, and Excel Pivot tables
Preferred Skills:
Microsoft FabricData lakesPythonData visualization best practicesAgile methodologiesTableauQlik
Industry experience:
Experience in the Distribution and Manufacturing industryExperience working in mid-sized, high growth, changeable environments, with competing priorities