BI and Data Analytics Engineer

Authentica Solutions; Baltimore (MD); Remote; USD 70,000 - 110,000; Full time

Job summary

Join a forward-thinking EdTech company as a BI & Data Analytics Engineer, where you'll transform education through data-driven solutions. In this role, you will design and develop complex Power BI dashboards, optimize data models, and enhance our data infrastructure. Collaborate with cross-functional teams to drive data-informed decision-making and empower educators and institutions with actionable insights. This innovative firm values curiosity and teamwork, offering remote flexibility and opportunities for professional growth. Make a global impact while advancing your career in a dynamic environment focused on revolutionizing education through technology.

Benefits

Remote Flexibility

Professional Growth Opportunities

Collaborative Culture

Impact-Driven Work

Qualifications

• 5+ years of experience in data analytics and Power BI development.
• Strong proficiency in SQL and ETL processes for data integration.

Responsibilities

• Design and optimize Power BI dashboards and analytics solutions.
• Collaborate with teams to build scalable data models and streamline ETL.

Skills

Data Analytics

Business Intelligence

Power BI Development

SQL

ETL Processes

Data Modeling

DAX

Data Visualization

Education

Bachelor's Degree in Data Science or related field

Tools

Power BI

Azure DataLake

Google BigQuery

Azure Data Factory

Databricks

Job description

BI and Data Analytics Engineer

Job Level: Mid-to-Senior
Location: Remote
Job Type: Full-time

About Authentica Solutions

At Authentica Solutions, we are on a mission to transform the education sector through cutting-edge technology and data-driven innovation. As a leading EdTech company, we provide powerful solutions that empower educators, students, and institutions by delivering seamless data interoperability and actionable insights.

Our Education Intelligence Platform leverages IPaaS (Integration Platform as a Service), advanced data transformation, privacy-compliant data lakes, and AI-driven analytics to tackle the most complex challenges in education. We are looking for a BI & Data Analytics Engineer to play a key role in building scalable analytics solutions, enhancing our data infrastructure, and driving data-informed decision-making for our partners.

Our Customers:

At the core of our vision is a commitment to redefining education technology, turning traditional middleware into miracle-ware. Our platform is designed to be powerful, intuitive, and scalable, enabling seamless data integration, transformation, and reporting for:
EdTech providers
System integrators & resellers
Consulting & strategic partners
K-12 school districts & higher education institutions
Government agencies & education ministries

By designing a self-service, future-ready data platform, we are not just solving today’s challenges, we’re anticipating future needs, unlocking new insights, and accelerating innovation across the education sector. Our third party-first approach ensures our solutions are built with speed, simplicity, and reliability, empowering partners to serve their customers faster and drive meaningful impact.

What You’ll Do (Key Responsibilities)

As a BI & Data Analytics Engineer, you will be responsible for designing, developing, and optimizing complex Power BI dashboards and analytics solutions to deliver actionable insights. You will collaborate with cross-functional teams to build scalable data models, streamline ETL processes, and ensure high-quality reporting solutions that drive strategic decision-making.

Power BI Development:

• Design, develop, and maintain interactive dashboards and reports using Power BI.
• Create advanced DAX calculations, measures, and KPIs to support complex business logic.
• Optimize Power BI performance, ensuring fast data refresh, efficient query execution, and seamless user experience.
• Develop custom visualizations and interactive storytelling elements to communicate insights effectively.

Data Modeling & ETL:

• Design and maintain efficient data models in Power BI, SQL, and data warehouses.
• Develop ETL pipelines to integrate, cleanse, and transform data from multiple sources (databases, APIs, cloud platforms).
• Ensure data accuracy, consistency, and compliance with education-sector privacy regulations.

SQL & Data Engineering:

• Write and optimize complex SQL queries for data extraction, transformation, and reporting.
• Work with modern data warehouses (e.g., Azure DataLake, DataBricks or Google BigQuery)to build scalable, structured data solutions.
• Collaborate with data engineers to develop high-performance data pipelines.

Business Intelligence & Reporting:

• Partner with stakeholders to gather business requirements and translate them into technical BI solutions.
• Develop self-service BI tools that empower users to make data-driven decisions.
• Conduct data validation and QA to ensure reports and analytics meet business needs.

Process Improvement & Documentation:

• Establish and implement best practices for Power BI development, governance, and deployment.
• Maintain thorough documentation for data models, processes, and reports.
• Train and support business users on BI best practices.

Who You are (About You)

We’re looking for someone who thrives in a fast-paced, high-impact environment, has a growth mindset, and is passionate about leveraging data to drive innovation in education.

• You love solving complex data challenges and enjoy building scalable analytics solutions.
• You believe success is a team effort, and you actively contribute to shared goals.
• You’re naturally curious, always learning, and unafraid of tackling new challenges.
• You’re a strong communicator, able to translate technical insights into business impact.

What You Need (Required Skills and Experience)

• 5+ years of experience in data analytics, business intelligence, or Power BI development.
• Expertise in Power BI, including Power Query (M language), DAX, and data visualization techniques.
• Strong proficiency in SQL for querying and data transformation.
• Experience with ETL tools and data integration methodologies.
• Knowledge of data modeling concepts, including star schema, fact/dimension tables.
• Familiarity with cloud-based data platforms (Azure, Google Cloud, etc.).
• Ability to analyze complex business requirements and convert them into data-driven solutions.
• Excellent problem-solving skills and ability to work independently.

Bonus Skills (Nice to Have, but Not Required)

• Experience with Azure Data Factory, Synapse Analytics, Snowflake, or Databricks.
• Familiarity of Python or R for advanced analytics.
• Familiarity with CI/CD pipelines for Power BI deployment.
• Familiarity using DeltaShare standard
• Exposure to AI/ML-driven analytics and automation.
• Previous experience working in education preferred.

Why Join Authentica Solutions?

Impact-Driven Work – Be part of a team revolutionizing data in education.
Remote Flexibility – Work from anywhere while making a global impact.
Professional Growth – Learn from industry experts and innovative thinkers.
Collaborative Culture – Join a team that values curiosity, teamwork, and innovation.

Authentica Solutions is an Equal Opportunity Employer

Authentica Solutions is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, national origin, genetics, disability, age, or veteran status. We provide a workplace free from discrimination and harassment, and where employees are treated with respect and dignity. Our employment decisions are based on business needs, job requirements, and individual qualifications.

We encourage candidates from all backgrounds to apply, as we believe a diverse workforce brings a variety of ideas, perspectives, and experiences that enhance our ability to meet the needs of our customers and drive innovation.

Applicants must be authorized to work for any employer in the United States. We are unable to provide sponsorship or assume responsibility for employment Visa sponsorship.