Power Role BI Developer

Boston, Massachusetts, United States | Marchon Partners | Contract | Partially remote

  1. Power Role BI 

Client: Commonwealth Financial

Location: Boston (local candidate preferred) (Marchon)

Work auth: Any

Length 12+ months



We are seeking a talented Power BI Lead Developer to lead the effort of utilizing Power BI as well as other tools such as SSAS, AAS and data flows to design, build and maintain BI models and solutions. The Power BI Lead Developer will work closely with Project Managers and Technical Leads, as well as agency leads, project leads to drive project planning and execution of complex enterprise software development projects within set project targets and deadlines.

Primary Responsibilities
• Design, build, deploy and maintain BI solutions on Power BI
• Assist with building Data Analytics enterprise models using the Microsoft technologies including Power BI, SSAS, AAS and data flows
• Collaborate with the BI Team to design and implement schemas which efficiently and accurately render data through Power BI
• Provide technical guidance to junior developers
• Assist with the design and development of cubes and metadata using best practices
• Able to diagnose report issues and performance tune reports and dashboards
• Design, implement, and support a platform providing ad-hoc access to large datasets
• Collaborate with team to integrate new data sources
• Analyze business needs into technical specifications
• Strong working experience with data warehouse
• Strong working experience with relational database
• Strong working experience with data lake reporting layers
• Evaluate and improve existing BI infrastructures
• Conducting trouble shootings on BI solutions

• Bachelor's degree in Accounting Info Systems, Computer Science or Information Technology, or equivalent work experience preferred
• 2-4 years in developing Power BI reports, dashboards, KPIs, and scorecards.
• 2-4 years development experience in Data Analytics technologies such as Microsoft Power BI 
• Experience with Microsoft Azure platform a plus
• Intermediate to Expert understanding of Power BI
• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• Background in data mining and data warehouse design (e.g. dimensional modeling)
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Strong organizational skills required
• Team oriented with an ability to also work independently, with minimal guidance
• Strong attention to detail
• Professional written and oral communication skills