Junior Reporting Analyst

Description

MG2 is seeking a talented Junior Reporting Analyst to join our Seattle office on our Program Management Organization (PMO) team!

At MG2, we value our employees with great benefits and worthwhile programs. We are proud of the many initiatives at MG2 such as our focus on Sustainability, our passion for Equity, Diversity & Inclusion, and our fifty-year anniversary celebration. We promote MG2 culture firmwide and within each of our offices through monthly recognition, happy hours, summer events, and an end of year Holiday Party to celebrate our accomplishments. People make the place at MG2 – Join our growing firm today! 

Role Introduction

The Junior Reporting Analyst supports all data and reporting development and related activities for delivery of 

professional services. This role will work closely with the reporting and analytics manager to collect, analyze, 

and present data insights that inform stakeholder decision-making. This role will partner with the solutions 

development team, market business partners and report developers in vetting requirements and proposing 

improvements to all reporting solutions and services that support the professional practice and program 

development teams.  

What your day will look like:

• Develops a strong working knowledge of data sources, internal and external reporting needs. 
• Creates and maintains databases and data systems, ensuring data accuracy and integrity. 
• Develops and maintains reporting tools, change requests, and iterations. 
• Coordinates with the development team on report testing, data validation and release to stakeholders. 
• Works closely with program manager – reporting and analytics, reporting developers and stakeholders, to understand data requirements and deliver actionable insights. 
• Owns the data dictionary and maintenance. 
• Supports evaluation and execution of improvement opportunities. 
• Drafts clear and well-structured business requirements and documentation. 
• Creates reports, dashboards and visualizations within expected project timelines. 
• Reviews and validates requirements with relevant collaborators, ensuring business needs are met. 
• Ensures input from all stakeholders before any build, release or implementation of reports. 
• Collects and compiles data from various sources, ensuring data accuracy and completeness. 
• Performs data cleaning and transformation as necessary to prepare it for analysis. 
• Conducts analysis and validation of report outputs and data sets. 
• Summarizes reporting issues and recommends improvements in clear and concise reports. 
• Prepares regular and ad-hoc reports, ensuring deliverables are accurate and delivered on time. 
• Clearly communicates findings, recommendations and requirements to both technical and non-technical 
• diences. 
• Helps maintain data quality standards by identifying and resolving data discrepancies or inconsistencies. 
• Collaborates with other team members to establish data quality protocols and document business rules. 
• Stays up to date with industry trends and best practices in data analysis. Continuously expands knowledge and skills in data analytics techniques and tools. 

Requirements

We're looking for someone who:

• Bachelor's degree in computer science, data science, information technology or a related field 
• 4-5 years business / reporting analysis experience 
• 2-3 years hands-on experience working with data and reports 
• Proficiency in data analysis tools and programming languages such as Excel, SQL, Python, Power BI 
• Preferred experience in the AEC industry 

MG2 Benefits & Salary

MG2 offers competitive benefits that support our employees in their life and career. This position is eligible for company benefits including but not limited to:

• Employer provided employee healthcare plan and reduced cost premium plans, life insurance, and short and long-term disability coverage
• Paid Time Off, 9 paid Holidays, and an additional Floating Holiday
• Employer sponsored Family Planning Program and employer Paid Parental Leave
• Learning & Career Development opportunities
• Employee Wellness and Employee Assistance Program
• Participation in a 401K program including eligible company match percentage, after waiting period

…and many other additional voluntary benefits!

National Salary Range: $72,200 - $115,000

Please note that this role is a salaried and exempt position, and therefore, is not eligible for overtime pay.

If position is eligible for remote status, ranges may be adjusted. Acknowledging the time employees typically spend in the role, compensation is dependent on applicable years of experience and skillset. 

About MG2

Continually recognized as one of the “Best 100 Companies to Work For” by Business Magazine, MG2 has been delivering award-winning projects for over 50 years. We partner with some of the world’s most recognizable companies and brands to bring exceptional design solutions to life through full architectural, strategic planning, interior design, brand strategy, and program consulting services. At MG2 our greatest strength lies in our people, our partnerships, and our commitment to helping them succeed. We seek world-class talent to deliver integrated, tailored solutions that advance our clients’ enterprise and provide our staff with outstanding career growth experiences that elevate these opportunities.

MG2 whole-heartedly embraces diversity, actively seek out Diverse talent that enrichens our work and our culture. Our differences, unique perspectives, and elevation of every voice and idea not only makes us stronger but are absolutely essential to designing and building truly inclusive and equitable experiences and spaces for everyone.

Candidates will be required to undergo a standard employment background check upon hire.

No specified closing date; applications accepted until position is filled

Colorado Residents: We may redact information that identifies your age, date of birth, or dates of school attendance or graduation.