Python Developer Advanced SQL

Actio Net is seeking a Python Developer to develop and maintain enterprise dashboards focused on cost, project progress, and data quality. This role requires advanced Python programming and SQL expertise to build data-driven reporting solutions integrated with an open-source visualization platform. The developer will create interactive, user-friendly dashboards and implement row-level security to ensure data access is appropriately restricted by geographic location, team, and user permissions.

The ideal candidate is organized, detail-oriented, and an effective communicator who can collaborate with technical teams and business stakeholders to deliver reliable, secure, and actionable reporting solutions.

Location:

Hybrid - 2 times a week in Suitland, MD

Develop, maintain, and enhance Python scripts and applications supporting enterprise dashboards and reporting solutions.

Write, optimize, and troubleshoot advanced SQL queries to retrieve, manipulate, validate, and transform data from multiple sources.

Apply modular programming practices to create reusable, maintainable, and efficient Python code.

Integrate Python-based data processing and dashboard functionality with an open-source data visualization platform.

Develop interactive, engaging, and well-structured visualizations that communicate cost, project progress, performance metrics, and data quality to diverse end users.

Implement and maintain row-level security and data access permissions based on geographic locations, organizational teams, and user roles.

Validate data accuracy, completeness, and consistency to ensure the reliability of dashboards and reports.

Debug Python scripts, resolve SQL query issues, troubleshoot data discrepancies, and improve application performance.

Collaborate with stakeholders to gather requirements, clarify reporting needs, and translate business objectives into functional dashboard capabilities.

Maintain technical documentation for code, queries, data processing logic, dashboard functionality, and access controls.

Follow established coding standards, version control practices, testing procedures, and data security requirements.

Communicate technical issues, development progress, and data-related findings clearly to technical and nontechnical stakeholders.

Manage multiple development tasks and priorities while maintaining strong attention to detail and delivery timelines.

Advanced Python programming skills, including modular design, data manipulation, debugging, and code maintenance.

Advanced SQL proficiency is required, including complex queries, joins, aggregations, data validation, and query optimization.

Hands-on experience developing dashboards, reports, or data visualizations using Tableau, Microsoft Power BI, or comparable BI tools.

Experience implementing row-level security, role-based access controls, or similar data access restrictions.

Experience integrating data processing scripts with reporting or visualization platforms.

Strong analytical and troubleshooting skills, with the ability to identify and resolve coding, query, and data quality issues.

Excellent organizational skills, attention to detail, and effective written and verbal communication skills.

Ability to collaborate with technical teams and business stakeholders and explain technical concepts to diverse audiences.

Experience with open-source visualization platforms such as Apache Superset, Metabase, or Plotly Dash.

Experience with R or SAS for data manipulation, statistical analysis, or reporting.

Familiarity with relational databases such as PostgreSQL, Microsoft SQL Server, or MySQL.

Experience using Git or other version control systems.

Knowle…