Data Platform & Business Intelligence Developer

Socket.dev; Eagan (MN); On-site; USD 99,000 - 164,000; Full time

Benefits offered by this job

Medical & pharmacy

Dental

Vision

Health Savings Account

Flexible Spending Account

Dependent care spending

Life insurance

Disability programs

Telemedicine

Tuition support

401(k) with company match

Paid time off

Job summary

Gopher Resource is seeking a Data Platform & BI Developer to design, build, and support our data, reporting, and analytics stack using Microsoft SQL Server, SSIS, and Power BI. You will collaborate with business stakeholders to turn operational data into actionable insights while ensuring data quality, security, and performance.

The role offers opportunities to contribute to ERP modernization and enterprise analytics initiatives.

Qualifications

• Bachelor's degree in IT/CS/IS or related field.
• 3+ years of hands-on SQL Server administration and T-SQL development.
• Experience developing SSIS packages and ETL processes.
• Experience designing and deploying Power BI reports and dashboards.
• Strong relational DB design, data modeling, DW concepts, and BI best practices.
• Ability to gather requirements and translate to reporting and analytics solutions.
• Strong analytical, problem-solving, and communication skills.
• Ability to manage multiple priorities independently in a fast-paced environment.

Responsibilities

• Design, develop, maintain, and optimize MS SQL Server databases and objects.
• Monitor performance, implement tuning, manage backups and high-availability.
• Maintain security, permissions, roles, and auditing controls.
• Develop stored procedures, views, functions, triggers and other DB solutions.
• Design, develop, and support SSIS packages and ETL processes.
• Develop Power BI reports, dashboards, and datasets; publish and maintain.
• Lead requirements gathering and translate business needs into solutions.
• Document data models, definitions, and development standards.

Skills

Microsoft SQL Server

T-SQL

ETL

Power BI

Data modeling

Data warehousing

Data integration

Education

Bachelor's degree in Information Technology

Bachelor's degree in Computer Science

Bachelor's degree in Information Systems

Bachelor's degree in Data Analytics

Tools

SSIS

Power BI

SQL Server Management Studio

Job description

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 concepts effectively to both technical and non-technical audiences.
• Ability to manage multiple priorities and work independently in a fast-paced environment.

Preferred Qualifications

• Previous work experience supporting Microsoft Dynamics 365 Business Central, Navision, or similar ERP platforms, including reporting, integrations, and data management preferred, but not required.
• Previous work experience developing integrations using REST APIs and other data connectivity tools preferred, but not required.
• Knowledge of Azure data services, Synapse Analytics, Databricks, or AWS analytics platforms preferred, but not required.
• Previous work experience designing or supporting cloud-based data lake, lakehouse, or modern analytics architectures preferred, but not required.
• Previous work experience with Git, Azure DevOps, GitHub Actions, or CI/CD methodologies preferred, but not required.
• Previous work experience with C#, .NET, Blazor, WPF, or other application development technologies preferred, but not required.
• Microsoft certifications such as PL-300, DP-300, AZ-900, or related data and analytics certifications preferred, but not required.
• Previous work experience supporting data governance, master data management, and enterprise reporting standards preferred, but not required.

Compensation & Benefits

Salary Range: $99,304 - $163,759. This position is also eligible for a short-term incentive plan which is determined by the achievement of strategic objectives. The market rate for the role is typically at the midpoint of the salary range; however, variations in final salary are determined by additional factors such as candidate qualifications, relevant years of experience, geographic location, internal pay equity, and prevailing market conditions for the specific role.

Benefits: Gopher Resource is proud to offer a comprehensive benefits package that promotes the health, wellness, and financial security of our employees. List of benefit offerings include medical & pharmacy, dental, vision, health savings account (HSA), flexible spending account (FSA), dependent care spending account, life insurance, disability programs, telemedicine, parental leave, tuition support, legal insurance, identity theft protection, gym membership discounts, EAP, 401(k) with a company match, and paid time off (vacation, personal, bereavement, holidays).

Gopher Resource is an Equal Opportunity Employer.