Match score not available

Contractor, Business Intelligence (BI) Developer - US Based Only

Remote:

Full Remote

Contract:

Freelance

Salary:

144 - 192K yearly

Experience:

Expert & Leadership (>10 years)

Work from:

Panama, California (USA), Pennsylvania (USA), United States

Offer summary

Qualifications:

Advanced experience in Power BI or Looker, Expertise in data transformation and modeling with dbt and SQL, Proven track record of implementing role-based data access, Ability to interpret complex data requirements, Strong project management and communication skills.

Key responsabilities:

Transform and enhance internal data infrastructure
Expand and optimize data tables and dashboards
Develop data models for client project profitability
Implement row-level security in Power BI
Collaborate with the BI lead and operations team

Seer Interactive Marketing & Advertising SME https://linktr.ee/

201 - 500 Employees

See more Seer Interactive offers

Job description

Seer Interactive is a digital marketing consultancy that harnesses compassion, data, and technology to make a mark on our communities - our coworkers, our clients, our industry, and our neighbors. We believe in relentlessly pursuing (and sharing) the truth – bringing together millions of data points from quantitative and qualitative sources to base our decisions on. Our purpose is to unlock potential for our communities mentioned above. Our vision is a world where it’s easy to do the right thing throughout those communities. If you’re ready to uplift others, challenge your ego, commit to the truth, and be better than yesterday – keep reading.

Seer is a remote first agency and Certified B-Corp with team members working across the country. If an office environment is more your style, this position can also sit in Philadelphia or San Diego. We can only consider candidates based in the US who are able to work continental US based hours.

Application Limit: Maximum of 100 Applications

We know that applying for new opportunities takes time, so to ensure we are able to give each candidate the thoughtful review they deserve we will be accepting applications until we reach 100 submissions.

**PLEASE NOTE** This is a contractor role. We will need someone for approximately 10-15 hours per week. That being said, there is potential for this position to convert to full-time someday, if the BI need is there.

The Role: As a Business Intelligence (BI) Developer, you will play a crucial role in transforming and enhancing our internal data infrastructure and reporting dashboards. Leveraging your expertise in data modeling and report development you will support Seer’s Leadership Team and account teams by expanding and optimizing data tables and dashboards. You will work closely with the BI Lead and our Operations Team, ensuring the dashboards provide insightful, granular data and secure, role-based access to stakeholders.

This contractor role requires an experienced BI Developer who can work autonomously, translating complex data needs into actionable, clear reporting. Hours are estimated at 10-15 per week, with flexibility based on project timelines.

Role Highlights

Below are some potential projects you will work on and the associated tasks related to those projects

Client Project Profitability:

Work with project management data from Wrike in our data warehouse to develop a data model that allows reporting project efficiency based on actual to budgeted time and revenue for client projects

Work with established data tables in dbt, develop new tables and models based off those tables and create new models that can be leveraged in new Power BI or Looker dashboards

Improve infrastructure of existing data models

Team Capacity Reporting:

Transform and optimize data models in dbt to include both client and non-client (internal) projects, providing a comprehensive view of our operational capacity

Incorporate task and deliverable-level reporting in Power BI, enhancing the ability to drill down and analyze data at a more granular level

Design, document, and implement model transformations that align with broader capacity management goals, ensuring the models remain efficient and scalable

Expand Power BI dashboards with advanced filtering and drill-down capabilities, allowing stakeholders to toggle between high-level and detailed views

Power BI to Looker Migration:

Collaborate with BI Lead on strategy for migration

Migrate some data sources to Google BigQuery in order to begin the migration process from Power BI to Looker for some dashboards

Data Security & Access Control:

Implement row-level security (RLS) in Power BI to ensure secure, role-based data access, protecting sensitive project data and individual performance metrics

Validate RLS configuration and document the framework for future maintenance, ensuring that only authorized personnel have access to appropriate data sections

Collaboration & Communication:

Participate in weekly check-ins with the BI lead to discuss progress, blockers, and potential optimization opportunities

Proactively communicate through Slack and other tools, providing regular updates and insights

Essential Skills

Advanced experience in Power BI or Looker, with a strong ability to develop and enhance data models and visualizations

Expertise in data transformation and modeling with dbt and SQL

Proven track record of implementing role-based data access, particularly using Power BI or Looker row-level security

Ability to interpret complex data requirements and deliver actionable, efficient reporting solutions

Able to investigate existing data models and reports to understand how they were built, create documentation for them and improve upon them if possible

Strong project management and communication skills and the ability to work independently while keeping stakeholders informed and involved

Attention to detail when it comes to documenting work on data models for shared use and reproduction

This might not be the right role for you if

You’ve never worked with any of the following tools: Power BI, Looker, dbt, SQL, BigQuery

You don’t have experience collaborating with stakeholders to decipher project requirements and outline a scope for a project

Regular updates and feedback are essential for the successful completion of your tasks

Compensation

$75-$100/hr. Your final offered compensation will be determined by your skills and experience

Have questions about recruitment at Seer? Check out our Custom GPT: Guide to Talent Acquisition at Seer to drop in your questions! You can ask it anything about our hiring process, and how to best prepare for an interview with us.

As a B-Corp Certified organization, we are committed to creating an inclusive environment and are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Not ready to apply but want to keep in touch? Stay connected via our monthly Career Update newsletter! We'll share curated content on Seer, open roles, industry insights, career advice, events you don't want to miss, and more (so you never miss a beat).

#LI-Remote