SQL BI Developer
Remote Database Experts
Warrendale, PA

About $100,000 - $130,000 a year

RDX is the leading global provider of remote DBA, Cloud and Data Infrastructure Support Services.

SQL Server BI Developer (Remote Opportunity)

The SQL Server BI Developer/Administrator responsibilities are:

Engage in detailed and advanced requirements gathering for BI projects and statements of work
Create and maintain technical writing and guidelines for BI Solutions and statements of work
Design relational and analytical database schemas and architectures based on best practices and customer requirements/needs
Administer production databases and processes including maintenance related tasks and activities
Troubleshoot existing BI solutions including ETL, cube processing and reporting errors
Provide recommendations on existing server and database level BI architecture using best practices and knowledge of business requirements
Design, implement, deploy and maintain the ETL process and data flow, including data quality and unit testing.
Architect, design, deploy and maintain enterprise level data warehouses and data marts including various data modeling techniques, multi-dimensional and tabular architectures
Write complex T-SQL code and stored procedures to be utilized by applications, ETL and reports
Review, recommend and implement changes to existing T-SQL code and stored procedures for performance improvements
Troubleshoot MDX and DAX code
Design complex reports and dashboards to satisfy business needs using native tools as well as some third party applications

Technical skills and experience required include:
Microsoft SQL Server 2000, 2005, 2008, 2008R2, 2012 and 2014
Experience with designing, developing, and supporting database environments
Strong customer relationship management
Technical writing and documentation experience
Expertise in Microsoft SQL Server Integration, Analysis and Reporting Services
Exceptional analytical, conceptual and problem-solving abilities
Development of Multi-dimensional and/or tabular data warehouses
Familiarity with metadata management concepts, change management/version control concepts
Versatile and knowledgeable in T-SQL programming and SSIS design
Some experience in database administration
Experience with other BI Tools such as Power BI, QlikView, Tableau, Cognos, etc. is a plus
Experience with other programming and machine learning languages is a plus

Bachelor’s degree in a technical or science related field of study.
Minimum 3 years of experience in Microsoft SQL Server or equivalent work experience