Junior SQL Analyst

Core responsibilities  

– Design and refine SQL queries (SELECT, JOIN, CTE, window functions) that retrieve actionable information from relational databases.  

– Build scheduled reports and interactive dashboards that translate metrics into compelling narratives for non-technical stakeholders.  

– Validate source data, reconcile discrepancies, and document lineage to safeguard integrity and compliance.  

– Support ETL pipelines by troubleshooting load failures, tuning indexes, and profiling tables for performance gains.  

– Partner with data engineers, product managers, and business leaders to scope analytical requests and iterate quickly.  

– Prototype ad-hoc analyses—sales trends, customer cohorts, A/B test results—and present findings in concise visual form.  

– Maintain metadata repositories and update data dictionaries so every column tells a clear story.  

– Continuously explore emerging SQL standards, cloud warehouses (Snowflake, BigQuery, Redshift), and BI tools to enhance your toolkit.  

Required qualifications  

– Bachelor’s degree in Information Systems, Computer Science, Mathematics, Finance, or related quantitative field.  

– Proficiency writing clean, readable SQL; comfortable with aggregations, subqueries, and set operations.  

– Familiarity with at least one relational engine such as PostgreSQL, MySQL, or SQL Server.  

– Solid grasp of data analysis fundamentals: descriptive statistics, data normalization, and anomaly detection.  

– Fluency in Excel or Google Sheets for rapid slicing and dice.  

– Articulate communication—able to explain technical findings to marketing, operations, and executive audiences alike.  

– Meticulous attention to detail; you question anomalies and verify results before hand-off.  

– Adaptability to work in a distributed, remote-first environment across multiple U.S. time zones.  

Preferred skills (nice-to-have)  

– Experience with BI platforms (Tableau, Power BI, Looker) or Python data libraries (Pandas, SQLAlchemy).  

– Knowledge of version control (Git), ticketing systems, and Agile rituals.  

– Exposure to cloud data ecosystems—AWS, Azure, or GCP—and corresponding security best practices.  

– Understanding of data governance frameworks and GDPR/CCPA considerations.  

Why this role stands out  

– Impact: Your insights guide product pivots, revenue forecasts, and customer experiences across multiple industries.  

– Learning velocity: Rotate through finance, marketing, and technology squads; absorb domain context while sharpening technical acumen.  

– Flexibility: Operate remotely, leveraging asynchronous collaboration tools that value output over location.