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 (e. g. 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 well 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