Data Solutions Engineer

The Data Solutions Engineer designs, builds, and operates reliable, scalable data pipelines on PowerSecure’s Azure data platform to enable trusted analytics and self‐service BI.

Requirements

• 2+ years of hands‐on data engineering (or comparable software engineering with significant data work)
• 2+ years building pipelines on Azure and Databricks (or equivalent cloud + Spark)
• Strong SQL (analytical queries, window functions), PySpark/Spark SQL, and data modeling fundamentals
• Proficiency with SQL and Python (PySpark), including performance tuning on large datasets
• Experience with Azure Databricks, Delta Lake, Delta Live Tables (DLT), Azure Data Factory (or Fabric Data Pipelines), ADLS Gen2, and Azure DevOps/Git for CI/CD
• Working knowledge of Unity Catalog and/or Microsoft Purview for governance, lineage, and security
• Familiarity with data ingestion patterns (files, APIs, JDBC), schema evolution, CDC, and deletion detection patterns
• Understanding of dimensional modeling to produce analytics‐ready datasets for Power BI
• Exposure to orchestration/monitoring, cost optimization, alerting, and runbook‐driven operations
• Data pipeline design (batch & streaming), DLT expectations for data quality, and robust error handling
• Source control, branching strategies, and CI/CD for data assets (notebooks, jobs, workflows)
• Practical understanding of privacy, security, and RBAC in cloud data platforms
• Excellent communication, documentation, and cross‐functional collaboration skills
• Analytical mindset; bias toward automation and measurable reliability

Benefits

• Medical, dental, vision and life insurance coverage
• Competitive pay and a matching 401(k) plan
• Vacation, Company Holidays, Paid Time Off (PTO- personal and sick days)
• Flexible spending accounts/Health savings account
• Wellness Incentive Programs
• Employee Referral Program
• Tuition Reimbursement