Business Intelligence Developer

NOT A REMOTE POSITION. Must live in Omaha. In-person required. Possible hybrid.

Job Summary: The Business Intelligence (BI) Developer plays a strategic role in developing, maintaining, and optimizing NP Dodge’s data and collaboration platforms. This position is responsible for designing and delivering BI solutions, managing data warehouse structures, and maintaining scalable ETL pipelines to ensure timely and accurate data delivery. Additionally, the role extends to supporting and administering SharePoint environments to facilitate internal collaboration and knowledge sharing. The BI Developer works cross-functionally to deliver data-driven insights and streamline business processes through technology.

Essential Functions:

BI Development & Reporting:

· Designs and develops interactive dashboards, reports, and KPI visualizations using tools such as Power BI, SSRS, or similar platforms.

· Translates business requirements into scalable data models and analytics assets that support tactical and strategic decision-making.

· Ensures all reporting solutions maintain high standards of data accuracy, integrity, and performance.

Data Warehouse Management:

· Collaborates in the design, implementation, and continuous improvement of enterprise data warehouses.

· Builds and optimizes SQL structures, including dimensional models and indexed tables, to support efficient analytical querying and self-service BI.

· Applies performance-tuning techniques such as partitioning, indexing, and storage optimization to ensure warehouse scalability.

ETL Pipeline Design & Maintenance:

· Develops and manages scalable ETL pipelines using tools like SSIS, integrating data from diverse sources such as APIs, flat files, cloud services, and relational databases.

· Monitors and troubleshoots ETL processes to maintain data availability, efficiency, and reliability.

· Ensures data pipelines are robust, reusable, and well-documented.

Collaboration and web development

· Experience with collaboration platforms (SharePoint, Zoom) is a plus, including site configuration, permissions, workflows.

· Familiar with basic web development concepts (HTML, CSS, JavaScript) or CMS desirable.

· Ability to support and improve internal collaboration solutions through customization and governance best practices.

Cross-Functional Collaboration & Support:

· Acts as a liaison between IT, Accounting & Finance, and business units to understand reporting, data, and collaboration requirements.

· Contributes to cross-departmental initiatives involving data visualization, process automation, and system integration.

· Creates and maintains comprehensive technical documentation for BI assets, data models, ETL processes, and SharePoint implementations.

· Demonstrates company core values.

· Reasonable and reliable attendance and timeliness when reporting to work and completing work.

· Interacts well with others.

Education/Experience/Qualifications:

· Preferred Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or equivalent experience.

· One year of experience in BI development, data warehousing, or ETL. SharePoint experience is preferred.

· Proficient in Power BI, SSRS, and SQL (queries, stored procedures, data modeling).

· Experience with ETL tools such as SSIS and integrating diverse data sources.

· Familiar with SharePoint configuration, permissions, and workflows.

Required Skills / Abilities:

· Strong analytical and troubleshooting abilities.

· Ability to identify and resolve technical issues.

· Excellent communication and collaboration skills; ability to convey technical concepts to business stakeholders.

· Ability to work independently and in cross-functional teams.

Special/Physical Requirements (denote if office, hybrid, remote):

Office or hybrid.

EEO Statement:

NP Dodge Company is an equal opportunity employer and provides equal employment and advancement opportunities to all people without regard to race, color, religion, sex, national origin, age, marital status, political beliefs, disability, or history if disability (except where physical or mental abilities are a bona fide occupational qualification) and to promote the full realization of this policy.

Pay: From $55,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Employee discount
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Professional development assistance
• Referral program
• Retirement plan
• Tuition reimbursement
• Vision insurance

Work Location: In person

Salary : $55,000