What are the responsibilities and job description for the Power BI Consultant (Onsite / Contract) position at American IT Systems?
Power BI Developer
San Antonio, Texas
Duration: 6 months
Key Responsibilities
- Design, develop, and maintain Power BI reports and dashboards for Finance and Operations.
- Develop, optimize, and troubleshoot SQL queries and report datasets.
- Build and optimize reporting solutions for Inventory, Sales, COGS, Accounts Payable (AP), Open Receipts, Floor Stock, WIP, Capital Reporting, and Weekly Operational Tracking.
- Validate business rules and ensure data accuracy across reporting solutions.
- Enhance existing reporting processes by reducing manual effort and improving automation.
- Implement business workflows, alerts, notifications, and exception monitoring mechanisms.
- Support automation initiatives including Vendor Statement & Invoice Management and other document-driven processes.
- Integrate data from multiple enterprise platforms such as PeopleSoft, Infor LN, Databricks/Hadoop, MES, SharePoint, and other approved sources.
- Work closely with business SMEs to understand reporting requirements and translate them into technical solutions.
- Conduct data analysis and support KPI definition, validation, and reporting optimization activities.
- Participate in User Acceptance Testing (UAT), defect resolution, deployment, and post-implementation support.
- Prepare technical documentation and deliver knowledge transfer sessions to end users and support teams.
Required Skills
- Strong experience in Microsoft Power BI development.
- Proficiency in SQL development, query tuning, and data analysis.
- Experience in data modeling, Power Query, and DAX.
- Knowledge of reporting automation and business process improvement.
- Experience working with enterprise data platforms and multiple data sources.
- Strong analytical, problem-solving, and stakeholder management skills.
- Ability to gather and document business requirements effectively.
Preferred Skills
- Exposure to Accounts Payable, Inventory Management, Capital Reporting, and Operational Reporting processes.
- Experience with PeopleSoft, Infor LN, Databricks, Hadoop, MES, and SharePoint.
- Understanding of workflow automation and document management processes.
- Experience supporting UAT, deployment, and business process transformation initiatives.
Key Deliverables
- Automated and optimized business reporting solutions.
- Interactive operational and financial dashboards.
- SQL-based reporting and data integration solutions.
- Workflow automation, alerts, and notification mechanisms.
- Inventory, Accounts Payable, Capital Reporting, and Operational Tracking analytics solutions.
- Documentation, knowledge transfer, and post-deployment support.
Salary : $40 - $50