What are the responsibilities and job description for the Junior Data Analyst position at Lucid Consulting Group?
Lucid Consulting was established to offer a curated community of on-demand experts with broad professional skills and experience. We are a people-focused, customer-driven consulting firm that helps organizations drive growth, adapt to change, and create value. Our deep technical, financial, and marketing capabilities help to deliver transformative solutions and consulting capabilities for a broad list of clients.
We put your skills and expertise to work by pairing you with high-impact projects at highly competitive rates.
Job Title: Junior Data Analyst 2 - 152412-1
Location: Onsite, 5 days a week (flexible if needed) Redmond, WA
Duration/Start Date: 4/28/2025 - 6/30/2025
Salary Range: $49.76- $54.74/hourly
Candidates with previous experience working at Microsoft Corporation, either as a full-time employee (FTE) or contractor, are strongly preferred.
Summary:
The main function of a Data Analyst is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems.
Job Responsibilities:
Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies
Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions
Design, implement, automate and maintain large scale enterprise data ETL processes
Modify existing databases and database management systems and/or direct programmers and analysts to make changes
Test programs or databases, correct errors and make necessary modifications
The purpose of this team is focused on azure security for Microsoft products..
Key projects: This role will contribute to building dashboards in Power BI, insights into how customers are using the products, and generate and analyze reports.
Typical task breakdown and operating rhythm: The role will consist of 20% meetings, 50% data analysis investigations, and 30% reporting/dashboard generation .
This role provides the opportunity to be on a team that is in the heart of the business in terms of security which has the highest visibility aside from copilot.
Candidate Requirements
Years of Experience Required: 2-4 overall years of experience in the field.
Degrees or certifications required: Engineering/Data Scientist degree is required to be eligible for this role.
Disqualifiers: Candidates with constant job hopping, low tenure, lack of experience with large companies will not be eligible for the role.
Best vs. Average: The ideal resume would be able to build dashboards, help drive conclusions, and pull and drive analytics on data.
Performance Indicators: Performance will be assessed based on quality of work, meeting deadlines, and ensuring to stick to completion dates.
Top 3 Hard Skills Required Years of Experience
1. Minimum 2 years experience with Azure Data Factory.
2. Minimum 2 years experience with SQL.
3. Minimum 2 years experience with Power BI.
Skills:
Experience with database technologies
Knowledge of the ETL process
Knowledge of at least one scripting language
Strong written and oral communication skills
Strong troubleshooting and problem solving skills
Demonstrated history of success
Desire to be working with data and helping businesses make better data driven decisions
Education/Experience:
Bachelor's degree in a technical field such as computer science, computer engineering or related field required
2-4 years applicable experience required
NOTE: We seek applicants with prior experience as contractors or full-time employees (FTE) at Microsoft Corporation. Additionally, we welcome applications for entry-level or junior consultant roles, as well as from individuals with a strong industry background aligned with the listed requirements.
This opportunity is open to individuals authorized to work in the United States. Unfortunately, visa sponsorship and C2C opportunities are not available at this time.
Salary : $95,000 - $105,000