Business Intelligence Developer – SQL & Data Integration
About The Position
We are recruiting on behalf of a mission-driven public-sector organization seeking an experienced Business Intelligence Developer – SQL & Data Integration to join its data team. This role sits at the intersection of data, technology, business process improvement, reporting, and automation. It is ideal for someone who enjoys looking at a manual or inefficient process and asking, “How can we make this work better through data and technology?” You will work with data from existing systems and use SQL, Power BI, data integration, scripting, and automation to make information more connected, accurate, accessible, and useful across the organization. This is more technical than a traditional Data Analyst position, but it is not a traditional Database Administrator or Data Engineer role. Rather than building or administering the organization’s core source systems, you will work with available data, integrate information across systems, automate repetitive workflows, and create solutions that make day-to-day operations more efficient.
Requirements
- Approximately 5+ years of experience in database development, ETL, data integration, business intelligence, data engineering, or a related area.
- Intermediate-to-advanced SQL skills, including professional experience writing queries and working with relational databases.
- Experience developing complex queries and working with database tables, relationships, views, stored procedures, and data transformations.
- Strong Power BI experience, including data modeling, DAX, and Power Query.
- Experience with ETL and data integration processes.
- Experience using Python, PowerShell, or another scripting language for workflow or data automation.
- Strong understanding of data quality, accuracy, consistency, and integrity.
- Experience identifying inefficient processes and developing technical solutions to improve them.
- Strong Microsoft Excel skills.
- Familiarity with version-control tools such as Git.
- Strong organizational and project-management skills.
- Ability to manage multiple priorities in a changing environment.
- Strong written and verbal communication skills.
- Ability to explain technical concepts clearly to non-technical stakeholders.
- Strong problem-solving skills, initiative, and personal accountability.
- A bachelor’s degree in Computer Science, Data Engineering, or a related field is preferred. Equivalent professional experience may also be considered. The original role criteria call for a related bachelor’s degree or eight years of equivalent experience, along with at least five years of database development, ETL, or data-engineering experience.
Responsibilities
- Develop, write, and optimize SQL queries, views, stored procedures, and parameterized scripts to improve data access and operational workflows.
- Work with existing database structures and available back-end data to develop reliable, scalable solutions for internal users.
- Develop a strong understanding of existing systems, data structures, relationships, and dependencies.
- Integrate data from systems that do not naturally communicate with one another.
- Build and maintain Power BI dashboards, reports, data models, and visualizations that provide meaningful, actionable insights.
- Use advanced DAX and Power Query capabilities to transform and model data.
- Automate repetitive processes and workflows using tools such as Python, PowerShell, SQL, Power Query, or similar technologies.
- Replace manual Excel-, Word-, and click-intensive processes with more efficient, technology-driven solutions.
- Structure and prepare data so end users receive information in a usable format with minimal manual manipulation required.
- Identify and resolve data discrepancies to maintain accuracy, reliability, and data integrity.
- Evaluate existing business processes and identify opportunities to reduce unnecessary steps, manual effort, and duplication.
- Collaborate with internal stakeholders to translate business needs into practical technical solutions.
- Coordinate with external vendors regarding data transfers, integrations, security requirements, and technical issues.
- Evaluate emerging technologies and recommend improvements that support efficiency and scalability.
- Share best practices and technical knowledge with other members of the data team.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
