Job ID: JOB_ID_6180
Position Overview:
The Executive Office of Education is embarking on several new data warehouse initiatives and requires a Senior BI Consultant to aid in their implementation. This role will focus on providing expertise in data visualization and graphical report design to create and develop reporting solutions within Microsoft Power BI, aligned with business requirements.
The successful candidate will collaborate with other members of the Data Engineering and Analytics team to develop new reports, maintain existing ones, and resolve technical and data-related issues for analytics users. A strong analytical orientation and the ability to work effectively within a small team are essential.
We are looking for a talented Power BI Developer to spearhead the utilization of Power BI and other tools like SSAS, AAS, and data flows for designing, building, and maintaining BI models and solutions. This role involves close collaboration with Project Managers, Technical Leads, and agency leads to drive the planning and execution of complex enterprise software development projects, ensuring adherence to project targets and deadlines.
Key Responsibilities:
- Migrate existing SSRS reports to Power BI Report Server.
- Design and develop reporting solutions in Microsoft Power BI based on business requirements.
- Provide expertise in data visualization and graphical report design.
- Actively participate in upgrade and migration projects from legacy systems to Power BI.
- Define and implement Power BI development best practices.
- Work closely with Product Owners and data development teams to drive requirements to completion.
- Collaborate with Power BI report users to tune and optimize Power BI reports and dashboards.
- Maintain and support existing business intelligence solutions.
- Stay current with industry standards, best practices, and upcoming product releases, with a focus on MS Azure solutions.
- Mentor other developers in effectively utilizing the tools.
- Develop and oversee monitoring systems to measure usage and ensure operational stability.
- Identify and drive innovation within the Power BI space.
- Create and maintain documentation supporting the full software development lifecycle.
- Evaluate business requirements and processes to propose solutions and provide accurate estimates for development efforts.
- Assist in building Data Analytics enterprise models using Microsoft technologies including Power BI, SSAS, AAS, and data flows.
- Assist with the design and development of cubes and metadata using best practices.
- Design, implement, and support a platform for ad-hoc access to large datasets.
- Demonstrate strong working experience with data lake reporting layers.
Minimum Qualifications:
- Bachelor’s degree or at least 3 years of related experience in a technical environment.
- 5 years of experience creating complex reports, dashboard applications, and scorecards.
- 5 years of advanced experience with MS Power BI connection types, including ODI.
- 5 years of experience with SQL, with a proven ability to write efficient queries.
- 2 years of experience with other BI Tools, including Cognos.
- Experience writing reports over various data sources, including Oracle and SQL Server databases.
- Strong problem-solving and data analysis skills.
- Excellent verbal and written communication skills, with the ability to concisely and effectively communicate across teams.
- Solid understanding of data modeling concepts.
- Experience in creating SSAS tabular models.
- Ability to manage and prioritize multiple requests.
- Ability to follow processes and execute project deliverables in a timely manner.
- Proven ability and desire to grow technical skill set.
- Demonstrated ability to work independently with limited supervision.
- A strong work ethic, demonstrated attention to detail, and excellent time-management skills.
- Extremely responsive, with a strong sense of urgency.
- Experience connecting to and transforming data in Power BI.
- Experience producing Power BI data models and recommending best practices for the creation of reports and graphics/visualizations.
- Hands-on experience with enterprise business intelligence solution data modeling, data mart, and data warehouse architecture.
- Knowledge of SQL queries, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
- In-depth understanding of database management systems, online analytical processing (OLAP), and ETL (Extract, transform, load) frameworks.
Preferred/Recommended Qualifications:
- Experience working with various Cloud technologies.
- Experience with Agile development and/or fact/dimensions and star schema models.
- Team player – friendly, communicative, open, honest, thoughtful, and committed.
- Must work cooperatively with others, sharing ideas and collaborating, and ultimately putting team goals first.
- Power BI certification is an added advantage.
Special Requirements
Must be Local
Compensation & Location
Salary: $80,000 – $120,000 per year
Location: Everett, MA
Recruiter / Company – Contact Information
Recruiter / Employer: Executive Office of Education
Email: ju0002365@gmail.com
Recruiter Notice:
To remove this job posting, please send an email from
ju0002365@gmail.com with the subject:
DELETE_JOB_ID_6180