Essential Job Functions
Ability to model data coming in from different data sources into BI technologies such as Azure SQL Data Warehouse, Data Lake and accommodate the self-service reporting by internal users.
Strong SQL and T-SQL skills with SQL Server or Oracle database as backend.
Ability to design and code stored procedures, functions, views and other DB objects.
Ability to design and implement core BI framework to drive analytics across the organization
Fluency in using Azure BI Stack and Data Integration (Data Factory, SQL Data warehouse and Azure Data Lake Storage).
Excellent knowledge in designing and delivery of Power BI Reports, Dashboards, Datasets and related applications.
Expertise in working with a team of Data Scientists to generate Advanced Analytics on structured, semi-structured and unstructured data.
Experience with Integration tools and related technologies will be a plus.
Knowledge and exposure to Cloud Integration concepts & fundamentals.
Knowledge of Product Development Lifecycle and DevOps Tools like Azure DevOps, Git, Ant, JIRA, etc.
Experience with defect triage, analysis, and resolution.
Experience with Microsoft Visual Studio and Microsoft Teams.
Experience instantiating and managing resources in Microsoft Azure.
Essential Physical Abilities
Ability to meet highest attendance requirements.
Ability to communicate effectively, both written and verbally.
Ability to handle multiple assignments on a timely basis with a high degree of accuracy.
Ability to use personal computer, calculator, etc.
Could involve some lifting.
Bachelor’s degree in Business Administration, Computer Science, Information Systems or a related field required.
5-7 years of professional work experience as a Systems Integrator or as a senior Business Intelligence developer implementing successful enterprise BI solutions.
4+ years of experience with BI technologies.
3+ years of experience with SQL Server and ETL.
1-2 years of experience with Microsoft Azure environments will be a plus.
Retail Energy Industry Experience will be a plus.
Strong knowledge and experience in System Development Life Cycle (SDLC) project management and applicability of IT controls to development deliveries.