Reporting Developer - HYBRID with Security Clearance

---

Job description

Contact: Judy Bolton, Sr. Technical Recruiter UPDATE 10/31: Boo! There were four openings; we now have two. Please, PLEASE read the responsibilities and qualifications before applying. Have you done this kind of work before? Do you meet the minimum qualifications AND can I tell this from your resume? Thank you so much! - Judy Mindbank Consulting Group has an immediate need for an experienced Reporting Developer with expertise in SQL, enterprise data warehouse systems, ETL, visualization, SSRS, AWS QuickSight, and Python scripting. This is a contract lasting one and a half years. Work is hybrid, and candidates must be within commuting distance of either Falls Church, Virginia, or Fort Collins, Colorado, by the start of work. Onsite days are Mondays and Tuesdays plus every other Wednesday; this schedule is mandatory. Salary up to $110K and is based on each candidate's skills and experience. The Reporting Developer will be responsible for creating, maintaining, and supporting reports for our client's system dedicated to improving the conservation of species through data analysis. This position requires a government background investigation to obtain a Public Trust. • Candidates must be authorized to work for any employer in the United States. • Mindbank does not provide any sponsorship, and we do not work with any third-party companies.

Reporting Developer Responsibilities: have you done similar work?
• 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, 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 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. Reporting Developer Qualifications: include relevant technical information in your resume. If you meet the qualifications, show me how, please. I don't worry about page length.

Required Qualifications:
• Candidates must be US Citizens or US Permanent Residents. • Minimum of 5 years of professional experience in report design and development. • Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent work experience. • Strong professional background in SQL, SSRS, and QuickSight, along with excellent analytical and communication skills to efficiently and effectively translate business requirements into meaningful and visually appealing reports and dashboards. • Proficient in SQL and advanced SQL querying techniques. • Extensive experience with SQL Server Reporting Services (SSRS) for designing and deploying reports. • Hands-on experience with QuickSight or other modern data visualization tools. • Strong analytical and problem-solving skills. • Excellent communication and interpersonal skills to effectively interact with business Stakeholders.

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. • Federal government project experience is highly desired. • Certification in relevant technologies (e.g., SQL Server, QuickSight). 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.

<!– job description page –>