Capitol · 10 hours ago
Business Intelligence Developer
Austin, TX
Full-time
Hybrid
Mid Level
3+ years expCapitol Services is a leading provider of services to legal and financial professionals nationwide, seeking a Business Intelligence Developer to join their team. The role involves developing and maintaining Power BI reports and dashboards, collaborating with stakeholders to gather reporting requirements, and ensuring data accuracy and efficiency.
ApparelE-CommerceFashionJewelry
No H1B
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
Qualification
Required
You are eligible to work in the U.S. without sponsorship and reside in Austin, TX. C2C will not be considered
You have a Bachelor's 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
You have excellent organizational and time management skills
You have excellent attention to detail and exhibit a reasonable sense of urgency
You have the ability to think analytically, using principles of research to synthesize information from various sources
You have excellent verbal and written communication skills
You have a strong ability to communicate data-driven insights to non-technical audiences
You communicate in both a professional and friendly manner with coworkers and stakeholders
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
You demonstrate a positive customer service attitude
You are courteous and polite, especially when navigating through difficult conversations, problems, or complaints that may arise
You are able to work in both a team and independent setting within specified time constraints
You maintain a spirit of flexibility and adaptability with coworkers
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
You are able to remain in a stationary position 75% of the time and work on a computer for prolonged periods
Preferred
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
Benefits
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
Company
Capitol
Laura Vinroot Poole is fashion retail’s entrepreneurial rule-breaker.
11-50 employees
Funding
Current Stage
Early StageLeadership Team
Katherine Fitzgerald Kenney
Chief Operating Officer
Company data provided by crunchbase