General Purpose of Job
As a Senior BI Developer, you’ll build and manage data pipelines, architect data stores, and deliver reports and dashboards for internal and external clients. As a Data & Analytics technologist, you’ll also mentor the Data Services team and champion modern data warehousing, durable systems, and industry best practices.
Duties and Responsibilities (Daily and Monthly)
Pipelines & Integration
-
Design, build, and maintain robust ELT/ETL pipelines (SSIS, SQL Agent) that ingest from Hadoop, flat files, Excel, and APIs — engineered for reliability, auto-recovery, and observability.
-
Implement layered data flow (staging ? integration ? presentation) with automated data-quality checks and clear documentation of sources, transformations, and lineage.
Data Warehousing
-
Design and build data warehouses and subject-area marts using dimensional modeling and star schemas — well-formed facts and dimensions, conformed dimensions, and deliberate slowly changing dimension strategies.
-
Establish a single source of truth with shared definitions, modeling standards, and warehouse-level data quality, so metrics stay consistent as the platform grows.
Reporting & Analytics
-
Build and maintain reports and dashboards in SSRS and Power BI (semantic models, DAX, row-level security, gateways), feeding Azure/SharePoint Lists and Dynamics CRM.
-
Source reporting from the warehouse, define each metric once, and curate a maintainable, certified reporting catalog.
Planning & Leadership
-
Translate business requirements into scoped, estimated work; manage dependencies and delivery risk; and report progress in sprint ceremonies.
-
Mentor the Data Services team and lead adoption of best practices across pipelines, modeling, and reporting.
Requirements
Educational
-
Associate degree preferred
-
Bachelor’s degree preferred
Professional
-
Minimum eight years’ experience in Data & Analytics
Computer Skills
-
Data Entry
-
Microsoft Excel and Microsoft Word
-
Microsoft Outlook and Microsoft Teams
Additional Requirements: Excellent communication skills and attention to detail.
Knowledge, Skills & Abilities
-
Minimum 8 years in Data & Analytics; associate or bachelor’s degree preferred.
-
Advanced T-SQL (including query optimization), stored procedures, and views on Microsoft SQL Server — including Azure SQL Managed Instance and Azure SQL Database.
-
Advanced SSIS, SQL Agent, and SSRS; advanced dimensional modeling and star schema design; working knowledge of SSAS.
-
Advanced Power BI Desktop; Power BI Report Builder a plus.
-
Knowledge of Microsoft Fabric, Data Factory, OneLake, Data Warehouse, and Purview governance.
-
Strong communication skills, attention to detail, and solid logic and math skills.
-
Experience in a financial environment and exposure to Agile (Kanban) a plus.
