Analytics Engineer

Who We Are: 

Axis Residential is a forward-thinking, property management organization, part of Inland Group ­– a vertically integrated real estate developer, contractor, and operator of multifamily and senior housing communities. Collectively, we have set ourselves apart as an industry leader who genuinely cares for the well-being and success of our people while creating an environment of meaningful community for our residents. Our success is a result of our team and culture– we take a relational and entrepreneurial approach to business and our team members are authentic, curious, natural leaders who value the greater team. We love what we do, and we are committed to excellence in our work.

The Position:

The Analytics Engineer is responsible for designing, building, and maintaining the organization’s analytics and business intelligence solutions. This role bridges the gap between raw data and business decision-making by developing reliable semantic models, scalable Power BI dashboards, and actionable insights across multiple data platforms. The ideal candidate is equally comfortable working in Power BI, while also possessing strong analytical and communication skills. This role partners closely with business leaders, IT, and data stakeholders to ensure data is trusted, accessible, and meaningfully translated into insights that drive operational and strategic decisions.

Analytics & Business Intelligence

• Design, develop, and maintain Power BI dashboards and reports that provide clear, actionable insights to business stakeholders.
• Build and manage semantic data models optimized for analytics, performance, and self‑service reporting.
• Translate business questions and requirements into analytical solutions, KPIs, and metrics.
• Analyze trends, patterns, and anomalies in data and clearly articulate findings to technical and non‑technical audiences.

Data Modeling & Platform Integration

• Develop and maintain analytics solutions using Snowflake (Lakehouse, Warehouse, ETL/pipelines, semantic models, and related workloads).
• Integrate and analyze data from multiple sources, including Snowflake, line‑of‑business systems, and cloud platforms.
• Partner with other data engineers and system owners to ensure data structures support accurate and performant reporting.
• Optimize data models and queries for performance, scalability, and cost efficiency.

Governance, Quality & Standards

• Ensure consistency and accuracy of KPIs, metrics, and definitions across reports and dashboards.
• Implement data security practices such as row‑level security (RLS) and appropriate access controls.
• Document data models, reporting logic, and metric definitions to support transparency and maintainability.
• Support data governance and reporting standards across the organization.

Collaboration & Enablement

• Work closely with business stakeholders to understand reporting needs and drive data‑informed decision‑making.
• Quickly gain sufficient understanding of the business to recognize Analytics needs, gaps in solutions, & processes/stakeholders to involve – independent of significant support.
• Support and enable self‑service analytics while maintaining a trusted, centralized source of truth.
• Provide guidance and best practices for Power BI usage, dashboard design, and analytics workflows.
• Contribute to ongoing analytics and data platform improvements as the organization matures its data capabilities.
• Drive adoption of the reports you produce through trainings, relevance-iterations, & inserting reports into critical business decision processes.

Project Management & High-Quality Delivery:

• Own analytics initiatives from intake through delivery, including requirements prompting & clarification, effort estimation, sequencing work, and managing dependencies.
• Translate business questions into scoped, well‑defined analytical deliverables with clear criteria and metric definitions.
• Plan and execute work to meet agreed‑upon timelines while proactively identifying turnaround risks and tradeoffs.
• Maintain clear communication with stakeholders on progress, blockers, and changes in project plans.
• Estimate cost, effort, and complexity for analytics work to support capacity planning and prioritization.
• Design scalable, efficient data models and pipelines with awareness of compute, storage, and tooling costs.
• Consistently deliver analytics solutions on schedule and aligned to business expectations.
• Break large initiatives into phases or milestone‑based releases when appropriate.
• Apply validation, testing, and documentation practices to ensure deliverables are reliable and reusable.
• Incorporate stakeholder feedback recognizing and communicating anytime it may be jeopardizing timelines or data integrity.

Other Duties: This job profile is not intended to be an all-inclusive list of job duties and responsibilities, as one may be asked to perform additional tasks in order to meet the needs of the organization.

Required Qualifications

• 3+ years of experience in analytics, business intelligence, or analytics engineering.
• Strong past experience in at least 8 of these tools/languages/concepts:
• • Snowflake (Data Warehousing)
  • DBT (Data Transformations)
  • Azure Data Factory (Data Orchestration & Extraction)
  • Power BI (Data Visualization)
  • SQL (Data Transformations)
  • DAX (Data Transformations/Visualizations)
  • Kimball Data Modeling (Data Transformations)
  • Medallion Architecture (Data Transformations)
  • Automated Data Extraction (Sourcing from ODBC, APIs, Files, Connectors, etc)
  • Utilizing AI in Data Engineering & Analysis
• Strong hands‑on experience with Power BI, including but not limited to:
• • Data modeling, DAX, Power Query (M), Dashboard and report design.
• Experience working with Snowflake or modern analytics platforms.
• • Experience integrating and analyzing data from cloud data platforms such as Snowflake.
• Experience working with Azure Data Factory and/or Microsoft Fabric Data Factory.
• Strong SQL skills and solid understanding of relational and analytical data modeling concepts.
• Proven ability to analyze data and clearly communicate insights to business stakeholders.
• Must be a team player who takes a “we over me” approach to building and sustaining relationships with others.
• Strong documentation, organization, and communication skills; must be proficient in speaking, reading, and writing in English.
• High School diploma or equivalency certificate.
• Valid driver’s license and insured, operable vehicle.

Preferred Qualifications

• Experience with enterprise data warehouse or lakehouse architectures.
• Familiarity with Data Warehousing concepts such as Kimball and medallion architectures.
• Experience supporting self‑service BI in a governed enterprise environment.
• Certifications related to Power BI, Snowflake, and/or Azure Datafactory.
• Experience working with construction, real-estate, operations, finance, or project‑based data.
• Experience utilizing Fabric Data Agents and/or Snowflake Cortex.
• Experience in any of these: DBA roles, Snowflake time-travel, Virtual Machines/on-premise data, SQL Server, Workato, Yardi, and Salesforce.

Compensation and Benefits

• Competitive pay, $100,000 - $140,000 per year (based on experience).
• Annual bonus incentive.
• Annual performance review with potential merit increase.
• Medical, Dental, & Vision insurance - with 100% employer paid monthly premiums for associates.
• Flexible Spending Accounts- for healthcare and dependent care.
• Disability, AD&D, and Life insurance.
• 401(k) with 3% company contribution.
• Accrued vacation time, sick pay, 12 paid holidays per calendar year, personal day, and paid volunteer day.
• Employee Assistance Program.
• Charitable giving program and community involvement.

Physical Requirements:

• Sitting: 2-7 hours/day.
• Walking: 1-2 hours/day.
• Climbing (stairs): 1-3 hours/day.
• Lifting: 20-40 lbs. regularly.
• Endurance: light to moderate energy requirements.
• Manual Dexterity: frequent fine motor skills.
• Near Vision: minimal near vision.

Environmental and Safety Factors:

• Weather: work is primarily indoors in a temperature-controlled office environment with occasional exposure to outdoor weather conditions, including uneven and slippery surfaces.
• Noise: frequent exposure to typical office environment noise levels including conversational voice levels; infrequent exposure to high-volume office equipment (e.g., shredder).
• Pace of Work: great, multi-tasking/pressure paced environment.

Here at Axis Residential, we are committed to offering an inclusive and accessible experience for all job applicants and associates. We are proud to be an equal opportunity employer, and we do not discriminate against applicants or associates based on race, color, religion, creed, national origin, sex, sexual orientation, gender identity, age, disability, marital status, pregnancy, veteran status, or any other status protected by law. Applicants with disabilities may be entitled to reasonable accommodation for the job application and hiring process. If you need assistance completing this application due to a disability, please contact our Human Resources Department.