Job Overview:
Pay Range $47hr - $52hr
Requirement/Must Have:
- Bachelor's degree in computer science, Information Systems, or other related fields, or equivalent work experience.
- Required minimum of 5+ years of IT work experience in business intelligence tools and systems.
- A minimum of 3 to 5 years of hands-on experience developing enterprise-level analytical reports, dashboards, and data models using Microsoft Power BI, including advanced report design, paginated reports, performance tuning, and DAX.
- Advanced SQL query writing includes CTEs, window functions, and analytical queries with optimization.
- Strong understanding of star schema design and fact/dimension modeling.
- Proficient in Snowflake tuning, clustering keys, compute optimization, and cost control.
- Familiarity with Snowflake RBAC, roles, warehouse sizing, and data governance.
- Proficient in building Power BI semantic models with strong DAX and clean dimensional design.
- Experience in integrating Power BI with Snowflake and connection modes.
- Proficiency in Power BI Report Builder, workspace management, and performance optimization.
- Experience with metadata management, data lineage, and documentation.
- Experience embedding Power BI reports into web or internal applications.
- Knowledge of CI/CD for Power BI and version control is a plus.
Responsibilities:
- Design and develop Power BI dataflows and semantic models using dimensional modeling practices.
- Build advanced DAX measures and analytical logic to support enterprise-grade end-user reporting.
- Create user-friendly, high-performance Power BI reports and dashboards that meet defined business requirements.
- Write and optimize complex SQL queries (CTEs, window functions, analytical queries) to retrieve and prepare Snowflake data for reporting.
- Collaborate with Snowflake data engineering teams to ensure fact/dimension tables are structured and optimized for Power BI consumption.
- Integrate Power BI with Snowflake using appropriate connection modes, ensuring performance, query folding, and data reliability.
- Document data lineage, metadata, and report specifications to support maintainability, governance, and transparency across analytics assets.
Skills:
- Knowledge of dimensional modeling and star schema design for semantic model development.
- Knowledge of advanced Power BI capabilities including DAX, data modeling, and Power Query.
- Knowledge of Snowflake performance tuning, compute optimization, and RBAC security concepts.
- Skill in building optimized, scalable Power BI semantic models using strong dimensional design.
- Skill in writing advanced SQL queries and tuning Snowflake datasets for Power BI consumption.
- Skill in creating high-performance Power BI reports with clean DAX logic and intuitive visual design.
- Ability to translate business requirements into structured semantic models and actionable reports.
- Ability to troubleshoot performance issues across DAX, SQL, and Snowflake compute layers.
- Ability to collaborate effectively with data engineers, SMEs, and stakeholders to deliver enterprise-ready reporting solutions.
Benefits
Our Benefits Include:
- Medical, Dental, and Vision Insurance
- 401(k) Retirement Plan
- Health Savings Account (HSA)
- Disability Insurance (Short-Term and Long-Term)
- Life and AD&D Insurance
- Paid Sick Leave (where required by applicable state or local law)
- Supplemental Insurance Plans
- Identity Theft Protection
- Pet Insurance
- Employee Wellness Programs
- Employee Assistance Program (EAP)
- Career Growth and Professional Development Opportunities
Disclaimer: Benefits eligibility, accrual rates, and usage limits may vary based on employment status, length of service, and work location. Paid Sick Leave is provided in strict accordance with applicable state and municipal mandates. Cynet Systems Inc. reserves the right to modify, amend, or terminate any benefit plans at any time in accordance with applicable laws.
About Cynet Systems
Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading technology staffing and workforce solutions company serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada. We deliver agile, scalable talent solutions across IT, engineering, life sciences, clinical, and professional staffing, powered by a high-performing recruitment engine operating across North America and Asia.
As a nationally and locally certified Minority Business Enterprise (MBE), Cynet Systems is committed to helping organizations build high-performing teams while empowering professionals to grow rewarding careers. Our organization is certified to ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II standards, reflecting our commitment to quality, security, operational excellence, and customer success.