What are the responsibilities and job description for the Power BI Developer position at 1100 Applied Industrial Technologies, Inc.?
We are seeking a Power BI developer to work within our Business Intelligence team to design, develop, test and implement Power BI dashboards and reports for SAP and Non-SAP source systems. Participate in business requirements gatherings, prepare technical documents, perform gap analysis and design the front-end objects to facilitate custom reporting and data analytics solutions. Provide support and maintenance of all components, troubleshoot and debug data issues. Perform other duties as assigned. Required Skills Experience in Power BI developing visual dashboards, KPI scorecards, and reports utilizing Power View, Power Map and Power Pivot. Consume data from Azure Analysis Services, Azure SQL database, SQL Server and other sources to create custom reports. Design complex data intensive formatted reports utilizing various functions in Power BI. Write complex DAX functions in Power BI and Power Pivot. Create row level security on data models. Published paginated reports in Workspaces. Coding experience in SQL/Python. Deploy objects in Power BI Desktop, Power Automate, Web Clients and Mobile Applications. Knowledge of Azure Synapse Analytics pipelines, and Databricks Notebooks. Debug data issues and maintain performance. Work on projects and provide support. Preferred Skills Knowledge of ML, AI and Predictive Analytics. Familiarity with BusinessObjects, SAP BW and BODS. Exposure to SAP ECC, Prophet 21 and JIRA. Requirements: 2 years proven experience in Business Intelligence environment, including technical documentation / functionality Knowledge of relational database structure and functionality Proven analytical and problem solving ability, time management and prioritization skills Understanding of reporting tools such as Business Objects suite of products (Web Intelligence, Dashboards-Xcelsius or Design Studio) or similar BI tools Demonstrated knowledge of SQL or equivalent Continuous learning mindset Bachelor’s Degree OR equivalent experience Must live in Cleveland metro area. We are unable to provide relocation expenses Must be legally authorized to work in the United States. Sponsorship will not be provided for this position Founded in 1923, Applied Industrial Technologies (NYSE: AIT) is a leading value-added distributor and technical solutions provider of industrial motion, fluid power, flow control, automation technologies, and related maintenance supplies. Our leading brands, specialized services, and comprehensive knowledge serve MRO and OEM end users in virtually all industrial markets through our multi-channel capabilities that provide choice, convenience, and expertise. Applied Industrial Technologies is built on a philosophy that puts people first. We are an equal opportunity employer, and we are committed to a workforce in which we enforce fair treatment and provide growth opportunities for everyone. All qualified applicants will receive consideration for employment regardless of age, race, color, national origin, genetics, religion, gender, marital status, physical or mental disability, or any other characteristic protected by applicable laws, regulations, and ordinances. Our Work Experience is the combination of everything that’s unique about our culture, our core values, our company meetings, our commitment to success, our recognition programs, but most importantly, it’s our people. Our employees are self-disciplined, hardworking, curious, trustworthy, humble and truthful. They make choices according to what is best for the team, they live for opportunities to collaborate and make a difference, and they make us the #1 Top Workplace in our area.