BI/ETL Developer

Job Summary:

Spinsys-Dine is seeking a Business Intelligence/ETL Developer to support a leading effort in the design, implementation and maintenance of self service business intelligence portals, client/internal dashboards, and associated reports and data feeds. This person will be responsible for implementing and maintaining reporting and business intelligence solutions to support the customer. The qualified candidate will have experience working directly with customer to gather requirements and conduct demonstrations and training where required, so communication and professionalism are a must. In addition, this person will work with other remote team members in an agile development environment that is high energy and rewarding.

Job Duties and Responsibilities:

BI Development:

• Design, develop, and implement comprehensive BI solutions using tools such as Tableau, Power BI, or similar platforms.

• Create and maintain dashboards, reports, and visualizations that provide actionable insights to business stakeholders.

• Collaborate with stakeholders to gather requirements and translate them into technical specifications for BI solutions.

• Identify trends, patterns, and anomalies in data to support business strategies and improve decision-making.

• Perform data validation and ensure data accuracy and integrity in all reporting outputs.

ETL Development:

• Design and implement efficient ETL processes to collect, transform, integrate, and load data from various sources into the data warehouse.

• Develop and maintain ETL scripts and workflows using tools such as SSIS, Informatica, Talend, or similar platforms.

• Optimize and tune ETL performance to handle large volumes of data and ensure timely processing.

• Monitor and troubleshoot ETL processes to ensure data completeness and quality.

• Work with database administrators to ensure that the underlying data architecture is suitable for responsive BI solutions.

Data Management:

• Collaborate with data architects and data engineers to ensure alignment of BI and ETL solutions with the overall data strategy.

• Maintain metadata, documentation, and data dictionaries for BI and ETL processes.

• Implement best practices for data governance and ensure compliance with data security policies.

Collaboration & Communication:

• Work closely with business analysts, stakeholders, and IT teams to understand business objectives and provide data solutions that meet organizational needs.

• Communicate complex data findings in a clear and concise manner to non-technical stakeholders.

• Support end-users in understanding and using BI solutions effectively.

• Continuous Improvement:

• Stay updated with industry trends and advancements in BI and ETL technologies.

• Identify opportunities for process improvement and contribute to initiatives that enhance data capabilities.
• Other duties as assigned.

Job Requirements (Education/Skills/Experience):

• Must be a US citizen with an active Secret clearance or ability to Secret obtain.
• Bachelor's Degree or equivalent.
• 5+ years of experience working with large scale applications

• 5+ years of experience working with Talend

• 5+ years of experience in development using SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services)

• 5+ years of creating SQL Queries, and stored procedures

• 3+ years of Tableau reports development

• Experience with data cleansing and data quality processes

• Experience in creating complex drill through reports

• Ability to scope, plan, prioritize and manage multiple tasks and projects

• Experience in developing stored procedures, triggers using Transact SQL (T-SQL), PLSQL, ANSI SQL, PosGresSQL

• Familiar with usability design principles

• Experience with automated testing for both functionality and performance

• Proficient in SQL and reading explain plans to tune SQL statements

• Excellent communication skills both written and verbal.

 

Desired Qualifications:

• Knowledge of data warehouse/ETL design and development methodologies

• Experience designing, documenting ETL and performance tuning

• Experience SOA principles and implementation methodologies

• Experience with software development using .NET, C#, JavaScript

• Experience with web services, WSDL, Simple Object Access Protocol (SOAP), XML, XSD, AJAX, and JavaScript

• Experience in report development which include, dashboard, scorecards, using BI tools such as Tableau, SSRS, Qlik View. 

Diné Development Corporation (DDC) is a Navajo Nation owned family of companies that delivers IT, professional, and environmental solutions to advance the missions of federal, state, and tribal government agencies. As thought leaders and innovators, our team of specialists build client-centric solutions that solve critical challenges faced by defense, civilian, and healthcare organizations. Employing a mission-focused approach, we deliver value that not only enhances current operations, but also drives future change. Closely aligned with this approach is our commitment to advancing the Navajo Nation and its People. Through economic development and community empowerment, we elevate the Navajo Nation to provide lasting impact and sustainable growth for future generations. DDC's ability to unite legacy-inspired technologies, industry best practices, and proven methodologies has contributed to our success for twenty years.

This contractor and subcontractor shall abide by the requirements of 41 CFR 60-1.4(a), 60-300.5(a) and 60-741.5(a). These regulations prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities, and prohibit discrimination against all individuals based on their race, color, religion, sex, sexual orientation, gender identity, national origin, or for inquiring about, discussing, or disclosing information about compensation, or any other basis prohibited by law. We participate in E-Verify.