Lead BI & Data Platform Engineer

PostcardMania

$110K — $130K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of experience in SQL Server development or business intelligence
  • Expert-level skills in SQL Server, database design, and performance tuning
  • Advanced proficiency in Power BI for data modeling and report development
  • Strong background in designing enterprise data warehouses
  • Experience with ETL/ELT process development and maintenance
  • Deep knowledge of SQL and relational database design
  • Exceptional analytical skills and problem-solving capabilities

Responsibilities

  • Design and maintain the SQL Server data warehouse and reporting infrastructure
  • Architect and manage SQL Server replication for analytics
  • Own and optimize Power BI dashboards and semantic models
  • Implement scalable relational data models
  • Develop and improve ETL/ELT processes for data integration
  • Monitor and enhance SQL Server performance and health
  • Establish data governance standards and reporting best practices
  • Collaborate with various departments to define analytics requirements

Benefits

  • Medical, Dental, Vision & Life Insurance
  • 401(k) plan with disability and critical illness coverage
  • Accrued paid vacation increasing with tenure
  • Six paid holidays throughout the year
  • Free on-site yoga sessions twice weekly
  • Monthly chiropractic visits at no cost
Full Job Description
Job Description
Join Our Team as a Lead BI & Data Platform Engineer!

Your Mission

PostcardMania is seeking a highly skilled and driven Lead BI & Data Platform Engineer to take ownership of our enterprise reporting, SQL Server data platform, and Power BI analytics environment.

This is a senior, hands-on technical leadership role responsible for designing, building, and optimizing our SQL Server data warehouse infrastructure, replication architecture, and business intelligence solutions. You will serve as the company's subject matter expert for SQL Server, data architecture, and Power BI while partnering with leadership and departments across the organization to deliver accurate, scalable, and actionable data.

This position is ideal for someone who enjoys solving complex data challenges, improving performance, and building a modern analytics platform that supports the company's continued growth.

Schedule

This is a full-time position, either in-office or remote, Monday through Friday from 8:00 AM to 5:00 PM.

Your Responsibilities
  • Design, build, and maintain the company's SQL Server data warehouse environment and reporting infrastructure.
  • Architect and manage SQL Server replication to support reporting and analytics.
  • Own and optimize all company Power BI dashboards, reports, and semantic models.
  • Design and implement scalable relational data models.
  • Develop, maintain, and improve ETL/ELT processes for integrating data across multiple systems.
  • Monitor and tune SQL Server performance, indexing, query execution, and database health.
  • Establish data governance standards and reporting best practices.
  • Partner with Sales, Marketing, Finance, Operations, and Leadership to define analytics needs.
  • Translate business requirements into efficient technical solutions.
  • Continuously improve the performance, accuracy, and reliability of reporting systems.


Requirements
  • 5+ years of experience in SQL Server development, business intelligence, or data platform engineering
  • Expert-level SQL Server expertise, including database design, query optimization, indexing, replication, and performance tuning
  • Advanced Power BI expertise, including data modeling, DAX, semantic models, report development, and performance optimization
  • Strong experience designing and maintaining enterprise data warehouses
  • Experience building and supporting ETL/ELT processes
  • Deep understanding of SQL and relational database design
  • Strong analytical and problem-solving abilities
  • Ability to communicate technical concepts clearly to non-technical stakeholders
  • Self-starter who thrives with ownership and autonomy


Benefits
  • Medical, Dental, Vision & Life Insurance
  • 401(k), Short- and Long-Term Disability, Accident & Critical Illness coverage
  • Paid vacation that increases with tenure
  • Six paid holidays (New Year's Day, Memorial Day, Independence Day, Labor Day, Thanksgiving, and Christmas)
  • Free on-site yoga twice a week
  • Free monthly visits to a local chiropractor, plus much more!

Similar Jobs

More Jobs at PostcardMania

More Information Technology Jobs

Find similar Lead BI & Data Platform Engineer jobs: