Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

Azure BI Developer (186 views)

Atlanta, GA (On-Site)
November 2, 2021

***** Direct Client Requirement*****

Title                                    : Azure BI Developer

Location                             : Atlanta, GA (On-Site)

Rate                                    : DOE /If your experience and skills match call us immediately for submission

Duration                             : 6 Months

Interview Type                   : Web Cam or In Person

Job Type                            : C2C,C2H,W2

Experience                        : 8 Years

Job Description:

Job Summary:

The ideal candidate must demonstrate in-depth knowledge and understanding of Database concepts and, experienced in writing SQL and T-SQL. Need to support the applications with 24/7 availability and experience in handling Large Volume of Data, in Oracle and SQL Server, Azure SQL platform.

Essential Duties and Responsibilities:

  • Collaborate with internal customers, prospects, and stakeholders, understand, and translates business use cases and/or requirements
  • into data analysis and data mapping and consequently data integration routines which involves moving, cleansing, and transforming large amount of data between multiple systems.
  • Identifies data sources, provides data flow diagrams, and documents source to target mapping and process.
  • Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports
  • Provide technical enablement to team members developing database applications on a cloud platform.
  • Facilitate the development of data integration efforts by leading small teams of 1-2 junior developers in addition to Knowledge of ETL Design Patterns, Error Handling and Configurations.
  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
  • Collaborate with data stewards, data owners and domain experts to recognize and help adopt best practices in reporting and analysis: data integrity, test design, validation, and documentation.
  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
  • Work with the Data Architect to establish processes for governing the identification, collection and use of educational metadata to assure metadata is accurate and valid in the business intelligence environments.
  • Ensure data quality through creation of audit controls, proactive monitoring, and data cleansing techniques.
  • Troubleshoot performance and reliability issues and investigate anomalous behavior in the Azure environment.
  • Responsible for scheduled data processes integrity checks, performing deployments and coordinate for releases.
  • Experience with Source Version Control software like GitHub and CICD pipelines
  • Provide on-call support after hours as an when needed.

Requirements:

  • 7+ years of experience in Data Warehousing and Business Intelligence
  • 5+ Years in BI development leveraging the Microsoft SQL Server. Needs to be an expert in T-SQL
  • 5+ Years in SSIS and use of Stored Procedures.
  • 1-2 Years in Azure Data Factory, SQL VMs, build and maintain ETL
  • Ingest and aggregate data from both internal and external data sources to build our data lake
  • Strong understanding data modeling (i.e., conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
  • Deep understanding of relational database design concepts and SQL programming
  • Experience guiding/mentoring developers with lesser experience.
  • Requires strong analytical, conceptual, and problem-solving abilities.
  • Strong experience with business intelligence and data warehousing design principles and industry best practices.

Good to have:

  • 1-2 Years in Azure Data Warehouse (Synapse)
  • 1-2 Years knowledge of utilizing Python, PySpark, SparkSQL On Azure Cloud

Qualifications:

  • Bachelor’s degree from an accredited college or university with coursework in computer science or management information systems AND 8 years of related experience.

Note: The client is allowing telecommuting for this position for immediate future. However, the candidates must reside within commuting distance from the client site as urgent on-site meetings or full-time on-site work could be required at any time. Candidate outside Atlanta and willing to relocate can apply. Do you and your candidate agree to this requirement?

Required / Desired Skills

  • Data Modeling
    Desired 5 Years
  • Data Warehousing and Business Intelligence
    Required 7 Years
  • Microsoft SQL Server, T- SQL, PL/SQL
    Required 5 Years
  • Sql Server Integration Services
    Required 5 Years
  • Azure Data Factory, SQL VMs
    Required 3 Years
  • Azure Data Warehouse
    Nice to have 2 Years
  • Python, PySpark, SparkSQL on Azure Cloud
    Nice to have 2 Years

*****Referral Bonus Available: Refer your friends or colleagues, get referral bonus*******

Thanks

Anil\Siva

Anil@sohanit.com\Siva@sohanit.com

PH:470-480-2407 EX 101\470-480-2412 EX 103

Apply here or please send to resumes@sohanit.com

Follow us on LinkedIn and Twitter for daily active requirements

LinkedIn: https://www.linkedin.com/company/sohanit-inc/?viewAsMember=true

Twitter: https://twitter.com/SohanITInc1

Position Keywords: SQL,TSQL,Oracle,SQL Server,Azure,Github,SSIS,Data Warehouse,Python,PySpark,PL/SQL,Synapse,SparkSQL,ETL

Pay Rate: DOE /If your experience and skills match call us immediately for submission

Job Duration: 6 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 3636

Don't have time now?
Get a reminder in your inbox