SQL Developer

Santa Rosa, CA 95403

Posted: 04/11/2018 Industry: Accounting & Finance Job Number: 28466

Our Financial Services Client is seeking a BI/SQL Programmer Analyst for a 6 month contract-to-hire opportunity. Must have experience with Tabular/Cube/DAX/MDX

This is 100% onsite in Santa Rosa, CA - Greencard and US Citizens are encouraged to apply

 

BASIC FUNCTION:

The BI/SQL Programmer III is a member of the Business Intelligence team whose role is to design and implement BI software and systems that provide timely, accurate, and meaningful enterprise data to key consumers and decision makers in the Association so they can effectively analyze business patterns and trends and make informed decisions.  This is a senior position that would act in a team leadership role providing guidance to other members of the team.

 

ESSENTIAL DUTIES:
  1. Develop SQL-based solutions that meet the Association’ s high standard of quality.
  2. Using SQL, translate data from source systems to data elements that will be used for system integration and data warehouse analysis.
  3. Applicant should have Data Modeling experience in Relational and Dimensional environments.
  4. Collaborate with data analyst and steward, data architect, data modeler, ETL developer, and subject-matter experts to interpret business and technical requirements to deliver SQL based solutions.
  5. Develops complex code or provides coding guidance to less experienced staff.
  6. Use SQL source control, bug tracking, and change management tools.
  7. Adhere to industry standard best practices for SQL development.
  8. Document technical specifications.
  9. Participate in design and code reviews.
  10. Able to design, create, and manage multidimensional structures that contain detail and aggregated data from multiple data sources

TYPICAL EDUCATION AND EXPERIENCE:
  1. Minimum 6 years Microsoft SQL development and demonstrated proficiency
  2. Experience in the design and build of data models
  3. Knowledge of relational and dimensional data design principles and practices
  4. Experience with Extract Transform Load (ETL) and Data Warehousing
  5. Solid understanding of the software lifecycle and software engineering best practices, including specification, documentation, configuration management, testing and quality assurance
  6. Experience with MS SQL Server 2008 and 2012
  7. Experience with version control (i.e. Subversion), issue tracking and build/release management
  8. Good client service, communication skills and able to work in a team programming environment
  9. Strong written and verbal communication skills

 
Apply Online
Apply with LinkedIn Apply with Facebook Apply with Twitter

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.