Data Platform & Business Intelligence Developer

Data Platform & Business Intelligence Developer

Position Overview:

The Data Platform & Business Intelligence Developer is responsible for designing, developing, and supporting the organization's data, reporting, and analytics platforms. This role partners with business stakeholders to transform operational data into actionable insights through Microsoft SQL Server, SSIS, and Power BI solutions. The position plays a critical role in ensuring data accuracy, availability, security, and performance while supporting the organization's growing data and analytics needs.

This role also provides opportunities to contribute to ERP modernization, data architecture, application development, and enterprise analytics initiatives, supporting continued professional growth and expanded business impact.

Critical Success Criteria:

• Data Platform Reliability & Performance – Maintains secure, scalable, and high-performing databases, ETL processes, and reporting environments.
• Business Intelligence Delivery – Develops accurate, user-friendly reports and dashboards that provide meaningful insights and support business decision-making.
• Data Quality & Governance – Ensures data integrity, consistency, and adherence to reporting standards and best practices.
• Continuous Improvement & Innovation – Identifies opportunities to enhance analytics capabilities, automate processes, and improve operational efficiency.

Responsibilities:

Data Platform & Database Administration

• Design, develop, maintain, and optimize Microsoft SQL Server databases and related database objects.
• Monitor database performance, implement tuning initiatives, support backup and recovery processes, and administer SQL Agent jobs and high-availability solutions.
• Maintain database security, permissions, roles, and auditing controls.
• Develop and support stored procedures, views, functions, triggers, and other database solutions.

Data Integration & ETL

• Design, develop, and support SSIS packages and data integration processes.
• Manage data ingestion, transformation, validation, and distribution between systems.
• Troubleshoot, optimize, and maintain scheduled ETL jobs and data pipelines, including data validation, monitoring, and error-handling processes.
• Support integrations with ERP platforms, third-party applications, APIs, flat files, and external data sources.

Business Intelligence & Analytics

• Develop, publish, and maintain Power BI reports, dashboards, and datasets.
• Create semantic and dimensional data models, DAX measures, calculated columns, and reporting standards to support scalable self-service reporting and analytics.
• Support Power BI administration including workspace management, gateway administration, security, and scheduled refreshes.
• Lead requirements gathering sessions, translate business needs into technical solutions, and deliver reporting and analytics capabilities that support operational and strategic decisions.

General Responsibilities

• Document data models, reporting definitions, development standards, and technical processes.
• Support data governance, data quality, data stewardship, reporting consistency, metadata documentation, and enterprise reporting standards.
• Participate in analytics, ERP, and application enhancement projects.
• Stay current with emerging technologies, tools, and industry best practices.
• Perform other duties and special projects as assigned

Requirements:

• Bachelor's Degree in Information Technology, Computer Science, Information Systems, Data Analytics, or a related field from an accredited College or University.
• 3+ years of hands-on Microsoft SQL Server administration and T-SQL development experience.
• Previous work experience developing and supporting SSIS packages and ETL processes.
• Previous work experience designing, developing, and deploying Power BI reports and dashboards.
• Strong knowledge of relational database design, query optimization, dimensional data modeling, data warehousing concepts, and business intelligence best practices.
• Previous work experience gathering business requirements and translating them into reporting and analytical solutions.
• Strong analytical, problem-solving, and troubleshooting skills.
• Ability to communicate technical…