Principal Software Engineer, Real-Time Reporting Engine

About your new role:

As a Principal Software Engineer and Data Architect, you will be instrumental in designing and building a real-time, scalable, and customizable reporting system that empowers users to interact with and analyze business-critical data instantly. You will lead the architecture and development of this system, integrating it into our current Azure-based, Python, PHP, and MariaDB ecosystem. This is a high-impact role where you’ll work cross-functionally to ensure that our reporting tools deliver fast, accurate insights with an intuitive user experience.

This is a 100% Remote, Full-Time opportunity.  

Key Responsibilities:

Architect and Develop the Reporting System:

• Design and implement a real-time reporting engine that can support complex queries and large data volumes across various business areas.
• Create a flexible, scalable data infrastructure that can handle dynamic report generation and ad-hoc queries efficiently.

Data Pipeline and Integration:

• Lead the design and optimization of ETL pipelines to collect, process, and analyze data from multiple sources.
• Develop and maintain a metadata-driven data model to allow for dynamic schema mapping and real-time reporting.

Performance and Scalability Optimization:

• Build a high-performance data architecture capable of handling concurrent reporting queries without latency issues.
• Ensure scalability to support growing data volumes, complex analytics, and reporting demands, leveraging best practices in cloud architecture.

User-Centric Reporting Features:

• Develop customizable reporting templates, dashboards, and visualizations that meet user needs for flexible data slicing and analysis.
• Integrate self-service and drill-down capabilities to enable users to explore data and derive insights independently.

Collaboration and Leadership:

• Collaborate with stakeholders across product, data, and engineering teams to understand reporting requirements and translate them into technical specifications.
• Mentor and lead other engineers in best practices for data architecture, reporting, and analytics.

What you'll need for success

• 8+ years of experience in software engineering with a focus on data engineering or architecture.
• Proven experience in building real-time or near-real-time data processing/reporting systems.
• Strong background in cloud platforms, ideally with Azure; experience with Azure services like Data Lake, Synapse, or CosmosDB is a plus.

Technical Skills:

• Advanced Python, PHP, and SQL skills, with experience in data manipulation and database design.
• Proficiency with MariaDB or similar relational databases; familiarity with NoSQL databases and data warehousing is advantageous.
• Strong understanding of ETL frameworks and data pipeline tools (e.g., Apache Airflow, Azure Data Factory).

Architectural Skills:

• Extensive experience in designing scalable, efficient data architectures and optimized schemas for high-performance reporting.
• Strong knowledge of microservices and event-driven architecture to enable real-time data processing.
• Experience in metadata-driven design and query engines (similar to Apache Druid, Presto, or BigQuery).

Soft Skills

• Excellent communication skills to collaborate with both technical and non-technical stakeholders.
• Strong analytical and problem-solving abilities to tackle complex reporting and data architecture challenges.
• Ability to lead and mentor engineers in best practices for data architecture and reporting

Why you'll love life at Command|Link

Join us at CommandLink, where you'll have the opportunity to shape the future of business communication. We value the innovative spirit and seek individuals ready to bring their unique vision and expertise to a team that values bold ideas and strategic thinking. Are you ready to make an impact?

• Room to grow at a high-growth company
• An environment that celebrates ideas and innovation
• Your work will have a tangible impact
• Generous Medical, Dental, and Vision coverage for full-time employees
• Flexible time off  
• 401k to help you save for the future
• Fun events at cool locations
• Free DoorDash lunches on Fridays
• Employee referral bonuses to encourage the addition of great new people to the team

Commandlink hires individuals in a number of geographic regions and the pay ranges listed reflect the cost of labor across these regions. The base pay for this position as displayed at the bottom of the job description is a range based on our lowest geographic region, up to our highest geographic region. Pay is based on location among other factors, such as skill-set, experience, and qualifications held.