Build and maintain cloud-based data pipelines, notebooks, data products, and Power BI reports using Azure, Databricks, or Microsoft Fabric. Analyze data to identify root causes and communicate business findings. Develop Python and SQL solutions, apply testing, version control, and CI/CD practices, and support client proposals and demonstrations while growing toward independent client-facing consulting.
About This Position
Kenway Consulting is currently looking for a Data, Analytics & Cloud Engineering Consultant. Above all, this is a consulting role: our consultants are trusted advisors who take the time to understand each client’s business, build strong working relationships, and help solve their critical technology and business problems. Data, analytics, and cloud engineering are the disciplines through which this Consultant will deliver that value — building solutions on modern cloud data platforms and, just as importantly, analyzing the data itself to investigate root causes and interpret what the business is seeing.
Kenway Consulting is currently looking for a Data, Analytics & Cloud Engineering Consultant. Above all, this is a consulting role: our consultants are trusted advisors who take the time to understand each client’s business, build strong working relationships, and help solve their critical technology and business problems. Data, analytics, and cloud engineering are the disciplines through which this Consultant will deliver that value — building solutions on modern cloud data platforms and, just as importantly, analyzing the data itself to investigate root causes and interpret what the business is seeing.
The Consultant should have a passion for helping clients make better decisions with data, along with the communication skills and professionalism to represent Kenway well. This is an early-career role, and the Consultant will work closely with a collaborative team of senior engineers and architects who will support their growth into a well-rounded, client-facing advisor. They should enjoy working with a collaborative team and for clients of varying sizes and industries, and be eager to take ownership of their work.
Core Traits We Are Seeking
Core Traits We Are Seeking
- Entrepreneurship: Passion to fuel growth by helping clients, peers, the organization, and yourself, with a continuous hunger to learn.
- Tenacity: Ability to drive through ambiguity.
- Professional Presence: Clear, concise, and articulate when using written and verbal channels.
- Communication: Adept at communicating quickly and effectively, whether the message is good or bad.
- Aptitude: You climb steep learning curves quickly.
- Integrity: Comfortable doing what is right for the project even when doing so may not be the most favorable path forward.
- Growth Mindset: Proactively develop core skills independently and with the help of others.
Responsibilities
- Build and maintain scalable, performant, and cost-effective data pipelines, notebooks, and data products (including Power BI reports) on modern cloud data platforms, under the direction of senior engineers and architects
- Analyze data to investigate problems, identify root causes, and interpret what the business is seeing — then communicate those findings clearly
- Write clean, well-structured Python and SQL to move, model, transform, and analyze data
- Apply software-delivery discipline to data assets — version control, testing, and CI/CD-based deployment across environments
- Take ownership of defined technical tasks and deliver them with increasing independence
- Support the proposals, demos, and collateral leveraged in business development pursuits
Qualifications & Credentials
- Qualification(s) in data analytics, information management, computer science, or equivalent practical experience
- 1–3 years of experience (including internships / co-ops) building, implementing, and maintaining data solutions on Modern Data Platforms, inclusive of the following:
- Cloud architecture and engineering, with a focus on Microsoft Azure — a working understanding of core Azure data services (e.g., storage, compute, Synapse, OneLake) and how they combine to support a data platform, plus hands-on exposure to cloud engineering practices such as provisioning and configuring resources, managing access and secrets (RBAC, managed identities, Key Vault), and building with cost and security in mind
- Hands-on exposure to modern data platforms, specifically Databricks and/or Microsoft Fabric — building and running data pipelines and developing in notebooks
- Proficiency in Python and SQL, with a demonstrated ability to perform real analysis — not just query data — including SQL performance and tuning fundamentals
- Analytical problem-solving — the ability to explore data, investigate anomalies, reason from symptoms to root cause, and translate findings into a clear explanation of what the business is seeing
- Exposure to AI in the modern data and analytics stack — familiarity with how AI is reshaping data work, such as AI-assisted and conversational analytics (e.g., Databricks Genie, Microsoft Fabric Copilot / Data Agents), applying large language models to data problems, and using AI coding assistants to work more effectively, with the curiosity to keep pace as these tools evolve
- An understanding of how CI/CD and DevOps should work in the data space, including:
- Git-based version control of pipelines, notebooks, and data models
- Promoting code across development, test, and production environments
- Automated testing, logging, and alerting for data pipelines
- Familiarity with relevant tooling (e.g., Azure DevOps, GitHub Actions, dbt, Databricks Asset Bundles / Repos, or Fabric deployment pipelines)
- Working knowledge of ELT/ETL approaches, including batch and, ideally, real-time or event-driven processing
- Familiarity with Data Lake, Data Lakehouse, and Data Warehouse concepts
- Familiarity with data modeling and data transformation (e.g., dbt)
- Exposure to Agile ways of working and delivery tooling such as JIRA or Azure DevOps Boards
- Business acumen — able to connect technical work to the business problem it solves, and to take ownership of defined work and deliver value with limited oversight
What our Company looks like
Kenway Consulting is a Management and IT consulting firm looking to expand our growing staff. Your strengths in leading teams across the designing, implementing and constructing reusable services and frameworks are needed to drive the solutions to our clients’ critical technology and business problems. You will have the opportunity to make an immediate impact with our world-class clients. Our projects tend to focus primarily on enterprise solutions, straddling our clients’ technology and business organizations. Our solution-based approach leverages the diverse combination of skills and experience of our staff. We strive to provide the highest possible quality work product delivered by our dynamic and collaborative consultants. We provide an inclusive team-driven environment, working together to identify clients, technologies and people in support of Kenway’s ambitious growth targets. We are focused on the unique skills and interests of each individual staff member. We offer numerous career paths and opportunities to continually develop your skills and experience. We offer a supportive environment and recognize that you have a life outside of your job. We staff project teams to deliver the highest quality work for our clients while honoring the many facets of our consultants’ lives.
What we offer our Employees:
Kenway offers the ability to chart your individual career path based on your expertise and passions. An environment that encourages you to identify new opportunities and the support to make it happen. An atmosphere that promotes a balanced lifestyle by working with local (Chicagoland) and national clients in a flexible consulting model. The opportunity to build and be part of a fun and collaborative team. A competitive compensation package and exceptional benefits.
What we offer our Employees:
Kenway offers the ability to chart your individual career path based on your expertise and passions. An environment that encourages you to identify new opportunities and the support to make it happen. An atmosphere that promotes a balanced lifestyle by working with local (Chicagoland) and national clients in a flexible consulting model. The opportunity to build and be part of a fun and collaborative team. A competitive compensation package and exceptional benefits.
About
Kenway Consulting is a management and technology consulting firm whose entire reason for existence is to help companies and its employees. Founded in 2004 on the principles of being good and being truthful, Kenway’s set of Guiding Principles steers each employee’s decision-making process and centers on integrity, quality, value and respect. The company focuses on the means and not the outcomes, always in line with these Guiding Principles, and always with integrity as its cornerstone. Kenway strives to provide all clients with unmatched quality and service, and specializes in customized business solutions using its Application Development, Artificial Intelligence, Contact Center Solutions, Data and Analytics, Data Compliance and Privacy, Program and Product Management, and Salesforce practices.
Kenway Consulting LLC Chicago, Illinois, USA Office
200 N. LaSalle Street , Suite 1850, Chicago, IL, United States, 60601
Similar Jobs
Big Data • Cloud • Software • Database
Design scalable MongoDB-based systems, advise customers on architecture and optimization, and partner with sales teams on technical discovery, demonstrations, proofs of value, presentations, sizing, and account strategy. Generate demand through technical initiatives and events, build customer relationships, mentor colleagues, and provide product feedback. The role requires strong software, cloud, distributed-systems, communication, and enterprise pre-sales expertise.
Top Skills:
Apache KafkaAWSCC#C++Cloud ComputingData ModelingDatabasesDevOpsDistributed SystemsGenerative AiGCPJavaKubernetesMicroservicesAzureMongoDBMongodb AtlasNode.jsPythonRagSQL
AdTech • eCommerce • Food • Marketing Tech • Retail
Builds and operates enterprise observability capabilities, including synthetic monitoring, SNMP telemetry, dashboards, alerts, integrations, and event-management workflows. The role maintains Reveille and Datadog environments, onboards applications and infrastructure, automates platform tasks, troubleshoots data collection, supports upgrades and incidents, and partners with application, infrastructure, SRE, and operations teams to improve reliability and reduce alert fatigue.
Top Skills:
APIsAzure DevopsBashCi/CdDatadogDatadog SyntheticsLogsMetricsMibObservability PlatformsPowershellPythonReveilleServicenowSnmpSynthetic MonitoringTracesVersion Control
Cloud • Information Technology • Security • Software • Cybersecurity
As a Security Architect, you will build secure agent runtimes and systems, ensuring robust security capabilities in agentic AI solutions while conducting security evaluations.
Top Skills:
AWSAzureGCPKubernetesNode.jsPythonTypescript
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
