Job summary
Job post source
This job is directly from City of Redmond, WA
Job overview
The Power BI - Business Analyst role at City of Redmond involves developing and managing Power BI reports and dashboards to support financial and operational reporting, impacting data-driven decision-making within the city government.
Responsibilities and impact
The candidate will design and maintain Power BI reports, manage Power BI services, collaborate with stakeholders to gather requirements, integrate data from various sources, ensure data quality and security, provide user training, and manage projects to deliver solutions on time and within budget.
Compensation and benefits
The position offers competitive wages with a comprehensive benefits package including fully paid medical insurance, prescription, dental, vision, life and disability insurance, flexible spending accounts, paid vacation and holidays, employee assistance program, retirement plans, annual cost of living adjustments, and merit increases up to 5%.
Experience and skills
Required qualifications include experience with Power BI report development and administration, financial reporting, SQL Server programming, Azure services, ETL processes, strong project management, and communication skills; public sector experience and certifications like Microsoft Power BI and PMP are preferred.
Work environment and culture
The City of Redmond promotes a diverse and inclusive culture with collaboration across technical and non-technical teams, emphasizing consensus-building and effective communication in a public sector environment.
Company information
City of Redmond is a culturally diverse community with over 80,000 residents, known for its commerce in technology, aerospace, gaming, biomedical, and innovation start-ups.
Job location and travel
The job is located in Redmond, WA, with no specific mention of remote work or travel requirements.
Application process
Applicants will be notified of their status, with top candidates invited to testing or interviews; offers are contingent on background and reference checks, and new hires relocating must establish Washington State residency within 30 days.
Unique job features
The role uniquely involves working with public sector data and integrating multiple Azure data services and SQL Server technologies to support city financial and operational reporting.
Company overview
The City of Redmond, WA, is a municipal government organization responsible for providing essential services such as public safety, infrastructure maintenance, and community development to its residents. It generates revenue through property taxes, utility fees, and state and federal grants. Historically, Redmond is known as the headquarters of tech giants like Microsoft and Nintendo of America, contributing to its growth and economic development. The city emphasizes sustainable urban planning and community engagement, making it a dynamic place to work and live.
How to land this job
Position your resume to highlight your expertise in developing and managing Power BI reports, dashboards, and administration, emphasizing your skills in financial reporting and SQL Server programming as outlined in the job description.
Focus on showcasing your experience with Azure services such as Data Factory and Synapse Analytics, and your ability to integrate data from multiple sources, which are critical for this role.
Apply through the City of Redmond's official careers page and also submit your application on LinkedIn and other job boards where the position is posted to maximize exposure.
Connect with current employees in the City of Redmond’s IT or finance divisions on LinkedIn; start conversations with ice breakers like commenting on recent city projects involving data analytics or asking about how Power BI is used to support financial transparency in the city.
Optimize your resume for ATS by including keywords such as 'Power BI administration,' 'financial reporting,' 'SQL Server,' 'Azure Data Factory,' 'data modeling,' and 'project management' to ensure your resume passes initial automated screenings.
Use Jennie Johnson’s Power Apply feature to automate tailored resume customization, multi-channel applications, and LinkedIn networking, allowing you to focus your energy on preparing for interviews and building relevant skills.
Jennie Johnson works for you!
Here’s what we do to make sure you’re successful:
Targeted Resume Revamp:
We expertly craft your resume to navigate Applicant Tracking Systems (ATS) and showcase your qualifications, making you stand out as a top-tier candidate.
Job Description Dissection:
Unpack the job posting with expert analysis, ensuring your application hits every key requirement.
Bespoke Cover Letter:
Capture the attention of hiring managers with a personalized cover letter that highlights how your skills align perfectly with the job's needs.
Interview Mastery:
Prepare for interviews like a pro with likely questions, strategic answers, and insightful questions for you to ask, setting you apart as an informed candidate.
Direct Application Insights:
Receive tailored advice on the best places to apply, ensuring your applications are seen by the right employers.
Skills and Gaps Assessment:
Identify and close critical skills gaps to position yourself as the best-fit candidate for your ideal job.
Personalized Email Pitch:
Make a memorable first impression with an email template crafted to engage potential employers and initiate meaningful conversations.
In-depth Research Guide:
Leverage comprehensive research tools to gather effective insights on companies, industry trends, and role-specific challenges.
Detailed Company Analysis:
Gain in-depth understanding of your prospective employer, giving you the edge in applications and interviews.
Strategic Candidate Overview:
Understand your unique value and why companies would want to interview you, highlighting your background and positioning.