Senior Software Engineer
Data Engineering & Reporting
Company Overview
Alvaka has been a recognized innovator of top-tier IT solutions for over 40 years. We have extensive experience in leading technologies and advanced techniques in the architecture, implementation, and management of IT systems and automation. We are absolutely committed to delivering the finest customer service. Alvaka is growing rapidly, and we need experienced software professionals to help us continue that growth. Above all, we are looking for team players who are committed to being the best in the business.
Position Summary
We are hiring a Software Engineer focused first on Power BI reporting and data modeling, supported by SQL Server and ETL pipelines, and developing internal tools, automation, scripting, and integrations that improve operational efficiency and service delivery. This role is primarily back-office engineering (not customer-facing product). You will partner with operations, service delivery, and engineering teams to design scalable, secure, and maintainable data and integration solutions.
In addition to strong technical aptitude backed by hands-on experience, this person should be:
- a powerful communicator who engages effectively with internal teams and stakeholders;
- a strategic thinker who can assess business needs and create a roadmap to meet near, mid, and long-term goals;
- prompt and professional, with a commitment to delivering high-quality solutions on time;
- skilled at conducting project briefings and delivering comprehensive solutions;
- able to execute with a high degree of success in designing and implementing automation solutions in challenging environments.
The more capable an engineer is in the above areas, the more successful they will be.
Key Responsibilities
- Design Power BI data models, dashboards, and automated reporting (including DAX optimization).
- Establish and document data modeling standards (naming, schema design, lineage basics).
- Build and maintain ETL workflows (SQL Agent + PowerShell + T-SQL + REST API) for data transformation and movement across internal systems.
- Optimize SQL databases (indexing, performance tuning, data modeling best practices).
- Develop automation scripts and tools using PowerShell (including scheduled SQL Agent job orchestration), MS SQL Server, and .NET.
- Create and maintain API integrations (internal and third-party platforms).
- Utilize GitHub for version control and collaborative development.
- Collaborate with internal operations and service teams to identify data and automation opportunities.
- Apply security best practices across all deliverables.
- Operate within a Microsoft ecosystem (Azure, Microsoft 365, Windows Server).
Minumum Qualifications
- Bachelor’s degree or equivalent practical experience
- Proficiency in Power BI (data modeling, DAX, dashboards)
- 3+ years administering and querying MS SQL Server (T-SQL, indexing, performance basics)
- 3+ years building ETL workflows (SQL Agent jobs, PowerShell scripts, SSIS, or equivalent tooling)
- 2+ years building API integrations and using Git-based version control
- PowerShell scripting for ETL orchestration (SQL Agent + REST API ingestion)
- Familiarity with .NET Framework and an OOP language (e.g., C#)
- Strong analytical and problem-solving ability
- Effective communication and collaboration skills
Preferred Qualifications
- 1+ year in a leadership or mentoring capacity
- Experience with Microsoft 365 services (SharePoint, Teams, Excel)
- Experience automating workflows in service-based organizations
- Knowledge of networking and cybersecurity fundamentals
Salary and Benefits
- Salary: $110,000 - $150,000 annually
- Benefits: 401(k) with matching, dental and health insurance, life insurance, paid time off
- Supplemental Pay: Bonus pay
Work Schedule
- Full-time, 8-hour shifts
- On-call and weekend availability may be required
- Preference for candidates local to Irvine, CA; Remote is possible
Equal Opportunity Statement
Alvaka is an equal opportunity employer. We encourage applicants from all backgrounds to apply.
Job Type: Full-time
Pay: $110,000.00 - $150,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Health insurance
Application Question(s):
- Add your LI profile url to the application by adding to the message to recruiter.
Experience:
- administering and querying MS SQL Server: 3 years (Required)
- building ETL workflows: 3 years (Required)
- Power BI: 1 year (Required)
- .NET: 1 year (Required)
Work Location: Remote
