This position is hybrid, based in Plantation FL at the SCI Direct Corporate office.

At SCI Direct, we believe that Family Is Everything. Come join a certified Great Place to Work with a business casual environment, an opportunity to have a hybrid work schedule, 401k with 6% company match, Adoption Assistance, and more!

The Business Support Analyst will perform general analytics and statistical modeling on existing data sets in various areas of the business. The primary goal of this position is to identify data patterns and trends to help answer business questions and improve decision-making. This includes performing complex data research and analysis to support business by creating data mining architectures/models/protocols, statistical reporting, and data analysis methodologies to identify trends in large data sets.

JOB RESPONSIBILITIES

• Responsibilities for BI Report Developer
• Understanding business requirements and develop Power BI dashboards or reports.
• Develop SQL queries to drive Metrics and aggregation for dashboards and reports.
• Develop and maintain SSRS complex Reports.
• Explore new features of Power BI and try to incorporate those into the project use case.
• Work independently under the guidance of a Technical Lead/Project manager.
• Collaborate with other team members in creating optimal, maintainable, and scalable Architecture.
• Demonstrate an accurate and complete understanding of the project scope.
• Support the existing BI application to maintain data and system integrity.
• Write complex data joins to establish data measures across multiple tables.
• Modify existing reports and/or develop new reports by analyzing databases, data sources, and structures for the benefit of Users. Perform QA analysis on reports for accuracy and reports meets the intended business needs.

MINIMUM Requirements

Education

• Bachelors in Information technology, or related, field. Master’s degree in Information Technology, or related field, preferred.
• 4 years of experience working with Power BI and SQL.
• Hands-on experience in Developing Key Dashboards, Reports, and Documents.
• Worked on complex Metrics Creation, Filters, and Prompts.
• Writing and Updating complex SQL / Queries.

Certification/License

• Certification on Power Bi / SSRS would be a plus.
• Microsoft Certified Power BI Data Analyst Associate preferred.

Experience

• Creating and managing Power BI semantic models, dashboards, and reports.
• Data visualization and advance calculations (Aggregate, Date, Logical, String, Table) using Power BI.
• Connecting Microsoft Power BI to SQL Server data sources.
• Creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Ribbons, Heat Maps, etc.
• Creating DAX expressions.
• Generating Drill through and Drill down reports with drop down menu option, sorting data, and defining subtotals in Power BI.
• Transact SQL with SQL Server 2014 or above.

Work CONDITIONS

When considering the work hours associated with this job, the following factors may apply:

Work Environment

• Work indoors during all seasons and weather conditions
• Comply with corporate dress code policy.

Work Postures

• Frequent, continuous periods of time standing, up 6 hours per day
• Sitting continuously for many hours per day, up to 6 hours per day
• Climbing stairs to access buildings frequently

Physical Demands

• Physical effort requiring manual dexterity is required, includes paperwork, calculators, computers and phone usage
• 20% of time lifting of boxes, laptops, etc.

Work Hours

• Working beyond “standard” hours as the need arises.
• Travel up to 0%

SCI Shared Resources, LLC is committed to an inclusive, barrier-free recruitment and selection process. On request, we will seek to provide appropriate accessibility options to all applicants with disabilities.

Job Type: Full-time

Pay: $65,000.00 - $75,000.00 per year

Benefits:

• 401(k) matching
• Dental insurance
• Health insurance

Experience level:

• 3 years

Schedule:

• Monday to Friday

Experience:

• SQL: 1 year (Preferred)

Ability to Commute:

• Plantation, FL 33317 (Preferred)

Work Location: In person