Job posting date: 05/01/2018 - 06/01/2018
Business Analyst: Experience in design, development and implementation of BI Solutions (ETL & Reporting & Analysis services) using SSIS, SSRS, SSAS, Microsoft SQL Server 2012/ 2008 R2/ 2008/2005, T-SQL, MDX, Power BI and DAX. Analyze the source map documents and creating packages to move the data from source to destination.
Create workflows with Data Flow Task, Script Task, Execute SQL Task and Containers. Use Transformations like Derived Column, Conditional Split, Aggregates, Sort, Data Conversion, Merge join and Union all with error handling while moving the data. Implement Performance Tuning at various levels and create Configurations, Checkpoints and Breakpoints in packages for better reusability. Experience in Creating jobs and Scheduling SSIS Packages.
Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
Extensive Knowledge on creating Dashboards by using Reports and KPI’s. Create simple and complex reports by customizing look and feel by using various report models and pass the parameters according to business user’s request. As per requirements develop reports in the form of Table, Matrix and Chart using SQL Server Reporting Services.
Excellent T- SQL programming skills in writing complex queries to create and update database objects.
Extensive knowledge in writing MDX and DAX queries for creating complex measures and columns.
Experience to include: MS SQL Server 2008 R2/2012/2014, SSIS 2008 R2/2012/2014, SSRS 2008 R2/2012/2014, Power BI, Red gate, Team Foundation Server, SharePoint.
Master Computer Science or Computer Info Systems or foreign equivalent, plus + 2 yrs. exp. / Or Bachelor Computer Science or Computer Info Systems or foreign equivalent. Job site/interview: Irving, TX.
TO APPLY: Send résumé with “Job No. 129” to: Oberon IT, Inc., Attn. HR, 1404 W. Walnut Hill Ln. Suite 102, Irving, TX 75038.
EMPLOYERS NAME: Oberon IT, Inc.