Microsoft Full Stack BI Developer

The BI Developer reports to the Business Intelligence Manager and is responsible for combining raw information from disparate IT source systems into data models, reports and dashboards to deliver business insights. The successful candidate will be able to complete the full lifecycle of development of data from the ETL process through to final deliverable of dashboards into the organization.

To succeed in this BI Developer position, you should have strong analytical skills and the ability to develop and maintain data and security models using modern techniques. If you are detail-oriented, with excellent organizational skills and experience in this field, we d like to hear from you.

Essential Duties and Responsibilities

• Participate in business requirement gathering and solution documentation
• Build required infrastructure for optimal pipeline management, including extraction, transformation and loading of data from various data sources using Azure Data Factory, Databricks and SQL technologies
• Assemble and analyze large, complex sets of data that meet non-functional and functional business requirements
• Implement internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
• Work with users to assist them with data-related technical issues
• Implement and test data and security models
• Prepare data for prescriptive and predictive modeling
• Develop interactive visual reports, dashboards, charts, and measures with KPI scorecards using Microsoft Power BI desktop
• Analyze, design, deploy, troubleshoot, and support Power BI solutions
• Participate in user acceptance testing
• Explore and implement ways to enhance data quality and reliability
• Collaborate with data scientists and architects as needed

Education

• Bachelor s degree (B.S./B.A.) in computer science, information systems, informatics, statistics or another quantitative field or equivalent from a college or university with IT focused specialization.
• A Master s Degree or Data engineering certification (e.g, Azure Certified Data Engineer) is a plus

Skills/Experience

• 5+ years experience as a BI Developer or related experience in a global company with significant experience in hands-on technology delivery roles.
• Strong data analytics background with experience in developing use cases, deep understanding of managing data and generating insights thru visualization
• Background in custom build experience using Power BI Report Builder, Power BI Desktop, Power BI Service, Tabular Editor, ALM Toolkit and DAX Studio designing Power BI data models; including writing complex DAX, SQL queries and implementing role level security
• Ability to understand data modeling, data schemas (normalized, flat, star, snowflake, etc), query optimization, query profiling and query performance monitoring tools and techniques
• Knowledge of programming languages (eg Java, AngularJS, Python)
• Experience with workflow management and pipeline tools - Azure Data Factory and DevOps; storage technologies - Azure Data Warehouse and Data Lake; stream-processing systems - Event Hub and Stream Analytics; transformation tools - Databricks; visualization tools - PowerBI; and metadata management systems.
• Experience with big data tools like Spark is a plus as we'll as knowledge of Pyspark.
• Familiarity with Machine Learning and Deep Learning concepts are a plus
• Ability to build processes that support data transformation, workload management, data structures, dependency, and metadata
• Experience working with unstructured datasets
• Hands-on experience with optimizing performance of SQL queries and applications
• Great numerical and analytical skills
• Ability to collaborate with technical resources to influence algorithms and other technology for improved customer experience