Job Description
Our Client, a Credit Card company, is looking for a Senior Analyst, Advanced Analytics for their O'Fallon, MO/ New York city, NY/Hybrid location.
Responsibilities:
Requirements:
Why Should You Apply?
Responsibilities:
- Data Modeling & Semantic Models
- Design and implement scalable dimensional models and semantic models within Power BI and Microsoft Fabric.
- Structure complex datasets using fact and dimension modeling techniques using star and snowflake schema solutions.
- Analyze existing data structures and implement improvements for scalability, performance, and usability.
- Optimize model relationships and reporting performance.
- Microsoft Fabric & Data Engineering
- Build and maintain Fabric-based data solutions including dataflows, pipelines, lakehouses, warehouses, and semantic models.
- Develop notebooks using Python and SQL for data preparation and transformation.
- Integrate data from multiple source systems and prepare data for reporting and analytics consumption.
- Support data engineering activities required to enable Power BI reporting and analytics initiatives.
- DAX & Reporting
- Develop advanced DAX measures, calculations, and performance optimization strategies.
- Troubleshoot complex reporting and analytical requirements.
- Build and enhance executive and operational dashboards using Power BI.
- Support paginated reporting and Report Builder solutions where appropriate.
- Security & Distribution
- Implement row-level security and security group-based access controls.
- Support reporting distribution, user access, and data extraction requirements.
- Assist in establishing reporting access models within Power BI and Fabric.
Requirements:
- 5+ years of Power BI development experience.
- Advanced DAX expertise with demonstrated experience solving complex business requirements.
- Strong dimensional modeling experience including:
- Star Schema Design
- Snowflake Schema Design
- Fact & Dimension Modeling
- Complex Dimensions
- Semantic Model Design
- Performance Optimization
- Experience with Microsoft Fabric implementation and development.
- Experience developing notebooks using Python and SQL.
- Experience designing enterprise reporting and analytics solutions.
- Strong understanding of data integration and transformation patterns.
- Experience working with complex and highly related data structures.
- Ability to quickly understand existing data environments and contribute with minimal ramp-up time.
- Preferred Qualifications
- Experience migrating reporting assets to Power BI/Fabric.
- Databricks experience a plus.
- Experience with Report Builder and Paginated Reports.
- Experience implementing row-level security and security group-based access controls.
- Experience with Power BI Report Server environments.
Why Should You Apply?
- Health Benefits
- Referral Program
- Excellent growth and advancement opportunities
Numbers & Facts
| Location | O Fallon, MO |
| Industry | Management Consulting Services |
| Salary | $46.92–$51.40 Per Hour |
| Company Size | 2,000 to 2,499 employees |
| Year Founded | 2000 |
| Website | https://www.iconma.com/ |
Benefits
401K, Employee Referral Program, Life Insurance
About Company
ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.
- Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
- Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
- Founded in 2000
- 2000+ Employees
The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.
Skills
- Access Controlunmatched
- Analysis Skillsunmatched
- Credit Cardsunmatched
- Data Analysisunmatched
- Data Modelingunmatched
- Data Structuresunmatched
- Database Designunmatched
- Dimensional Modelingunmatched
- Health Planunmatched
- Identify Issuesunmatched
- Microsoft Product Familyunmatched
- Performance Analysisunmatched
- Performance Tuning/Optimizationunmatched
- Power BIunmatched
- Python Programming/Scripting Languageunmatched
- Reporting Dashboardsunmatched
- Requirements Managementunmatched
- SQL (Structured Query Language)unmatched
- Snowflake Schemaunmatched
- Star Schemaunmatched
- Training Data Setsunmatched
- Usability Engineeringunmatched
- Warehousingunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder