Microsoft BI Developer
IBA InfoTech Inc.
Charlotte, United States of America
27 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Charlotte, United States of America
Tech stack
Sql Server Data Tools (SSDT)
Agile Methodologies
Business Analytics Applications
Azure
Big Data
Code Review
Data Validation
ETL
Data Mining
Data Visualization
Relational Databases
Hadoop
Python
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
T-SQL
Enterprise Software Applications
Performance Testing
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