Job Description
Job Description
Mindbank Consulting Group has an immediate need for a Reporting Developer with expertise in SQL, enterprise data warehouse systems, ETL, visualization, SSRS, AWS QuickSight report development and Python scripting. The Reporting Developer will be responsible for creating, maintaining, and supporting reports for the ECOSphere system, a major system dedicated to improving the conservation of species through data analysis.
Reporting Developer Responsibilities:
• Requirements Gathering: Collaborate with stakeholders, including conservation experts
and data analysts, to gather reporting requirements. Understand the data sources, key
metrics, and visualization preferences that will aid in improving species conservation.
• Data Analysis and ETL: Analyze the existing data structure and schema of the
system's enterprise data warehouse to identify relevant data sources for
reporting. Apply ETL (Extract, Transform, Load) techniques to ensure the accuracy and
integrity of the data used in reporting.
• Report Development: Must be able to utilize SQL, visualization tools, SSRS, AWS QuickSight, and Python scripting skills to design and develop reports that extract and transform data from the
enterprise data warehouse. Implement filters, aggregations, and calculations to
generate insightful reports that facilitate decision-making for species conservation.
• Visualization and Presentation: Utilize AWS QuickSight and other appropriate
visualization tools to create visually appealing and interactive reports. Ensure that the
reports effectively communicate complex data and insights in a user-friendly manner.
• Python Scripting: Develop Python scripts to automate data extraction, transformation,
and analysis processes. Leverage Python libraries and frameworks to enhance the
efficiency and accuracy of data processing tasks.
• Testing and Quality Assurance: Thoroughly test the developed reports and Python
scripts to ensure accuracy, reliability, and alignment with the defined requirements.
Address any issues or bugs identified during the testing phase.
• Documentation: Create comprehensive documentation for the developed reports and
Python scripts, including data sources, queries used, report specifications, and any
relevant instructions for end-users and other developers.
• Collaboration: Collaborate with our client staff to create, support, and update reports.
• Provide detailed report requirements documentation, including data sources, parameters, metrics, and visualization preferences.
• Efficiently develop reports using AWS QuickSight and other visualization tools, with relevant SQL queries and Python scripts.
• Provide fully functional and tested reports and Python scripts.
• Provide documentation for the developed reports and Python scripts, including technical specifications and user instructions.
Responsibilities
- Mindbank Consulting Group has an immediate need for a Reporting Developer with expertise in SQL, enterprise data warehouse systems, ETL, visualization, SSRS, AWS QuickSight report development and Python scripting
- The Reporting Developer will be responsible for creating, maintaining, and supporting reports for the ECOSphere system, a major system dedicated to improving the conservation of species through data analysis
- Requirements Gathering: Collaborate with stakeholders, including conservation experts
- and data analysts, to gather reporting requirements. Understand the data sources, key
- metrics, and visualization preferences that will aid in improving species conservation
- Data Analysis and ETL: Analyze the existing data structure and schema of the
- system's enterprise data warehouse to identify relevant data sources for
- Apply ETL (Extract, Transform, Load) techniques to ensure the accuracy and
- integrity of the data used in reporting
- Report Development: Must be able to utilize SQL, visualization tools, SSRS, AWS QuickSight, and Python scripting skills to design and develop reports that extract and transform data from the
- Implement filters, aggregations, and calculations to
- generate insightful reports that facilitate decision-making for species conservation
- Visualization and Presentation: Utilize AWS QuickSight and other appropriate
- visualization tools to create visually appealing and interactive reports
- reports effectively communicate complex data and insights in a user-friendly manner
- Python Scripting: Develop Python scripts to automate data extraction, transformation,
- and analysis processes
- Leverage Python libraries and frameworks to enhance the
- efficiency and accuracy of data processing tasks
- Testing and Quality Assurance: Thoroughly test the developed reports and Python
- scripts to ensure accuracy, reliability, and alignment with the defined requirements
- Address any issues or bugs identified during the testing phase
- Documentation: Create comprehensive documentation for the developed reports and
- Python scripts, including data sources, queries used, report specifications, and any
- relevant instructions for end-users and other developers
- Collaboration: Collaborate with our client staff to create, support, and update reports
- Provide detailed report requirements documentation, including data sources, parameters, metrics, and visualization preferences
- Efficiently develop reports using AWS QuickSight and other visualization tools, with relevant SQL queries and Python scripts
- Provide fully functional and tested reports and Python scripts
- Provide documentation for the developed reports and Python scripts, including technical specifications and user instructions