data modeler San Juan, PR
Job description
HORNE is a professional services firm founded on a cornerstone of public accounting. As a top 25 business advisory firm, our 2,000+ team members serve clients from offices and project locations across the nation and Puerto Rico. Our Government Services practice is at the forefront of economic recovery programs nationwide with one of the most experienced and innovative teams anywhere. Our team provides program and project management, compliance, grant management, subject matter expertise and disaster recovery solutions needed to help government agencies affect positive change.
Primary Duties & Responsibilities:
- Design, develop, implement and maintain reporting solutions
- Utilize reporting software (Power BI, Tableau, etc.) to automate and standardize report delivery tailored to the client’s needs
- Anticipate program reporting needs and collaborate with our systems design team
- Ensure data quality and integrity in databases
- Work with program managers to identify team training needs or process improvements that will improve reporting reliability and accuracy
- Create complex functions, scripts, stored procedures and triggers to support reporting development and maintenance
- Evaluate existing reporting solutions, collaborate with program managers and partners, implement improvements
- Troubleshoot reporting accuracy or completeness issues
- Work with appropriate urgency and an attention to detail
- Work with the team to deliver world-class work on time and within budget
- Continuously enhance your skills and ultimately our capabilities through professional development, skills learning, and self-instruction
Work Complexity:
- Custom development of reporting solutions for complex disaster recovery programs including housing recovery operations, infrastructure rebuilding programs, economic development programs, financial management and oversight programs, and monitoring programs
- Install, configure, and integrate solutions into the customer environment
- Work on multiple, small to large projects as a team member, or independently on small projects
- Work within aggressive timelines to deliver accurate and impactful reporting solutions
- Work may require limited travel
Qualifications and Requirements:
- Bachelor’s degree
- Good understanding of data and schema standards and concepts
- Experience with SQL Server
- Critical thinking and problem-solving skills
- Substantial Experience with Power BI (Desktop Development Tool)
- Experience with Power BI Web Services
- Experience with DAX (Data Analysis Expression) Language
- Intermediate Excel
Bonus:
- Knowledge of MS SQL programming with the ability to design and implement complex reporting solutions
- Experience with Microsoft Power Apps, Power Automate Web Services
- Experience with cloud computing environments such as Azure, AWS or Google Cloud
HORNE Values…
- A forward thinking, anticipatory professional driven by a passion to pursue your full potential and dreams.
- A work environment that promotes collaboration, consistency, and community service to empower people.
- An inclusive culture that promotes career/life integration and invests in developing people in areas of focused expertise.
HORNE Offers…
- An unrivaled distinctive, special culture that values collaboration, innovation, and positive energy which HORNE calls “Deliver with Care.”
- A team of professionals grounded in strong, personal relationships and a sense of belonging to a common purpose for adding value and making a difference.
- A dedicated team of individuals from diverse backgrounds working together to leave our clients better than we found them.
- “Fearless Unrivaled Flexibility” – It’s about results, not the hours you work.
The firm you’ll be joining is a decidedly different business advisory firm. HORNE goes beyond traditional accounting to collaborate, advise, and align with clients to transform rapid change and uncertainties into opportunities for growth and profitability.
We are a team that focuses on reaching our full potential, rewards high performance, and prioritizes leadership development for every team member. HORNE emphasizes health and personal development through our multiple wellness programs, and we pride ourselves on offering "unrivaled flexibility". Despite our size, HORNE takes time to recognize, support, and celebrate one another's successes, working together for the highest good. Come join us at team HORNE!
Job Type: Full-time
Benefits:
- 401(k)
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Vision insurance
Schedule:
- 8 hour shift
Work Location: In person
