Business Intelligence Developer

Capitol Services•Austin, TX

20h•Hybrid

About The Position

Capitol Services is currently seeking a Business Intelligence Developer to join our growing team! Capitol Services was founded in 1978 and has become a leading provider of services to legal and financial professionals nationwide. Our mission is to provide friendly, high-value, and superior service to our clients amid a collaborative atmosphere that encourages a balanced work-life experience for our employees. Named one of the "Best Places to Work" by the Austin American-Statesman, we know that it takes the right mix of passion, dedication, and fun to make a well-rounded workplace. Joining the Capitol Services team means working with a best-in-class, passionate team of professionals that truly cares about the work we do and the people we do it for. If that sounds like an environment you'd like to be a part of, we'd love to talk to you! Capitol Services is an equal opportunity employer. About the role: You will be working in our Austin, TX location responsible for developing and maintaining Power BI reports and dashboards that provide key business insights. This role works closely with stakeholders across departments to gather reporting requirements and KPI definitions, design and build effective data visualizations, and ensure the accuracy and efficiency of data extraction and reporting processes, including the development of reusable semantic models. The BI Developer must have strong analytical skills, a solid understanding of databases, and expertise in BI tools to transform raw data into meaningful insights. This role is a permanent position that involves working full-time and follows a hybrid schedule, Monday through Friday.

Requirements

You are eligible to work in the U.S. without sponsorship and reside in Austin, TX . C2C will not be considered.
You have a Bachelors degree in Business, Information Systems, Computer Science, or equivalent experience.
You have 3+ years experience in business intelligence, analytics, or data-focused roles.
You have strong proficiency in SQL Server (T-SQL) and hands-on experience with Power BI, including data modeling and DAX.
You have experience working with data warehouses and centralized BI datasets.
You have experience with Power Query (M) for data transformation.
You have advanced Microsoft Excel skills for reporting and analytics.
Excellent organizational and time management skills: You have the ability to organize, track, and prioritize a variety of projects and assignments under deadline. You have excellent attention to detail and exhibit a reasonable sense of urgency. You have the ability think analytically, using principles of research to synthesize information from various sources.
Excellent communication skills: You have excellent verbal and written communication skills. You have strong ability to communicate data-driven insights to non-technical audiences. You communicate in both a professional and friendly manner with coworker and stakeholders.
Adaptable: You can adapt to evolving business needs and changing priorities. You demonstrate resourcefulness and have the ability to self-motivate and proactively solve problems in complex and nuanced situations. You use research tools and databases with proficiency.
Positive attitude: You demonstrate a positive customer service attitude. You are courteous and polite, especially when navigating through difficult conversations, problems, or complaints that may arise.
Exceptional team player: You are able to work in both a team and independent setting within specified time constraints. You maintain a spirt of flexibility and adaptability with coworkers.
Reliable: You are able to work during our regular business hours in our Austin location. You are a punctual individual and able to follow an assigned work schedule. You are able to maintain client confidentiality at all times.
Office environment: You are able to remain in a stationary position 75% of the time and work on a computer for prolonged periods.

Nice To Haves

You have worked in a results-driven environment.
You have experience supporting finance, operations, sales, or executive reporting.
You are certified in Power BI and SQL.
You are familiar with SSRS.

Responsibilities

Collaborate with stakeholders to define KPIs and ensure consistent metric definitions across reports and dashboards
Design, develop, and maintain BI reports and dashboards using Power BI (primary visualization tool)
Extract, clean, and transform data from various sources (databases, APIs, data warehouses) to prepare datasets for reporting
Work with business units to understand their reporting needs and translate those into technical requirements for BI solutions
Write and optimize SQL queries to retrieve and manipulate data from relational databases for reporting purposes
Analyze and interpret complex datasets to identify trends, patterns, and opportunities for business growth and improvement
Ensure BI reports and dashboards are optimized for performance, accuracy, and clarity.
Identify opportunities for automation and efficiency
Document data models, data sources, and report generation processes for internal knowledge sharing and future reference
Conduct thorough testing and validation of BI reports and dashboards to ensure data accuracy and reliability before release
Provide training to end-users on how to access, interpret, and use BI reports.
Offer ongoing support for any BI-related issues or queries
Create dimensional and relational data models using Power BI data modeling and SQL Server Management Studio, with Azure Data Factory used for data ingestion when applicable
Implement and maintain Row-Level Security (RLS) and other data governance settings within Power BI

Benefits

A competitive base salary
3 medical plans to choose from including a 100% employer-paid option for the employee
100% employer-paid dental and vision benefits for the employee
401(k) with scheduled employer contribution
Employer-paid employee assistance program, as well as life and long-term disability insurance
4 weeks of paid time off annually, which begins accruing upon hire, and 10 paid holidays
Encouraged work-life balance including a hybrid working model after 90 days onsite.
Work from home equipment provided following successful training
Access to building fitness center
Office team events and learning development opportunities