[Remote] Architect - BI & Analytics at 3cloud

United States

3cloud Logo
Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Business Intelligence, AnalyticsIndustries

Requirements

  • Bachelor’s degree in computer, engineering, data science or a related field; or equivalent work experience
  • 5+ years working with data and business intelligence solutions on the Microsoft tool stack for Business Intelligence (SSRS, Power BI, or PowerPivot (Excel) or PerformancePoint), or other vendor Business Intelligence tools (Business Objects, MicroStrategy, Qlik, SAP)
  • Deploying cloud-based solutions using Microsoft Azure data services including Azure Data Factory, Azure Data Lake, and Azure SQL DB
  • Power BI tenant and workspace management to support development, testing and deployment
  • Experience with analytics and custom visualizations for Power BI using Python, R
  • Expertise of TSQL, data modeling, reporting using Power BI or other Microsoft tools
  • Experience creating complete Power BI report solutions based on business questions with linked content, drilldowns, and nested parameters
  • Knowledge of data mashups and transformations using Power Query/M language
  • Ability to report visual choices and visual interactions
  • Ability to gather requirements and conduct focus groups to determine the processes needed to assist and grow the business
  • Experience leading technical teams and eager to contribute in a team-oriented environment
  • Excellent communication (written and oral) and interpersonal skills for both technical and nontechnical teams
  • Passionate about learning new technologies

Responsibilities

  • Conduct customer discovery meetings to determine reporting requirements
  • Understand and work with customers on Power BI Licensing, and understand the limits/advantages of each licensing platform
  • Create well-performing star schema data models for use with Power BI, including properly calculated columns and measures
  • Creating Power BI solutions for customers including importing data from multiple sources, building reports and dashboards, and creating appropriate data elements using DAX and source queries
  • Guide customers on deploying Power BI solutions to the Power BI service (Gateways, DirectQuery, DataFlows, Data Updates)
  • Estimate and plan work for large technical solutions
  • Develop Power BI governance solutions to support various forms of self-service Business Intelligence models for customers
  • Optimize tabular models and Power BI report performance
  • Experience deploying and designing Power BI solutions using Power BI Embedded
  • Develop relationships with clients to uncover future analytic needs
  • Design, develop and implement user interfaces to ensure ease of use and minimal knowledge by the functional work group that will be using the database

Skills

Key technologies and capabilities for this role

Power BIDAXStar SchemaData ModelingPower BI EmbeddedDirectQueryDataFlowsGatewaysTabular ModelsPower BI ServiceSQL

Questions & Answers

Common questions about this position

What experience level is required for this Architect - BI & Analytics role?

A Bachelor’s degree in computer, engineering, data science or a related field (or equivalent work experience) and 5+ years working with data and business intelligence solutions on the Microsoft tool stack are required.

What are the key technical skills needed for this position?

Key skills include expertise in Power BI (data modeling, DAX, reports, dashboards, tenant/workspace management), TSQL, data modeling, Microsoft Azure data services (Azure Data Factory, Data Lake, SQL DB), and analytics with Python or R.

What is the company culture like at 3Cloud?

3Cloud fosters a collaborative environment where teams tackle tough problems together, embrace experimentation and failure, provide candid feedback, and hold each other accountable to core values for collective growth and client success.

Is this a remote position or does it require office work?

This information is not specified in the job description.

What is the salary or compensation for this role?

This information is not specified in the job description.

What makes a strong candidate for this Architect role?

Strong candidates have 5+ years in BI solutions on Microsoft tools like Power BI and SSRS, experience with Azure data services, Power BI expertise including data modeling and DAX, plus the ability to build complete report solutions and manage deployments.

3cloud

Consulting firm optimizing Microsoft Azure usage

About 3cloud

3Cloud Solutions helps businesses improve their use of Microsoft Azure, a popular cloud computing platform. They provide consulting services tailored to each client's needs, offering best practices, insights, and hands-on support to help clients maximize Azure's capabilities. 3Cloud stands out from competitors by being a top Microsoft Azure partner, which gives them access to the latest information and resources from Microsoft. They also provide additional materials like eBooks and webinars to keep clients informed about cloud technology. The company's goal is to assist a variety of industries, including manufacturing and data analytics, in modernizing their technology infrastructure and enhancing operational efficiency.

Downers Grove, IllinoisHeadquarters
2016Year Founded
GROWTH_EQUITY_VCCompany Stage
Data & Analytics, Consulting, Enterprise SoftwareIndustries
501-1,000Employees

Benefits

Flexible Work Hours
Remote Work Options
401(k) Company Match
401(k) Retirement Plan
Unlimited Paid Time Off
Health Insurance
Vision Insurance
Dental Insurance
Life Insurance
Disability Insurance
Parental Leave
Health Savings Account/Flexible Spending Account
Home Office Stipend
Mental Health Support

Risks

Integration challenges with acquisitions like BlueGranite may lead to operational inefficiencies.
Rapid expansion strategy could strain resources and impact service quality.
Dependence on Microsoft Azure means any disruptions could affect operations and client satisfaction.

Differentiation

3Cloud is a top Microsoft Azure partner with deep expertise in Azure offerings.
The company offers a variety of resources like eBooks and webinars for client education.
3Cloud showcases successful client case studies to demonstrate business performance improvements.

Upsides

Acquisition of PGSI enhances global delivery capabilities for comprehensive Azure consulting services.
Winning 2023 Microsoft US Partner of the Year boosts 3Cloud's reputation and client attraction.
Partnership with Azure Databricks strengthens integrated data and AI solution offerings.

Land your dream remote job 3x faster with AI