W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J36993

  • Specialized Area:

    SQLBI

  • Job Title:

    SQL BI Developer

  • Location:

    warrendale,PA

  • Duration:

    12 Months

  • Domain Exposure:

    Healthcare, Insurance, Real Estate, Oil & Gas, IT/Software

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description

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

Education/Experience

  • Bachelor’s degree in a technical or science related field of study.

Apply Now
Equal Opportunity Employer

DIGITAL TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. DIGITAL TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will DIGITAL TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract