Lead various analysis and programming initiatives in Cornerstone Research’s Software Engineering department
Design, develop, and maintain advanced reporting solutions using Microsoft Power BI, SQL Server, Data Warehouse and upcoming BI technologies
Collaborate with cross-functional teams to deliver data-driven insights that support strategic decision-making
Influence department processes, procedures, and strategy while driving employee development
Optimize data models and DAX queries for performance and usability
Ensure data accuracy, consistency, and compliance with governance standards
Document report logic, data flows, and provides user support as needed
Maintain data integration between systems, creating automated data feeds, and structuring data for use by the data warehouse

Requirements

8+ years of experience in IT or financial systems reporting
8+ years of experience with SQL and T-SQL programming
5+ years of experience working with Aderant and related applications
3+ years of experience in Power BI development and administration
5+ years of experience with Datawarehouse technologies
3+ years of experience working with and translating company financial data into executive-level reports and KPIs
Advanced MS Office skills - especially Excel, including macro development and troubleshooting
Excellent problem-solving skills and techniques
Ability to identify opportunities and propose solutions
Thorough understanding of complex data models for Financial and related business systems along with underlying associated processes
Strong understanding of relational database structures, advanced data concepts, theories, principles, and practices
Excellent communication and interpersonal skills with demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the firm
Bachelor’s degree in computer science or related field, or equivalent combination of education, skills, and experience
Professional credential or certification in a relevant field.

Benefits

flexible options for healthcare
paid time off
retirement savings
annual performance bonus

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLT-SQLPower BIData WarehouseDAXExcelmacro developmentdata modelingdata integrationreporting solutions

Soft Skills

problem-solvingcommunicationinterpersonal skillscollaborationinfluencingemployee developmentanalytical thinkingstrategic decision-makingopportunity identificationsolution proposal

Certifications

Bachelor’s degree in computer scienceprofessional credential in relevant field