If you’re looking for a high-energy, inclusive atmosphere and a company that understands the importance of work/life balance, Commonwealth is your match! From generous bonus and 401(k) programs to tuition reimbursement and flexible work schedules, Commonwealth is focused on helping its employees thrive in an environment suited to their needs. On top of all that, the Data & Analytics department offers a hybrid work schedule, so you’ll be able to work from home for part of the week!

We’re looking for a senior power BI developer to join our ranks. This experienced senior Power BI developer will help lead development of Power BI semantic models and reports that will drive business users toward making data-driven decisions. The developer will work with business users to understand their data needs, prototype them using SQL and/or BI tools, collaborate with IT partners to build and implement, and validate the results.

The successful candidate will be highly motivated and eager to drive for results. They will possess both business and technical data knowledge to translate between business needs and technical solutions.

Key Responsibilities

• Working collaboratively with colleagues in the Data & Analytics team, business users, and IT to understand data needs and data governance decisions, and build out self-service reporting environment
• Profiling data by examining data structures, identifying data anomalies, and analyzing column properties
• Designing and optimizing SQL views and stored procedures to ensure data is both accessible, reliable and consistent
• Developing and maintaining complex semantic models  
• Leveraging DAX to build complex measures
• Optimizing the model’s performance
• Building interactive Power BI reports and dashboards that transform complex data into visual storytelling that’s easy for users to understand and use
• Analyzing the data by enhancing reports to expose insights and performing advanced analysis
• Collaborating closely with database administrators and Power BI service administrators on RLS, OLS, capacity management, and implementing newly released functionality

Core Strengths and Skills

• Bachelor’s degree required 
• 5+ years of experience preferably in financial services/insurance industry
• Strong proficiency in data models, databases, data warehouses, and complex data querying
• Strong proficiency in SQL, Power Query and DAX
• Solid understanding of modern data architecture methods, especially cloud-based and those that support large data sets.  Experience with Microsoft Azure, Snowflake and/or Databricks is a plus. 
• Strong proficiency in business insights/business intelligence 
• Strong proficiency in data visualization techniques and concepts, including experience with tools like Looker, Tableau, Power BI etc.
• Demonstrated success working cross-functionally to deliver business insights
• Strong ability to communicate business and technical information to people of various backgrounds 
• Strong interpersonal and communication skills. Ability to influence without authority.
• Great analytical and problem-solving skills 
• Strong initiative, work ethic, ambition, to drive for results and operate with ambiguity

Have we piqued your curiosity? Can you see yourself thriving in this opportunity? 

Picture Yourself Here 

At Commonwealth, we believe in a better world. We hold ourselves and each other to higher standards. We take care of one another. That’s why we invest in you—we encourage employee growth both in your career and education; we are building out a robust diversity, equity, and inclusion program; we offer incredible health care benefits; and we find plenty of occasions to celebrate. What’s not to love? 

We are always striving to be better, and we are looking for employees who share that same mindset. Better people, better coworkers, better leaders, better creators. Bring your best work and your full self to the table, and we will do the same. Together, we can build a better future for our advisors, their clients, our company, and you. 

About Commonwealth 

Commonwealth Financial Network, Member FINRA/SIPC, a Registered Investment Adviser, provides a suite of business solutions that empowers more than 2,000 independent financial advisors nationwide. Privately held since 1979, the firm has headquarters in Waltham, Massachusetts; San Diego, California and a new office opening soon in greater Cincinnati, Ohio. 

Turning our advisors into raving fans starts by doing the same for our employees. We foster an environment of excellence, growth, rewards, and fun in equal measure, which has earned us 44 Best Place to Work awards.   

The Fine Print 

We care about your online safety as a prospective employee and encourage you to exercise caution when responding to job postings online. Commonwealth will never ask potential hiring candidates to pay or transfer funds as a precondition of interviews or employment, nor will we authorize recruiters or agents to do so on our behalf. 

Commonwealth is an equal opportunity employer, making intentional efforts to source talent from all backgrounds.