Data & AI jobs

SQL BI positon(SSAS/TSQL)

Atria Group LLC (agency)Miami, FLContract

Pay not listed

Key facts

Experience
5+ years
Degree
Bachelor's degree
US visa
No US visa sponsorship

2 things to check before you apply.

On Atria Group LLC’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 11 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 60 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Design, develop, deploy, monitor, and troubleshoot BI solutions.
  • Write relational and multidimensional queries and build ETL packages and database objects to support reporting, cubes, and the data warehouse.
  • Configure, deploy, and maintain database servers; create data marts for reports and BI models.
  • Provide Tier 2 support for the BI platform and resolve end-user reporting issues.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 5+ years of general database development using MSSQL (SQL Server 2005–2008/R2)
  • 1+ year of C# or VB.NET experience
  • 3+ years of enterprise ETL experience, including SSIS or another ETL toolset
  • 3+ years of BI experience using SSAS or another OLAP toolset
  • 2+ years of SSRS programming experience
  • Oracle experience (preferred)
  • 2+ years working with BI tools such as Tableau, Cognos, or another relevant BI solution (preferred)

Education

  • B.S. degree in a technical discipline

Skills

  • Advanced ability to write stored procedures, read query plans, tune indexes, and troubleshoot performance bottlenecks

Other requirements

  • U.S. citizen, Green Card holder, or EAD holder

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Atria Group LLC’s careers site

Company Description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

Show full descriptionShow less

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

This role is ideally suited to an individual who is passionate about IT and data and its application in the business environment in support of growth and efficiency.

Creating logical and innovative solutions to complex business problems, with a heavy emphasis on SQL BI, the role encompasses all aspects of a project

from initial briefing through final delivery and testing. It is suited to someone who is comfortable interfacing at all levels of the organization, providing

great customer satisfaction while delivering first-class solutions. Ability to function effectively without close supervision.

Main responsibilities

  • Designing and plan BI solutions
  • Debugging, monitoring and troubleshooting BI solutions
  • Writing relational and multidimensional database queries
  • Configuring, deploying and maintaining database servers
  • Design, develop and support ETL packages (SSIS) for data flow including SQL tables, views, functions, stored procedures, synonyms for BI use in an end-user reporting applications SSRS, Tableau and cubes feed as well as the DW.
  • Provide Tier 2 support for BI Platform through SSAS/Tableau
  • Work with all levels of development from analysis through implementation and support
  • Creating and deploying Data Marts to be consumed by reports and BI models
  • Resolve end user reporting problems
  • Other duties as assigned

Required Skills

B.S. degree in technical discipline

5+ years in general database development using MSSQL up through SQL 2005-2008/R2. Experience in Oracle is a plus

+2 years working with BI tools such as Tableau, Cognos or other relevant BI Solution a plus

Advanced level of writing stored procedures, reading query plans, tuning indexes and troubleshooting performance bottlenecks

+1 years C#/VB .Net

+3 years ETL experience, including SSIS or other ETL toolset in an enterprise environment

+3 years BI experience utilizing SSAS or other OLAP toolset.

+2 years experience with SSRS programming

Problem solving, analytical and communication abilities.

Challenge current thinking to provide new and improved ways of delivering information and performing business processes.

Proactively identify areas for improvement and evaluate viable alternative IT solutions to business problems using data in innovative ways.

Work closely with associates and departments at all levels of the business in identifying and resolving data related problems.

Maintain and ensure integrity of data in and assist with the administration of various databases.

Extensively test and document solutions to a high and consistent standard.

Leverage maximum benefit from existing systems

Additional Information

  • Good comm skills are a big priority
  • Duration: 6+ Months

- Interview Mode::Phone and F2F

- Needs UC/GC/EAD Only

Something wrong with this job? Report it · This flag looks wrong