Business Intelligence Developer

Weltman, Weinberg & Reis Co., LPA; Independence Township (OH); Hybrid; USD 68,000 - 85,000; Full time

Benefits offered by this job

PTO 16 days + 9 holidays

Medical, Rx, Dental, Vision

401(k)

Free parking

On-site Bistro To Go

Free onsite fitness center

Job summary

Weltman, Weinberg & Reis Co., LPA is seeking a Business Intelligence (BI) Developer to design, develop, test and implement enterprise BI reports and dashboards across multiple data sources. You will gather requirements, translate them into specifications, and deliver reliable analytics solutions for internal stakeholders.

Hybrid work arrangement after an initial 90‑day in‑office period; strong SQL/T‑SQL and Microsoft BI stack experience required.

Qualifications

• 5+ years in enterprise-scale reports and dashboards development.
• Experience with data warehouses and data modeling concepts.
• Proficient in Microsoft BI stack (Power BI, SSAS, SSRS, SSIS).

Responsibilities

• Participate in business analysis to gather reporting and dashboard requirements.
• Translate requirements into specifications for multi-source reports.
• Develop, test and implement reports/dashboards from data sources.
• Transition reports to Operations & Support teams and provide ongoing support.
• Provide technical assistance and cross-training to teammates.
• Apply best practices and repeatable processes for BI delivery.
• Maintain regular attendance as an essential function.

Skills

Enterprise reporting development

Data warehousing concepts

SQL & T-SQL

Stakeholder communication

Education

BA/BS in Computer Science or related field

Tools

Power BI

SSAS

SSRS

SSIS

Data modeling (dimensional/relational)

Job description

The Business Intelligence (BI) Developer is responsible for the design, development, implementation and support of mission‑critical enterprise Business Intelligence (BI) reports. Working with cross-functional teams, you will participate to gather and document reporting requirements to meet business needs. Using your skills and experience as a BI Report Developer, you will then use those requirements to design, develop, test and implement reports and dashboards that utilize the underlying data store(s)/ data warehouse(s) / data mart(s).

Hours:

Monday - Friday 8am - 5pm EST in office for the first 90 days and then hybrid schedule option

Responsibilities/Duties/Functions/Tasks:

• Participate in business analysis activities to gather required reporting and dashboard requirements
• Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources.
• Transition developed reports and dashboards to the Operations & Support team
• Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users
• Provide technical assistance and cross training to other team members
• Design and implement technology best practices, guidelines and repeatable processes
• Complete all required training applicable to this position
• Regular and predictable attendance is an essential function of this position

Qualifications:

• 5+ years’ experience developing and implementing enterprise-scale reports and dashboards, including :
  • Working with users in a requirements analysis role
  • Extensive experience with data warehouse implementations
  • Knowledge of logical and physical data modeling concepts (relational and dimensional)
• BA/BS in Computer Science or related field is preferable. Equivalent combination of experience, education and training will be considered
• 3+ years of experience and proficiency in RDBMS technology
• Experience in Microsoft BI stack with Power BI, SSAS, SSRS, SSIS
• Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)
• Experience with complex T-SQL
• Knowledge of Data Warehousing Methodology and best practices, Kimball preferred.
• Experience and familiarity with the following: MS Office Products, MS CRM, MS Project, MS Visio, MS PowerPoint, and MS Team Foundation Server (TFS).
• Ability to read, analyze and interpret technical documents. The ability to effectively present information to IT management, technical groups, and/or project teams.

Compensation and Benefits

• The expected pay range for this position is $67,770 - $84,713/year
• Paid Time Off (PTO) - 16 days annually +9 Company paid holidays
• Competitive benefits - Medical, Rx, Dental, Vision, 401(k), Parental Leave, Life and Disability Insurance and more. You can review our benefits at www.weltman.com/careers for more information.
• Promotional opportunities from within the Firm
• Employee Perks available from Verizon, Car Dealerships, Local Movie Theaters, Theme Parks, etc. Positive office environment with regularly scheduled parties, contests, and community support initiatives
• On site "Bistro To Go" vending and fresh foods available
• Free parking
• Free onsite fitness center for all employees

Physical and Mental Demands:

The physical and mental demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the empl oyee is regularly required to remain in a stationary position at a workstation. This position requires constant use of hands and fingers for typing and operating a computer and other office equipment. The employee must possess the ability to communicate information and ideas in writing and verbally. Occasional standing, walking, bending, and lifting of items weighing up to 15 pounds may be required. Close visual acuity is needed to read, analyze data, and view a computer terminal for extended periods.

This position operates in a professional office environment. It is representative of those an employee encounters while performing the essential functions of this job. The employee will experience low to moderate noise levels and moderate interruptions. The workspace is well-lit and climate controlled.

EEO Statement

Weltman is an equal opportunity employer.

#BizTech

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.