Data Analyst
Haystack
Job Overview
Who's the hiring manager?
Sign up to PitchMeAI to discover the hiring manager's details for this job. We will also write them an intro email for you.
Job Description
Data Analyst at Haystack
We're working with a leading consulting firm supporting critical government initiatives on this exciting opportunity. This isn't just any data analyst role; you'll be a mission-focused Technical Data Analyst, owning the "last mile" of data delivery as part Data Engineer and part Data Visualization Expert. Leverage your expertise in building efficient ETL pipelines, querying complex naval data warehouses, and transforming raw metrics into actionable intelligence using tools like Tableau, Power BI, or Qlik.
The Role
- Design and maintain SQL-based ETL processes to ingest, clean, and transform large datasets
- Write complex SQL queries and stored procedures to extract data from Oracle or SQL server databases
- Utilize Python or R for advanced data wrangling and workflow automation
- Develop interactive, dynamic dashboards using Tableau, Power BI, or Qlik
- Conduct exploratory data analysis to identify trends and opportunities for improvement
What You'll Need
- 3+ years of experience with data analysis
- Proficiency in Tableau or Power BI
- Experience with Python (Pandas or NumPy) or R for data manipulation
- Strong SQL skills, including joins, window functions, and stored procedures
- Active Secret security clearance
What's On Offer
- Competitive salary range of $77,600 - $176,000
- Comprehensive benefits package including health, life, disability, and retirement
- Opportunities for professional development and tuition assistance
- Work-life programs and dependent care support
Key skills/competency
- Data Analysis
- ETL Processes
- SQL
- Data Visualization
- Tableau
- Power BI
- Python
- R
- Data Wrangling
- Security Clearance
How to Get Hired at Haystack
- Research Haystack's mission: Study their involvement in government initiatives, values, and recent projects to align your application.
- Tailor your resume: Customize your resume to highlight experience with SQL, ETL, data visualization tools like Tableau/Power BI, and any relevant security clearances.
- Showcase technical expertise: Be prepared to discuss your proficiency in Python/R for data manipulation and advanced SQL querying during technical interviews.
- Demonstrate problem-solving: Provide specific examples of how you've transformed raw data into actionable insights and improved data delivery processes.
- Understand government consulting: Familiarize yourself with the nuances of supporting critical government projects and the importance of security protocols.
Frequently Asked Questions
Find answers to common questions about this job opportunity
Explore similar opportunities that match your background