Mactac
Power BI Developer
Mactac, Stow, Ohio, United States, 44224
Position Summary
Power BI / Report Developer will be responsible for the creation, enhancement, administration and maintenance of the enterprise Power BI, SSRS and other reporting tools. This position will also be responsible for related automation tool, data interfaces and integration and process development such as using Microsoft Power Automate and Power Apps. This role will work with other Business Analysts and Power Users to get the requirements for new reports or for the enhancement of existing.
Duties & ResponsibilitiesMaintain the daily operations and security of all reporting solutions such as Power BI, SSRS, Power Automate, Power Apps as required.Develop new reports, queries, views, dashboards, KPIs and automation as required by the organization and defined by a Business Analysts or Power User.Maintain and enhance existing reporting solutions and automation as required to meet the needs of the organization.Assist with the budgeting and licensing of all reporting and automation solutions.Manage user and data security as required for the reportingAudit and monitor all reporting solutions for the accuracy of the information being published and to the timely availability to all users.Provide Training to the Business Analysis, Power Users and End user Support team on all reporting and automation solutions, who in turn will train and support the end users.Establish and maintain an "Enterprise" IT supported portal for officially validated company reports and a "User Created" portal where others can share reports that they create but IT doesn't directly supportEstablish training for end users to build their own Power BI reports and a peer support group to assist those who participatePresent to the Executive and Management leaders the status of the reporting and automation solutions and recommendations for enhancements to keep our environment properly licensed, patched, updated and supported.Work with the infrastructure team to ensure all reporting and automation solutions are properly backed up and are operationally within our Technology infrastructure.Remain current on understanding of all applications used across the organization and options for extracting and utilizing the data from each of these.Maintain KPIs for the operation and accuracy of the reports and automation used across the enterprise.Understand and utilize technology to meet the needs of the organization, including mobile devices, data warehouse, data lakes, and other related business intelligence solutions.Assist with internal and external audits requiring special extraction of data.Learn and maintain a working knowledge of the data structures, schemas and integrations of our core business systems, which today include; JDE, Greycon, RFPathways, Sharepoint, ESKERS, and more as needed.Scope:
Decision Impact:
(Enterprise Wide)Contacts : Internal & ExternalReports Relationships:
Position Reports to (Direct): VP of IT
Physical Requirements: NoneLocation:
Stow, OHWork Authorization:
Legal authorization to work in the US is required. We will not sponsor individuals for employment visas, now or in the future, for this job opening.Travel:
0%-10%Knowledge & Skill Needed:
Education:
Bachelor's degree in Information Systems, business, related field, or demonstratable work experiencePreferred certifications in business intelligence, business reporting, SQL, database design/systems or systems technologies
Experience:
5+ Years of experience in Information Technology roles5+ Years of Business Analytics, Reporting and data integrations5+ Years of experience with Microsoft SQL Server, SQL syntax, SQL Stored Procedures5+ Years of experience with Microsoft Power BI, Power Automate, Power Apps, SSRS5+ Years of experience working with users in the definition, development, testing and implementation of reporting solutions5+ Years of experience with an ERP system with understanding on the core data flows and schemasExceptional problem solving and analytical skills
What You'll Love About Us:
Learning & Development : Tuition assistance available along with an internal training budget. Get with a hands-on company, in a fast-paced environment where you can have the runway to make change.Rest & Relaxation:
10 paid holidays off per year on top of a generous vacation policy.Great company culture:
Work for a company that genuinely values work/life balance. We also have a give back mentality with participation in a variety of community activities & events.Health Benefits:
Medical with HSA options, Dental, and Vision starting day one for you and your family. Gym on-site with a weekly yoga class.Prepare for the Future:
Competitive 401(k) with company match.Disclaimers:
The above information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.It is the policy of Mactac that all employees are employed at the will of Mactac for an indefinite period and are subject to termination at any time, for any reason, with or without cause or notice. At the same time, employees may terminate their employment at any time and for any reason.Equal Opportunity Employer. All qualified candidates will receive consideration for employment and will not be discriminated against based on race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, pregnancy, genetic information, creed, citizenship status, marital status or any other consideration prohibited by law or contract.
We will not accept unsolicited resumes from agencies. Please do not send agency resumes to our website or Mactac and affiliated employees.
Power BI / Report Developer will be responsible for the creation, enhancement, administration and maintenance of the enterprise Power BI, SSRS and other reporting tools. This position will also be responsible for related automation tool, data interfaces and integration and process development such as using Microsoft Power Automate and Power Apps. This role will work with other Business Analysts and Power Users to get the requirements for new reports or for the enhancement of existing.
Duties & ResponsibilitiesMaintain the daily operations and security of all reporting solutions such as Power BI, SSRS, Power Automate, Power Apps as required.Develop new reports, queries, views, dashboards, KPIs and automation as required by the organization and defined by a Business Analysts or Power User.Maintain and enhance existing reporting solutions and automation as required to meet the needs of the organization.Assist with the budgeting and licensing of all reporting and automation solutions.Manage user and data security as required for the reportingAudit and monitor all reporting solutions for the accuracy of the information being published and to the timely availability to all users.Provide Training to the Business Analysis, Power Users and End user Support team on all reporting and automation solutions, who in turn will train and support the end users.Establish and maintain an "Enterprise" IT supported portal for officially validated company reports and a "User Created" portal where others can share reports that they create but IT doesn't directly supportEstablish training for end users to build their own Power BI reports and a peer support group to assist those who participatePresent to the Executive and Management leaders the status of the reporting and automation solutions and recommendations for enhancements to keep our environment properly licensed, patched, updated and supported.Work with the infrastructure team to ensure all reporting and automation solutions are properly backed up and are operationally within our Technology infrastructure.Remain current on understanding of all applications used across the organization and options for extracting and utilizing the data from each of these.Maintain KPIs for the operation and accuracy of the reports and automation used across the enterprise.Understand and utilize technology to meet the needs of the organization, including mobile devices, data warehouse, data lakes, and other related business intelligence solutions.Assist with internal and external audits requiring special extraction of data.Learn and maintain a working knowledge of the data structures, schemas and integrations of our core business systems, which today include; JDE, Greycon, RFPathways, Sharepoint, ESKERS, and more as needed.Scope:
Decision Impact:
(Enterprise Wide)Contacts : Internal & ExternalReports Relationships:
Position Reports to (Direct): VP of IT
Physical Requirements: NoneLocation:
Stow, OHWork Authorization:
Legal authorization to work in the US is required. We will not sponsor individuals for employment visas, now or in the future, for this job opening.Travel:
0%-10%Knowledge & Skill Needed:
Education:
Bachelor's degree in Information Systems, business, related field, or demonstratable work experiencePreferred certifications in business intelligence, business reporting, SQL, database design/systems or systems technologies
Experience:
5+ Years of experience in Information Technology roles5+ Years of Business Analytics, Reporting and data integrations5+ Years of experience with Microsoft SQL Server, SQL syntax, SQL Stored Procedures5+ Years of experience with Microsoft Power BI, Power Automate, Power Apps, SSRS5+ Years of experience working with users in the definition, development, testing and implementation of reporting solutions5+ Years of experience with an ERP system with understanding on the core data flows and schemasExceptional problem solving and analytical skills
What You'll Love About Us:
Learning & Development : Tuition assistance available along with an internal training budget. Get with a hands-on company, in a fast-paced environment where you can have the runway to make change.Rest & Relaxation:
10 paid holidays off per year on top of a generous vacation policy.Great company culture:
Work for a company that genuinely values work/life balance. We also have a give back mentality with participation in a variety of community activities & events.Health Benefits:
Medical with HSA options, Dental, and Vision starting day one for you and your family. Gym on-site with a weekly yoga class.Prepare for the Future:
Competitive 401(k) with company match.Disclaimers:
The above information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.It is the policy of Mactac that all employees are employed at the will of Mactac for an indefinite period and are subject to termination at any time, for any reason, with or without cause or notice. At the same time, employees may terminate their employment at any time and for any reason.Equal Opportunity Employer. All qualified candidates will receive consideration for employment and will not be discriminated against based on race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, pregnancy, genetic information, creed, citizenship status, marital status or any other consideration prohibited by law or contract.
We will not accept unsolicited resumes from agencies. Please do not send agency resumes to our website or Mactac and affiliated employees.