Overview
Skills
Job Details
Mindbank Consulting Group has an anticipated need for a Report Developer with expertise in SQL, enterprise data warehouse systems, ETL, visualization, SSRS, AWS QuickSight, and Python scripting. This is a bid, so this is an anticipated opportunity.
- Where? Falls Church, Virginia, OR Fort Collins, CO, and FULLY ONSITE, 5 DAYS PER WEEK. This is not hybrid; this is not remote; exceptions cannot be made. Mindbank does not provide relocation assistance.
- How much? Salaries are based on each applicant’s professional experience and skills. Please feel comfortable speaking about your compensation requirements; I will be transparent with you during our conversation.
The Report Developer will be responsible for creating, maintaining, and supporting reports for our client’s major system dedicated to improving the conservation of species through data analysis.
Report 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: 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, 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 USFWS 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.
Report Developer Qualifications:
Required Qualifications:
Preferred Qualifications:
- Experience with data warehousing and ETL processes.
- Knowledge of data modeling and dimensional data modeling techniques.
- Familiarity with scripting languages such as Python or R for data manipulation and analysis.
- Understanding of data governance and data security best practices.
- Certification in relevant technologies (e.g., SQL Server, QuickSight).
Why should you work for Mindbank?
Since 1986, Mindbank has helped hundreds of clients solve some of the most complex IT problems through the strategic implementation of solutions and resources. Our clients include US Federal agencies, State & Local Governments, Tribal Organizations, Fortune 1000 companies, as well as Small Businesses.
Mindbank believes that our employees deserve the best care that our company can provide. We offer our employees a comprehensive and competitive benefits package including:
- Medical Insurance
- Dental Insurance
- Vision Insurance
- Life Insurance
- Long Term Disability
- Short Term Disability
- 401 (k) Plan
- Paid Time Off
- Training and Education Reimbursement
- Referral Bonuses
As an Equal Opportunity Employer, Mindbank is committed to a diverse workforce and we seek the most qualified candidate for each opening without regard to race, color, religion, age, gender, gender identity, marital status, sexual orientation, national origin, protected veteran status, or disability status.