remote
Technical Reporting and Data Analyst - PI Technologies LLC
Data Analyst
Data‑driven analyst skilled in Python, SQL, Power BI, Tableau, and Excel, responsible for designing, automating, and optimizing reporting solutions that inform strategic decisions and operational excellence.
About the role
Key Responsibilities
- Design, develop, and maintain automated dashboards and reports using Power BI and Tableau to provide actionable insights across the organization.
- Extract, transform, and load (ETL) data from multiple sources, ensuring data quality and integrity through rigorous validation and cleansing processes.
- Collaborate with cross‑functional teams to define business requirements, translate them into technical specifications, and deliver solutions that support strategic decision‑making.
- Implement data models and optimize SQL queries for performance, scalability, and maintainability.
- Document data flows, reporting logic, and best practices to enable knowledge transfer and future enhancements.
Requirements
- Proven experience with Python for data manipulation and automation.
- Strong SQL skills and familiarity with relational database design.
- Hands‑on expertise in Power BI and Tableau for interactive visualizations.
- Advanced proficiency in Excel, including pivot tables, advanced formulas, and VBA.
- Excellent analytical, problem‑solving, and communication skills.
Skills
pythonsqlpower bitableauexcel