Data & Reporting Application Engineer

Data & Reporting Application Engineer / Senior Software Engineer with a strong focus on SQL, Databricks, Power BI, automation, and application support. Essential Job Functions Design, develop, test, and maintain software applications, databases, and reporting solutions that support business operations and decision-making. Develop and maintain complex SQL scripts, stored procedures, data transformations, and database objects to support reporting and application requirements. Lead and support the migration of data solutions from SQL Server environments to Databricks, ensuring data integrity, performance, and scalability. Design, maintain, and optimize Power BI reports, dashboards, datasets, and semantic models to deliver accurate and actionable business insights. Develop advanced DAX measures, calculations, and data models to support complex business reporting requirements. Manage and troubleshoot multiple data connections within Power BI, including SQL databases, Databricks environments, APIs, files, and Power BI semantic models. Maintain and enhance Power Automate workflows that support data ingestion, reporting automation, file transfers, and business processes. Support automated processes such as: Loading Power BI data into SQL databases. Transferring email attachments from shared mailboxes to FTP locations for downstream processing. Monitoring and resolving workflow failures. Perform root cause analysis of data discrepancies, identify data quality issues, and implement corrective actions. Collaborate closely with business stakeholders to investigate reporting issues, define requirements, and develop sustainable solutions. Manage SSL certificate renewals and installations for web applications, services, and supporting infrastructure to ensure security and compliance. Monitor application and reporting environments, proactively identifying risks, performance issues, and opportunities for improvement. Debug and resolve production issues across applications, databases, reporting platforms, and automation solutions. Participate in architecture, design, and code reviews, ensuring adherence to development standards and best practices. Evaluate and recommend new technologies, tools, and processes that improve efficiency, scalability, and reliability. Embrace and promote the adoption of AI technologies across reporting, data, automation, and application support processes by continuously evaluating where AI can be applied to improve efficiency, productivity, decision-making, user experience, and business outcomes.

Bachelor's degree in Computer Science, Information Technology, Data Engineering, Software Engineering, or equivalent experience. Typically 5+ years of experience in software development, data engineering, reporting, or application support roles. Strong expertise in SQL development, query tuning, stored procedures, data modeling, and database design. Experience with Databricks and modern cloud-based data platforms. Advanced knowledge of Power BI, including: Data modeling, DAX measures, Semantic models, Report and dashboard development, Data gateway and connection management Experience with ETL/ELT processes and data integration solutions. Experience developing and maintaining Power Automate workflows and process automation solutions. Knowledge of SSL certificates, certificate lifecycle management, and application security best practices. Strong analytical and problem-solving skills with the ability to investigate and resolve complex data issues. Ability to work directly with business stakeholders to gather requirements and translate them into technical solutions. Strong communication, documentation, and collaboration skills. Demonstrated ability to manage multiple priorities and take ownership of critical business systems. Experience working with Azure DevOps (ADO) for Agile project delivery, work item management, defect tracking, and release coordination. Demonstrated interest in AI