Data Automation Architect & Analytics Engineer

RedCloud Consulting is a global business and technology consulting firm supporting clients across North America, Europe, Asia-Pacific, and the Middle East. For more than two decades, RedCloud has partnered with organizations ranging from high-growth mid-market companies to global enterprises, helping them solve complex business and operational challenges—leveraging modern data platforms, artificial intelligence, and secure digital foundations to drive smarter decisions and scalable outcomes.

RedCloud seeks a Data Automation Architect & Analytics Engineer to support immediate client operations.

Location: Remote – United States

Overview:
We are seeking a highly hands on data automation architect and analytics engineer to modernize and automate an existing analytics and reporting framework that is currently dependent on manual processes. The primary focus of this role is to automate an existing ETL process end to end, improve reliability and repeatability, and evolve the solution toward a scalable self-service model that can be replicated across teams.
This role requires proactive, independent execution with a continuous delivery mindset. You will be expected to produce tangible deliverables every 1 to 2 weeks, regularly demonstrate progress, and move forward through ambiguity. You will partner closely with senior stakeholders and technical leads, operate as a technical peer, and actively question assumptions to propose more efficient architectures and workflows.

Responsibilities include but are not limited to:

• Automate an existing ETL workflow by understanding the current process, connecting it to new pipelines, performing required transformations, and loading curated data into the presentation layer.
• Ingest and integrate data from a broad set of internal sources that may include SQL queries, BI reports, and data cubes, and ensure the data is usable after ingestion through appropriate transformations and validation.
• Design and build the automation infrastructure primarily using a modern analytics platform such as Fabric while continuing to leverage SQL where needed.
• Deliver post transformation data to reporting and downstream consumers, including a Power BI reporting layer and external blob storage destinations used by other teams and partners.
• Evaluate existing pipelines, queries, endpoints, and refresh processes to identify inefficiencies and redesign for scale, resilience, and improved refresh cadence.
• Create parameterized automation patterns that allow business users to control configuration inputs such as filters, with governance considerations such as change tracking and auditability.
• Explore a lightweight configuration interface approach using tools such as Power Apps to enable non engineering users to adjust parameters without code changes.
• Operate with a self-serve working style by independently seeking access, documentation, and cross-team help wherever possible, escalating only after other paths have been exhausted.
• Provide frequent progress visibility to stakeholders through demos, working sessions, and iterative deliverables from day one.
• Contribute to a long-term reference architecture and repeatable model that can be adopted by other teams.

Required Knowledge, Skills, and Abilities:

• Strong SQL expertise.
• Hands on experience with Power BI, including supporting or evolving reporting solutions connected to automated pipelines.
• Experience with Fabric or the ability to ramp quickly across key capabilities such as lakehouse patterns, pipelines, and dataflows.
• Understanding of cloud-based data architectures and analytics services, such as data lakes, Synapse, and Kusto or equivalent technologies.
• Demonstrated experience automating analytics workflows and reducing manual operational overhead through repeatable engineering patterns.
• Ability to independently perform discovery by reading pipelines, reviewing queries, interpreting endpoints, and synthesizing findings into clear recommendations.
• Strong analytical mindset with the ability to question existing logic, identify better sources, and surface improvement opportunities.
• Proven ability to execute proactively with a continuous delivery approach and to produce tangible deliverables every 1 to 2 weeks.
• Experience implementing self-service configuration patterns for business users, including configurable inputs and change tracking.
• Experience designing data delivery paths that support both reporting consumers and downstream operational consumers, including file or blob-based distribution.
• Strong communication skills to collaborate effectively with both technical and non-technical stakeholders.

Compensation range for this position is $148,500 - $181,500/year DOE.
Benefits and bonus information can be found at https://www.redcloudconsulting.com/careers

RedCloud requires employees have the legal ability to work in the country hired during their employment period. During onboarding, proof of eligibility to work in the applicable country will be requested. RedCloud does not provide visa sponsorship.

About Us:
Anchored in a foundation of integrity-based consulting, RedCloud brings together senior-level experts who work side by side with client teams to design and implement durable, high-impact solutions. Our approach emphasizes trust, accountability, and long-term value—balancing stability, growth, and innovation to help organizations operate securely and confidently in an increasingly complex global environment.

RedCloud delivers a comprehensive range of services across its core practices: Data & AI, Delivery Excellence, Digital Solutions, Marketing & Sales, Privacy, Security, Data Center and Critical Infrastructure Security, and Strategy & Transformation. As our clients expand globally, so do we—providing consistent, expert support across regions while remaining agile, collaborative, and deeply invested in client success.

Recognized for both performance and culture, RedCloud has been named #1 Best Company to Work For in Washington (Mid-Sized Businesses) by Seattle Business Magazine, a “Fastest Growing Company” multiple times on the Inc. 500/5000 list, and recognized by Consulting Magazine as a Leader in Technology Consulting.

Visit http://www.redcloudconsulting.com/ for more info.
#LI-Remote