Marsh Company Logo
Marsh - Austin, TX

-

AUS0018U

Description

Entry Level Data Warehouse Developer

Reports to:
Analytics Manager – MMA Southwest Division

Location:
Austin, TX

Salary:
$45,000 - $70,000 depending on experience

**NOT ABLE TO PROVIDE SPONSORSHIP

The candidate will be responsible for the development, deployment, and maintenance of data marts, and ensuring the proper flow into the data warehouse.

Experience and Qualifications

Requirements:
SQL Server 2012 and Visual Studio 2012, one year

Strong T-SQL coding, creating & editing

Proficiency with stored procedures and SSIS packages

Understanding of star schemas, dimensional modeling, and data warehousing concepts (including keys & transactional statements)

Working with non-standardized data from external sources

Troubleshooting errors and debugging code

Ability to adhere to coding standards and participate in peer code reviews

ETL design concepts and monitoring

Preferred but not required:
SQL Server Analysis Services (SSAS) 2012

Team Foundation Server (TFS) 2012

SQL Server Reporting Services (SSRS)

Master Data Services (MDS) 2012

Melissa Data deduplication components

Multi-dimensional tabular modeling

Knowledge of HIPAA regulations and best practices pertaining to PHI or PII

Responsibilities

Construct, deploy, maintain operational data stores

Monitor data warehouse performance

Create solutions for maintaining data integrity and database efficiency

Investigate and troubleshoot coding errors and data flow failures

Create enhancements to existing data model and related platforms

Ensure security of data warehouse containing PHI

The data warehouse developer would be assigned to a small development team in the downtown Austin office. The development team supports a larger Financial/Analytics Unit whose primary focus is to report on, analyze, and help manage health insurance benefit plans for large employers located in Texas and surrounding regions. Salary range is between $45,000 - $70,000 depending on experience.

Qualifications

Requirements:
SQL Server 2012 and Visual Studio 2012, one year

Strong T-SQL coding, creating & editing

Proficiency with stored procedures and SSIS packages

Understanding of star schemas, dimensional modeling, and data warehousing concepts (including keys & transactional statements)

Working with non-standardized data from external sources

Troubleshooting errors and debugging code

Ability to adhere to coding standards and participate in peer code reviews

ETL design concepts and monitoring

Preferred, but not required

SQL Server Analysis Services (SSAS) 2012

Team Foundation Server (TFS) 2012

SQL Server Reporting Services (SSRS)

Master Data Services (MDS) 2012

Melissa Data deduplication components

Multi-dimensional tabular modeling

Knowledge of HIPAA regulations and best practices pertaining to PHI or PII

Responsibilities

Construct, deploy, maintain operational data stores

Monitor data warehouse performance

Create solutions for maintaining data integrity and database efficiency

Investigate and troubleshoot coding errors and data flow failures

Create enhancements to existing data model and related platforms

Ensure security of data warehouse containing PHI

The data warehouse developer would be assigned to a small development team in the downtown Austin office. The development team supports a larger Financial/Analytics Unit whose primary focus is to report on, analyze, and help manage health insurance benefit plans for large employers located in Texas and surrounding regions. Salary range is between $45,000 - $70,000 depending on experience.

Job

Database

Primary Location

US-TX-Austin

Marsh & McLennan Companies and its Affiliates

are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers. ... Learn More

About Marsh

Marsh has been categorized as Insurance : Insurance Agencies & Brokerages employer and has a rating of 3.4 / 5 out of a total count of 405 ratings

Posted 30+ days ago - Save Job

Apply Now

 
or
 

 

Related Developer Jobs