Data Analyst - 99% Remote
1872 Consultingover 1 year ago
Chicago, Illinois, United States
Hybrid
Full-time
Junior Level (1-3 years)
Job Description
Position Overview
We are seeking a Data Analyst to join our team. This role is 99% Remote with occasional days onsite in Chicago. You will work alongside data engineers, BI Developers, and other data enthusiasts to power data-driven decisions for the business. Your responsibilities will range from structuring data and working heavily with SQL to building data pipelines and ensuring data quality. You will also interact with various teams to understand business requirements and provide effective solutions.
Key Responsibilities
- Synthesize and interpret data into a narrative of business performance and actionable insights.
- Design, build, prototype, and deploy data analysis frameworks.
- Translate business needs into technical specifications.
- Conduct and support whiteboarding sessions, workshops, design sessions, and project meetings as needed.
- Research and develop new algorithms and statistical techniques based on customer needs.
- Collaborate with business analysts, application architects, and developers to build data transactions and warehousing systems.
- Structure large data sets to extract usable information.
- Work with a team of analysts to process information.
- Engage with executives and business leaders to identify opportunities for improvement.
- Make effective and decisive decisions when presented with multiple project options.
Required Qualifications
- 2+ years of experience in Data Analysis.
- Strong SQL experience.
- Proficiency with table structures, stored procedures, functions, views, and select/insert/update queries.
- Experience in data mining, data transformation, and data cleansing.
- Ideally, experience with Azure SQL.
- Experience working with business users and IT team members to gather and document data project requirements.
Preferred Qualifications
- Hands-on experience with Azure data services.
- Experience building data pipelines with Python or Spark.
- Experience with BI or reporting tools, particularly Power BI.
Required Skills
Data Analysis
Spark
Azure SQL
Power BI
Data Pipelines
Python
Data Mining
Data Cleansing
BI Reporting
SQL