Power BI Report Developer/ETL Developer

RESOURCESOFT, INC.; Boston (MA); On-site; USD 120,000 - 160,000; Full time

Job summary

Resourcesoft, Inc. in Marlborough, MA, seeks a senior BI/ETL engineer to design and deliver enterprise analytics solutions. You will build interactive dashboards, optimize large data warehouses, and lead data transformations using dbt and SQL Server.

The role emphasizes collaboration with data engineers and presenting insights to executives, with a focus on scalable cloud architectures in AWS and Snowflake.

Qualifications

• 5+ years of experience in BI and data warehousing.
• Proficient in Power BI and Tableau for enterprise reports.
• Experience with Snowflake cloud platforms and large warehouses.
• Experience in AWS cloud infrastructure and data storage.
• Strong SQL Server programming and complex query development.
• Experience with dbt and ETL methodologies.
• Excellent verbal and written communication skills.

Responsibilities

• Architect and develop interactive data visualizations with Power BI and Tableau.
• Analyze production data warehouses to deliver enterprise solutions.
• Extract, transform, and load data using modern ETL pipelines and dbt.
• Query and manipulate complex relational databases using SQL Server.
• Design scalable cloud data architectures in AWS and Snowflake.
• Collaborate with data engineering teams to improve extraction processes.
• Present data-driven insights to executive management.

Skills

BI & data warehousing

Communication skills

Tools

Power BI

Tableau

Snowflake

AWS

SQL Server

dbt

ETL

Job description

Requirements

• 5 or more years of experience in business intelligence and data warehousing solutions.
• Proficiency in Power BI and Tableau for advanced enterprise report building.
• Experience with Snowflake cloud data platforms and large-scale production data warehouses.
• Experience in Amazon Web Services cloud infrastructure and data storage environments.
• Experience with SQL Server programming and complex query development for data analysis.
• Experience in executing data transformation models utilizing dbt and ETL methodologies.
• Excellent verbal and written communication skills to present analytical results to management.

Responsibilities

• Architect and develop interactive data visualizations and complex business reports utilizing Power BI and Tableau.
• Analyze massive datasets within production data warehouses to deliver actionable enterprise business solutions.
• Extract, transform, and load data utilizing modern ETL pipelines and dbt transformation techniques.
• Query and manipulate complex relational databases utilizing advanced SQL Server programming.
• Design and optimize scalable cloud data architectures operating within AWS and Snowflake environments.
• Collaborate cross‑functionally with data engineering teams to enhance enterprise data extraction processes.
• Present data‑driven insights and strategic technical results directly to executive management.

Founded in 1999, Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization. Headquartered in Marlborough, MA, the company serves the technology needs of its clients nationwide. Resourcesoft has often been recognized by prominent rating agencies for its exemplary growth and stability. With over two decades of industry experience, the Company has evolved as a front runner in enabling project optimization. We partner with leading organizations to provide technology solutions within the financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We take pride in mentoring a workforce that is well positioned to respond to the emerging IT trends and needs. With the employees at the crux of every business endeavor, our success is driven by our expertise in pairing the right talent with the best jobs in the technology sector. We forge long term, personalized relationships with our employees to advance their career to the next level. We engage them in technology centric client projects that provide opportunities for them to evolve, innovate and deliver world class products and services. Our career opportunities offer challenging assignments and exposure to emerging and cutting edge technologies. We are committed to providing our employees with the tools necessary to accelerate their career progression, while maintaining a healthy, work-life balance. We are deeply committed to providing a workplace ambience that is both challenging and fulfilling.

Resourcesoft is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

For more information about Resourcesoft and our services, please visit our website.