Business Intelligence Developer

The Business Intelligence (BI) Developer plays a critical role in transforming data into actionable insights that support strategic decision-making across the organization. This role is responsible for designing, developing, and maintaining BI solutions – including dashboards, reports, and data models – that enable stakeholders to understand performance, identify trends, and uncover opportunities for improvement. The BI Developer collaborates closely with business stakeholders, data engineers, and IT project teams to ensure data accuracy, accessibility, and relevance, driving a data-informed culture throughout the enterprise.

Key Responsibilities

·         Design, develop, and maintain interactive dashboards, reports, visualizations, and data models using BI tools and technologies (e.g., Power BI, Tableau, Power Automate, Power Query M, DAX)

·         Translate business requirements into technical specifications and BI solutions

·         Build and optimize data models to support reporting and analytics needs

·         Develop ETL (Extract, Transform, Load) processes to integrate data from multiple sources

·         Partner with business stakeholders to understand business needs, deliver actionable insights, triage issues, and ensure data governance and performance

·         Support the migration of enterprise reporting from on-prem SQL Server to Microsoft Fabric and Azure Data Lake environments

·         Collaborate with data engineers to reverse-engineer legacy ETL/reporting pipelines and modernize them for cloud-based delivery

·         Define data integration strategies, including real-time data integration, batch processing, and data replication to meet business needs

·         Assist with the creation and maintenance of Fabric Dataflows, Pipelines, and semantic models

·         Analyze structured schema modules and build scalable, reusable reporting solutions aligned to business needs

·         Monitor and troubleshoot BI systems to ensure performance and reliability

·         Maintain documentation for BI solutions, data models, and reporting processes

·         Conduct data analysis to identify trends, patterns, and opportunities for improvement

·         Support data governance and compliance initiatives by implementing best practices in data management

·         Architect field and object level security in reports

·         Provide training and support to end-users on BI tools and reporting capabilities

·         Stay current with BI technologies and trends to continuously improve solutions and processes

While the job description describes what is anticipated as the requirements of the position, the job requirements are subject to change based upon any changing needs and requirements of the business.

Required Skills

·         Proficiency in BI tools such as Tableau and Power BI, including: Power Query M, DAX, Power Automate

·         Strong SQL skills and experience in relational databases (e.g., SQL Server, Oracle, MySQL) and ETL workflows (e.g., SSIS, ADF, Dataflows Gen2)

·         Expertise in data modeling, report design, performance optimization, and self-service enablement

·         Experience with data warehouse and data lake environments

·         Familiarity or working knowledge of Microsoft Fabric (including Warehouse, Lakehouse, OneLake concepts)

·         Familiarity with Azure Data Lake, Synapse, and Snowflake technologies

·         Ability to translate business requirements into scalable technical solutions

·         Understanding of data governance, data quality, and security best practices

·         Detail-oriented with a strong focus on data quality, consistency, and reliability

·         Strong analytical, problem-solving, and troubleshooting skills

·         Excellent communication and collaboration skills to work effectively across cross-functional teams

·         Comfortable working independently and in a fast-paced, team-oriented environment

·         Experience with scripting languages (e.g., Python, R) and Agile or Scrum methodologies

Required Experience

·         Bachelor’s degree in Computer Science, Software Engineering or related field.

·         5+ years of experience in BI/reporting roles with a strong back-end focus

Tungsten Automation Corporation, Inc. is an Equal Opportunity Employer M/F/Disability/Vets

·         Proficiency in BI tools such as Tableau and Power BI, including: Power Query M, DAX, Power Automate

·         Strong SQL skills and experience in relational databases (e.g., SQL Server, Oracle, MySQL) and ETL workflows (e.g., SSIS, ADF, Dataflows Gen2)

·         Expertise in data modeling, report design, performance optimization, and self-service enablement

·         Experience with data warehouse and data lake environments

·         Familiarity or working knowledge of Microsoft Fabric (including Warehouse, Lakehouse, OneLake concepts)

·         Familiarity with Azure Data Lake, Synapse, and Snowflake technologies

·         Ability to translate business requirements into scalable technical solutions

·         Understanding of data governance, data quality, and security best practices

·         Detail-oriented with a strong focus on data quality, consistency, and reliability

·         Strong analytical, problem-solving, and troubleshooting skills

·         Excellent communication and collaboration skills to work effectively across cross-functional teams

·         Comfortable working independently and in a fast-paced, team-oriented environment

·         Experience with scripting languages (e.g., Python, R) and Agile or Scrum methodologies

---