Microsoft BI Developer

IBA InfoTech Inc.

Charlotte, NC, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

ibainfotech.com

Tech stack

Sql Server Data Tools (SSDT) Agile Methodology Business Analytics Applications Microsoft Azure Big Data Code Review Data Validation Extract Transform Load (ETL) Data Mining Data Visualization Relational Databases Apache Hadoop

+19 more

Python (Programming Language) Microsoft SQL Server Online Analytical Processing Online Transaction Processing Performance Tuning Power BI Software Engineering SQL Databases SQL Server Reporting Services SQL Server Integration Services SQL Server Analysis Services Transact-SQL Enterprise Software Applications Performance Testing Apache Spark Information Technology Data Analytics Star Schema SQL Server Management Studio (SSMS)

Job description

Design and implement multi-tier enterprise software for unique and challenging enterprise business problems
Participate in business process analysis and requirements gathering sessions with business stakeholders while contributing to the design, presentation, and implementation of technical solutions to meet business needs
Develop, document, and implement data models for OLTP and OLAP systems
Develop, document, and implement data mappings for ETL implementations
Contribute in the full software development life cycle from scoping, analysis, design, implementation, and quality assurance to delivery and support
Assist in pre-sales, scoping and requirements gathering process
Provide technical guidance and mentoring to junior consultants in best practices in Business Intelligence
Participate in code reviews with peers and senior technical leaders

Requirements

Bachelor’s degree in Computer Science, MIS or directly related field
5+ years of experience with Microsoft SQL Server and proficiency in T-SQL
5+ years of experience sourcing, star schema & relational data modeling, ETL and processing
Expert-level knowledge around SSIS, SSAS (Multidimensional and Tabular), SSRS, PowerBI and tools such as SSMS and SSDT
Strong working knowledge and track record of Data Analytics development
Experience deploying and supporting large scale analytical platforms
Experience with designing and building end-to-end tabular models in an enterprise environment
Strong working experience in Microsoft Tabular analysis services
Experience working with Data Visualization, Auditing, Data Validation, and Data Mining
Experience with DAX queries
Experience with MDX queries is a plus
Experience designing automated processing, data validation, error checks and alerts, and performance testing techniques
Excellent presentation, verbal and written communication, and time management skills
Familiarity with big data platforms, tools, and languages such as Hadoop, Spark, Python, etc. is considered a strong plus
Experience working with SQL Azure and cloud data solutions is a plus
Multidimensional and Tabular Cube performance tuning and troubleshooting is a plus
Working in an Agile development environment is a plus
Strong written and verbal communications skills to work with your team and with our clients
Ability to engage in customer settings and discern client business needs