Business Intelligence Developer

MINIMUM QUALIFICATIONS

Education

• Bachelor’s degree in Computer Science, Information Technology, Management Information Systems, Data Analytics, Business Analytics, Computer Engineering, or a closely related field from an accredited institution.

• An equivalent combination of relevant education, technical training, certifications, and professional experience may be considered where permitted by applicable contract requirements.

Experience

• Minimum of 3 years of professional experience in business intelligence, data analytics, reporting, database development, or a related technology function.

• Demonstrated experience developing enterprise dashboards and reports.

• Experience working with relational databases and SQL.

• Experience with data modeling, data transformation, and data visualization.

• Experience gathering business requirements and translating them into technical reporting or analytics solutions.

• Experience supporting production BI or enterprise reporting environments.

REQUIRED TECHNICAL SKILLS

Candidates should demonstrate proficiency in several of the following:

• Microsoft Power BI

• Power BI Desktop and Power BI Service

• DAX

• Power Query

• SQL

• Microsoft SQL Server or comparable relational databases

• Data modeling and dimensional modeling

• ETL/ELT processes

• Data visualization and dashboard development

• Report development and optimization

• Data validation and reconciliation

• Data warehouses and data marts

• Relational database concepts

• Data integration

• Role-based and row-level security

• Version-control and change-management practices

• Agile/Scrum development methodologies

  
  
  
  

  PREFERRED TECHNICAL EXPERIENCE

  Preference may be given to candidates with experience in:

• Microsoft Azure data and analytics technologies.

• Azure SQL Database.

• Azure Data Factory.

• Microsoft Fabric.

• Power BI administration and governance.

• SQL Server Integration Services (SSIS).

• SQL Server Reporting Services (SSRS).

• SQL Server Analysis Services (SSAS).

• Data warehouses, data lakes, and enterprise analytics platforms.

• APIs and application integrations.

• Python, R, or other data-analysis technologies.

• Enterprise Resource Planning (ERP) systems.

• Human Resources Information Systems (HRIS).

• Financial management systems.

• Student, learning, operational, or administrative information systems.

• Cloud-based data environments.

• Master data management and data governance.

• Public-sector, government, education, or other highly regulated environments.

• Microsoft Power BI, Azure, SQL, data analytics, or comparable industry certifications are preferred but not required unless specified for the assignment.

DATA QUALITY AND GOVERNANCE RESPONSIBILITIES

The Business Intelligence Developer will assist in maintaining the integrity and reliability of organizational data by:

• Applying established data-governance policies and standards.

• Validating data across multiple source systems.

• Identifying duplicate, incomplete, inconsistent, or inaccurate data.

• Documenting data definitions, calculations, transformations, and business rules.

• Supporting consistent definitions for key performance indicators and organizational metrics.

• Maintaining appropriate data lineage and source documentation.

• Ensuring reports and dashboards use authorized and validated data sources.

• Supporting data-quality monitoring and remediation efforts.

• Collaborating with stakeholders to resolve reporting and data discrepancies.

SECURITY AND CONFIDENTIALITY

The Business Intelligence Developer may work with sensitive, confidential, or protected organizational information and must:

• Maintain strict confidentiality of protected information.

• Follow applicable cybersecurity and information-security policies.

• Implement appropriate role-based access controls.

• Follow least-privilege access principles.

• Protect confidential data throughout extraction, transformation, reporting, storage, and distribution processes.

• Ensure sensitive information is not unnecessarily exposed through reports or dashboards.

• Comply with applicable federal, state, and local privacy and data-security requirements.

• Promptly report suspected security incidents, inappropriate access, or data exposure.

• The selected candidate may be required to successfully complete applicable background screening, fingerprinting, identity verification, and security requirements before receiving access to client systems, facilities, or confidential information.

KNOWLEDGE, SKILLS, AND ABILITIES

The successful candidate should possess:

• Strong analytical and problem-solving abilities.

• Advanced understanding of business intelligence and reporting concepts.

• Strong SQL and database-development skills.

• Knowledge of data modeling and relational database principles.

• Ability to analyze large and complex datasets.

• Ability to identify trends, discrepancies, patterns, and data-quality issues.

• Strong understanding of dashboard and data-visualization best practices.

• Ability to translate complex data into understandable information for business users and leadership.

• Ability to translate business requirements into technical specifications.

• Strong attention to accuracy and detail.

• Ability to manage multiple priorities and meet established deadlines.

• Strong written and verbal communication skills.

• Ability to document technical processes clearly.

• Ability to communicate effectively with both technical and nontechnical stakeholders.

• Ability to work independently and collaboratively within multidisciplinary project teams.

DELIVERABLES AND PERFORMANCE EXPECTATIONS

Depending on the assignment, deliverables may include:

• Power BI dashboards

• Executive and operational reports

• Data models

• SQL queries and stored procedures

• ETL/ELT processes

• Data-integration solutions

• KPI and performance scorecards

• Data-quality reports

• Technical design documentation

• Business and reporting requirements documentation

• Data dictionaries

• Data mapping and lineage documentation

• Testing scripts and results

• Deployment and release documentation

• User documentation and training materials

• Knowledge-transfer documentation

• All deliverables must meet applicable project requirements, technical standards, security requirements, acceptance criteria, documentation requirements, and established timelines.

  
  

PROFESSIONAL AND CONTRACT COMPLIANCE

Personnel assigned by Solero Workforce Solutions are expected to:

• Maintain professional conduct when interacting with clients, employees, contractors, vendors, and other stakeholders.

• Follow applicable client policies, procedures, security standards, and technology requirements.

• Maintain accurate project, time, task, and deliverable documentation when required.

• Protect client systems, equipment, credentials, data, and confidential information.

• Complete assigned deliverables within established timelines and quality standards.

• Immediately disclose potential conflicts of interest.

• Comply with applicable federal, state, and local laws and regulations.

• Meet applicable contractual and statement-of-work requirements.

EQUAL EMPLOYMENT OPPORTUNITY

Solero Workforce Solutions is an Equal Opportunity Employer. Employment decisions are based on qualifications, merit, business requirements, and applicable contractual requirements without unlawful discrimination based on race, color, religion, sex, pregnancy, national origin, age, disability, genetic information, veteran status, or any other status protected by applicable federal, state, or local law.

DISCLAIMER

This job description describes the general nature and level of work expected for this position. It is not intended to represent an exhaustive list of all duties, responsibilities, qualifications, or contractual requirements.

Specific qualifications, technologies, years of experience, certifications, work arrangements, background-screening requirements, deliverables, and technical requirements may vary based on the assigned project, statement of work, or contract.