We are seeking a detail-oriented Data Analyst to collect, analyze, and interpret business data to support strategic decision-making. The ideal candidate will have strong analytical skills, experience with SQL, Excel, Power BI, and Python, and the ability to transform complex datasets into actionable insights. The role involves working closely with business stakeholders to identify trends, create dashboards, and improve operational efficiency.

---

Responsibilities

• Collect, clean, and analyze large datasets from multiple data sources.
• Develop and maintain interactive dashboards using Power BI and Tableau.
• Write complex SQL queries to extract and manipulate data.
• Perform statistical analysis to identify business trends and opportunities.
• Create reports and presentations for stakeholders.
• Collaborate with cross-functional teams to define reporting requirements.
• Build data models and validate data quality.
• Monitor KPIs and generate weekly/monthly performance reports.
• Identify process improvement opportunities through data analysis.
• Support ad hoc reporting requests from business teams.
• Document reporting processes and data definitions.
• Ensure data integrity and compliance with organizational standards.
• Participate in Agile ceremonies and project planning.
• Assist in automating manual reporting processes.

---

Required Skills

• SQL
• Microsoft Excel (Advanced)
• Power BI
• Tableau
• Python
• Pandas
• NumPy
• Data Visualization
• Data Cleaning
• ETL Concepts
• Data Modeling
• Statistics
• Business Intelligence
• Microsoft Office
• Jira
• Confluence
• Agile
• Problem Solving
• Analytical Thinking

---

Preferred Skills

• Snowflake
• Azure Data Factory
• AWS Redshift
• Google BigQuery
• Databricks
• Apache Spark
• SAS
• R Programming
• Machine Learning Fundamentals
• Looker

---

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Statistics, Mathematics, Data Science, or a related field.
• 3–6 years of experience as a Data Analyst or Business Intelligence Analyst.
• Strong knowledge of SQL and data visualization tools.
• Experience working with relational databases and cloud data platforms.
• Excellent communication and stakeholder management skills.

---

Certifications (Preferred)

• Microsoft Certified: Power BI Data Analyst Associate
• Google Data Analytics Professional Certificate
• Tableau Desktop Specialist
• AWS Certified Data Analytics – Specialty

 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.The pay rate for this position is $350000.00/Yearly.