SSAS BI developer (Remote option)

Mapjects.com; Atlanta (GA); Remote; USD 90,000 - 140,000; Full time

Job summary

Mapjects is seeking an experienced ETL/BI specialist to design SSAS cubes and develop SSIS-based ETL pipelines. The role requires strong T-SQL skills, data profiling, and familiarity with Data Quality Services. Experience with Excel BI tools and optional EF/Linq to SQL knowledge is a plus.

The candidate will collaborate with clients and management to document requirements and deliver robust BI solutions, with potential remote work options after initial onboarding.

Qualifications

• Proven experience designing SSAS cubes.
• Proficient in MS SQL Server SSIS for ETL and reporting.
• Strong T-SQL, stored procedures, and functions.
• Experience with Data Quality Services and data profiling.
• Familiarity with common ETL design patterns.
• OLTP DBA experience is a plus.
• Familiar with Excel BI Tools and data visualization.

Responsibilities

• Communicate effectively with clients and management.
• Design and develop SSAS cubes for analytics.
• Develop ETL processes using SSIS and generate reports.
• Write and optimize T-SQL, stored procedures and functions.
• Apply Data Quality Services and data profiling techniques.
• Follow established ETL design patterns.
• OLTP DBA experience is a plus and beneficial.
• Utilize Excel BI Tools for reporting.
• Understand Entity Framework and Linq to SQL is a plus.

Skills

ETL design patterns

T-SQL

SQL Server DBA

Communication skills

Tools

SSIS

SSAS cubes

Excel BI Tools

Entity Framework / Linq to SQL

Job description

Mapjects is a leading centralized logistics operations portal platform. The platform serves franchises with ERP components that suite the franchise business needs and b2b eCommerce.

• Status - US, GC, H1, or C2C
• Corp 2 Corp, 1099, or W2 (please email your expectations, with resume and availability to start)
• After the initial 1 month (we're open to working remote for the right candidate)

Job Description

• The ability to effectively communicate, explain and document with clients and management
• Highly proficient and comfortable designing SSAS cubes
• Proficient at designing and developing ETL using MS SQL Integration Services (SSIS), reporting
• Proficient at writing T-SQL, stored procedures and functions
• Proficient with Data Quality Services and data profiling
• Experienced with common ETL Design Patterns
• Ability to perform as OLTP DBA is a plus
• Proficient in Excel BI Tools
• Understanding of Entity Framework and Linq to SQL is a plus

Qualifications

Optional (nice to have)

Utilities for maintainence

• Monitors server and database capacity and performance
• Maintains relevant database documentation to facilitate support by Database Engineering and Operations staffs