Job Description :
Role BI Data Engineer
Location Roseland, NJ
Duration Long Term

QUALIFICATIONS
? Bachelor’s degree in Computer Science, Engineering, or equivalent education; Master’s degree, preferred
? Minimum 10 years of experience with software development using Microsoft technologies.
? 6+ years of Data Modeling, Data Warehouse, SSIS, SSRS
? Demonstrated proficiency with Microsoft Office Suite of products and with Structured Query Language (SQL)
? Demonstrated ability to write transact-SQL queries
? Demonstrated ability to interact cross-functionally at all levels internally and externally, and ability to develop
relationships with vendors, customers and prospects, when appropriate
? Ability to quickly learn and effectively leverage operations, enabling technology, processes and other assets
? Demonstrated negotiation, facilitation and consensus building skills

Experience in using Cloud based managed services for data warehousing/analytics in Microsoft Azure (Azure Data Lake, Azure Data Lake Analytics, Azure Data Factory, Azure Table Storage, U-SQL, Stream Analytics, HDInsight, etc
? Write sophisticated SQL queries to extract data and build models.
? Build/automate reports/dashboards (in Power BI and Microsoft Analysis Services) that allow the business leaders to get a clear snapshot of their operations.
Systems and Standards
? Completes tasks in a timely manner as instructed by the supervisor.
? Cooperates with senior management and coworkers to ensure that services can be adequately maintained and meets
the needs of internal and external customers.
? Treats clients and associates with courtesy, respect and dignity.
? Interfaces with management and technology support personnel

SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Data Quality Services.
? Strong Data Modeling skills to include data quality, source systems analysis, business rules validation, source target, mapping design, performance tuning and high volume data loads.
? Sr. level understanding of warehousing architectures including ETL design, staging, transformations, delta/change data capture, star-schemas, cubes, and history loading
? Experience leveraging ETL frameworks to develop scalable solutions using SSIS. Design and develop SSIS packages, configuration files, stored procedures, tables, views and functions;
? Understand database platform layouts and configurations.
? Excellent communication skills
? Experience working in an agile team environment. Understanding of code promotion, code turnover to operations, version control, and QA procedures. Conduct code walkthroughs, peer reviews, and produce technical documentation
? Strong analytical skills and problem-solving ability, including an expertise in soliciting and interpreting customer. business needs and translating them into application and operational requirements.
? Demonstrable strong organizational and critical thinking skills with the ability to prioritize and negotiate with stakeholders.
             

Similar Jobs you may be interested in ..