SQL Developer

  • location: Roseville, CA
  • type: Temp to Perm

job description

SQL Developer

Our client is looking for a SQL Developer in the Sacramento area. This will start out as a contract-to-hire.

This role will be responsible for:

(1) ETL development / maintenance to support reporting & billing; (2) program documentation; (3) T-SQL queries, stored procedures, and SSIS packages; and (4) SSRS and Microsoft BI Cube (SSAS) based reporting including their (a) requirements gathering, (b) technical design, (c) implementation, and (d) production support for all departments in the organization. (5) Data Warehousing protocols, strategies, and best practices for (a) designing, (b) maintaining, and (c) implementing new logic and structure to an existing Data Warehouse and Data Mart structure. The position will develop and oversee the automated business intelligence reporting and maintain the reporting solutions' framework to elevate company's analysts and other end users who need timely, correct and impactful information.


  • Perform ETL business logic and billing information, T-SQL, SSRS and SSAS / Cube reporting solutions' requirements gathering, documentation, design, development, deployment, testing, and maintenance
  • Execute the reporting's side of the billing process including daily updates, monthly analysis & reporting, and occasional meetings with auditors to demonstrate the billing program's documentation & execution
  • Partner with associates in IT, Compliance, Operations, Sales and other departments to flush out report issues, hone report requirements and implement analytical solutions
  • Drive improvements in the analytics department including enhancing reports' speed and capabilities; streamlining data / reporting architecture & processes; as well as deploying new tools and other activities
  • Acquires a deep understanding of the reporting data to facilitate development, establish baseline data sets, assist in testing; and provide program & process documentation
  • Consults with business users to design and implement updates to the BI Data Warehouse and Cube to solve complex business reporting problems
  • Coordinates with the DBA on Data Warehouse updates and overall cube administration
  • Trains others on proper T-SQL process, program and development methodologies
  • Support analytical information needs via other duties and special projects as required

  • 6+ years of T-SQL work (very strong knowledge of stored procedures, ETLs, complex queries & joins, SSIS packages, and user-defined functions)
  • 3+ years of SSRS report development and deployment experience
  • 3+ years of SSAS development and administration
  • Advanced problem solving and analytical skills
  • Experience writing MDX queries for cubes
  • Ability to quickly understand business requirements and transform user requirements into queried reports / stored procedures as well as Data Warehouse / Cube solutions as needed
  • Excellent written and verbal communication skills, with the ability to clearly explain technical issues to a non-technical audience
  • Exceptionally detail orientated and ability to cross-check work to user specifications
  • Resolved to keep the team informed on (via meetings & communications) and maintains proper documentation & backups of changes (i.e. via Apache's SVN or other software versioning tool)
  • Proficient working independently-with little direction-and as a supportive team member
  • Comfortable working with business partners across the organization
  • Accustomed to fast-paced environments with simultaneous, high-priority tasks
  • Working knowledge of MS Office (including Excel, Outlook, PowerPoint, Visio, & Word)
  • B.S. degree in Computer Science, Information Systems, Decision Sciences, or a related business degree and / or equivalent experience

  • Regulated industries work such as telecommunications, finance or related businesses
  • Working in a Software Development Lifecycle (SDLC) environment and using related tools
  • Use of version control (Git, SVN or other tools / methodologies)
  • Defining and utilizing data warehouses and dynamic reporting (including but not limited to data modeling, ETL architectures, OLAP, drillable reports, star/snowflake schemas, etc)
  • Dealing with database performance and scaling issues
  • Using of SCRUM and Agile methodologies for iterative software development
  • Strong knowledge of MS Excel (worksheet design, advanced functions and pivot tables)

get jobs in your inbox.

sign up

related jobs

    Java Developer

  • location: Rancho Cordova, CA
  • job type: Temp to Perm
  • date posted: 5/21/2018

    FileNet Developer

  • location: Sacramento, CA
  • job type: Contract
  • date posted: 6/14/2018