Position Overview:
The Data Platform & Business Intelligence Developer is responsible for designing, developing, and supporting the organizations 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 organizations 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:
- Bachelors 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.